IBM Certification MCQ

Test your knowledge with important IBM Certification MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more IBM Certification MCQs at Bissoy

• Proxy servers have two main purposes : 1. Improve Performance (and) 2. is ______ ?
  ক

  Transmit Request

  খ

  Decrease Requests

  গ

  Increase Requests

  ঘ

  Filter Requests
• which of the following represents a set of properties that guarantee that database transactions are processed reliably in computer science ?
  ক

  Buffer Cache

  খ

  ACID

  গ

  Foreign Key

  ঘ

  None
• A solution developer needs to configure the HTTP listener of an Integration Server on a Linux Server. Which operating system privileges does the developer need to modify Integration node<br />properties and properties of integration node resources?
  ক

  root user

  খ

  mqm

  গ

  mqbrks

  ঘ

  mqm and mqbrks
• With database logging, where are transaction records first placed?
  ক

  in the logical log buffer

  খ

  in the primary chunk

  গ

  in the physical buffer

  ঘ

  in a temporary database table
• Suppose an installed z/OS customer also has Power6 Servers. They are investigating consolidation of both types of servers to z/OS.Which of the following will establish the capacity for a new z/OS server?
  ক

  AD Tools

  খ

  CP3000

  গ

  Estimate the AIX load and add to CP3000 results.

  ঘ

  Run AIX in a z\/OS LPAR to establish the loadWArialTimes New RomanZ
• Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?
  ক

  CLOB

  খ

  TIME

  গ

  VARCHAR

  ঘ

  TIMESTAMP
• The DBA can set the registry variable DB2_HASH_JOIN on or off because:
  ক

  hash joins may require more resources to run.

  খ

  hash joins are not used unless outer joins are requested.

  গ

  If hash joins are enabled, no other join method can be used.

  ঘ

  Hash joins are only needed when the tables are portioned using hash keys.
• Which of the following extenders allows data to be presented in a three dimensional format?
  ক

  DB2 AVI Extender

  খ

  DB2 XML Extender

  গ

  DB2 Text Extender

  ঘ

  DB2 Spatial Extender
• Suppose a customer is attempting to determine what failed during the last boot sequence of the Linux partition. Which of the following can be used to determine the error condition?
  ক

  \/var\/log\/messages

  খ

  \/proc\/startup

  গ

  \/usr\/sbin\/log

  ঘ

  \/etc\/boot
• Which of the following is required for the DB2 optimizer to consider a hash join strategy?
  ক

  Optimization level 1 or above

  খ

  Equijion predicates

  গ

  Registry variable DB_ANTIJOIN=YES

  ঘ

  SORTHEAP large enough to contain the tables being joined
• Suppose a System z customer has a new CIO. The CIO is concerned about continuing operations and recovery following a catastrophe.Which of the following addresses this issue?
  ক

  GDPS

  খ

  TAM

  গ

  DR

  ঘ

  WASS
• If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what?
  ক

  committed read

  খ

  repeatable read

  গ

  share read

  ঘ

  indexed read
• Which isolation level does a database without logging default to?
  ক

  committed read

  খ

  dirty read

  গ

  mode ANSI

  ঘ

  repeatable read
• Which of the following tools can be used to identify inefficient SQL statements without executing them?
  ক

  QMF

  খ

  Task Center

  গ

  Visual Explain

  ঘ

  Development Center
• What is a chunk when using raw devices?
  ক

  a dynamic unit of disk space

  খ

  a location in shared memory

  গ

  a contiguous unit of disk space

  ঘ

  a data table
• Where is fragment information stored?
  ক

  in the physical logs

  খ

  in the reserved pages

  গ

  in the system catalog tables

  ঘ

  in the first page of the database tblspace
• Suppose a customer is planning to create a non-hosted Linux partition on an i825. Linux will have only direct-attach devices. What is the Linux console option?
  ক

  Use OS\/400 VNC support.

  খ

  Telnet to the virtual console.

  গ

  Share the primary partitions console.

  ঘ

  Allocate a console IOA to the Linux partition.
• Which of the following tools is used to create subscription sets and add subscription?set members to subscription sets?
  ক

  Journal

  খ

  License Center

  গ

  Replication Center

  ঘ

  Development Center
• How To improve system redundancy using its grid architecture, where in the XIV System can a partition be mirrored?
  ক

  on same disk in different modules

  খ

  on disks in other modules

  গ

  on different disks in the same module

  ঘ

  on same disk, in same module, and in different modules
• A VM/VSE customer wants to implement a WAS on an existing zSeries server. On which of the following operating environments would WAS best be implemented?
  ক

  VSE

  খ

  z\/VM

  গ

  z\/OS

  ঘ

  Linux
• Which statement correctly changes the next extent size?
  ক

  ALTER TABLE customer MODIFY NEXT SIZE 300

  খ

  ALTER TABLE customer MODIFY NEXT EXTENT SIZE 300

  গ

  ALTER TABLE customer MODIFY EXTENT SIZE 300

  ঘ

  ALTER TABLE customer NEXT SIZE 300
• What is a requirement to connect a V6R1 IBM i host to an XIV Storage System?
  ক

  XIV firmware V10.0.8

  খ

  Host Attachment Kit V1.0.1

  গ

  SAN Volume Controller (SVC)V4.2

  ঘ

  Virtual I\/O Server (VIOS) V2.1.1
• Which of the following commands will allow a Linux on iSeries administrator to quickly scan backup tapes for files saved via a tar command on a Linux system?
  ক

  The Linux command mt

  খ

  The Linux command cpio

  গ

  The OS\/400 command RST option(*print)

  ঘ

  The OS\/400 command DSPTAP option(*savrst)
• Which of the following can be kept in memory when the DB2 configuration parameter KEEPFENCED is enabled?
  ক

  SQLDAS after their cursor is closed.

  খ

  Referential integrity maps after a join.

  গ

  Stored procedure processes after they are run.

  ঘ

  Tables after they have been read into the buffer pool.
• What help ensure that the XIV Systems cache does not become a bottleneck?
  ক

  central cache locking mechanism

  খ

  use of industry standard chip technology

  গ

  each module is responsible for caching the data in that module

  ঘ

  having all modules understand what is held cache at all times
• What are the advantages of fragmentation?
  ক

  reduced disk space requirements

  খ

  higher availability

  গ

  finer granularity of archives and resources

  ঘ

  parallel scans are possible with PDQ