IBM Certification Interview Questions And Answers
Download IBM Certification Interview Questions and Answers PDF
Sharpen your IBM Certification interview expertise with our handpicked 38 questions. Each question is crafted to challenge your understanding and proficiency in IBM Certification. Suitable for all skill levels, these questions are essential for effective preparation. Download the free PDF to have all 38 questions at your fingertips. This resource is designed to boost your confidence and ensure you're interview-ready.
38 IBM Certification Questions and Answers:
IBM Certification Job Interview Questions Table of Contents:
1 :: Explain With database logging, where are transaction records first placed?
A. in a temporary database table
B. in the logical log buffer
C. in the primary chunk
D. in the physical buffer
B.in the logical log buffer
Read More2 :: 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?
A. AD Tools
B. Estimate the AIX load and add to CP3000 results.
C. CP3000
D. Run AIX in a z/OS LPAR to establish the loadWArialTimes New RomanZ
B.Estimate the AIX load and add to CP3000 results.
Read More3 :: Explain the Given following DDL statement
CREATE TABLE RMW TABEL46″
11″ INTEGER
D11″ DECIMAL (1′0)NOT NULL
D12″ DECIMAL (1′0) NOT NULL
S7″ SMALLINT
C8″ CHAR(1) WITH DEFAULT)
organize by (
(D12″ ;D11″))
How many indexes will be created?
A. 1
B. 2
C. 3
D. 4
C.3
Read More4 :: Explain Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?
A.CLOB
B.TIME
C.VARCHAR
D.TIMESTAMP
B.TIME
Read More5 :: When Disk space for a table is allocated in one or more units called what?
A. tblspaces
B. extents
C. blobs
D. chunks
B.extents
Read More6 :: Suppose an application bound with isolation level Uncommitted Read updates a row. Which of the following is true regarding the locking of this row?
A.No row lock is acquired when the row is updated.
B.The row lock is released when the cursor accessing the row is closed.
C.The row lock is released when the application issues a COMMIT statement.
D.The row lock is released when the cursor accessing the row is moved to the next row.
C.The row lock is released when the application issues a COMMIT statement.
Read More7 :: The DBA can set the registry variable DB2_HASH_JOIN on or off because:
A. hash joins may require more resources to run.
B. hash joins are not used unless outer joins are requested.
C. If hash joins are enabled, no other join method can be used.
D. Hash joins are only needed when the tables are portioned using hash keys.
A.Hash joins may require more resources to run.
Read More8 :: Explain When creating a regular DMS table space, what is the minimum number of extents that must be specified?
A. 1
B. 3
C. 4
D. 6
E. 8
D.6
Read More9 :: Explain Which of the following commands will format a new disk drive partition in Linux on iSeries?
A mkts -e2 <path to device>
B mkfs.ext2 <path to device>
C mkfs -ext2 &It;path to device >
D mkfs format -e2 <path to device>
B.B mkfs.ext2 <path to device>
Read More10 :: Which of the following extenders allows data to be presented in a three?dimensional format?
A.DB2 AVI Extender
B.DB2 XML Extender
C.DB2 Text Extender
D.DB2 Spatial Extender
D.DB2 Spatial Extender
Read More11 :: 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?
A /var/log/messages
B /proc/startup
C /usr/sbin/log
D /etc/boot
A./var/log/messages
Read More12 :: Explain Which of the following is required for the DB2 optimizer to consider a hash join strategy?
A. Equijion predicates
B. Optimization level 1 or above
C. Registry variable DB_ANTIJOIN=YES
D. SORTHEAP large enough to contain the tables being joined
A.Equijion predicates
Read More13 :: Explain What is database administration NOT concerned with?
A. indexing
B. creating tables
C. accessing data
D. application building
D.Application building
Read More14 :: 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?
A. GDPS
B. TAM
C. DR
D. WASS
A.GDPS
Read More15 :: Explain If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what?
A. committed read
B. repeatable read
C. share read
D. indexed read
B.repeatable read
Read More16 :: In which two situations would you use a round robin fragmentation strategy?
A. When all fragments must be second
B. To create uneven data distributions
C. When queries perform sequential scans and you have little information about the data being stored.
D. When tables are accessed with a high degree of selectivity
A. When all fragments must be second
Read More17 :: Explain Which isolation level does a database without logging default to?
A. committed read
B. dirty read
C. mode ANSI
D. repeatable read
B.dirty read
Read More18 :: Which two of the following table space attributes can be changes after the table space has been created?
A. Page size
B. Extent size
C. Transfer rate
D. Table space type
E. Table space name
B,E:Extent size/Table space name
Read More19 :: Which of the following tools can be used to identify inefficient SQL statements without executing them?
A.QMF
B.Task Center
C.Visual Explain
D.Development Center
Correct:C.Visual Explain
Read More20 :: Which three can be locked?
A. a row
B. a page
C. a column
D. a key
E. shared memory
B:a row/a page
Read More21 :: What is a chunk when using raw devices?
A. a contiguous unit of disk space
B. a dynamic unit of disk space
C. a location in shared memory
D. a data table
A.a contiguous unit of disk space
Read More22 :: Where is fragment information stored?
A. in the system catalog tables
B. in the physical logs
C. in the reserved pages
D. in the first page of the database tblspace
A.in the system catalog tables
Read More23 :: 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?
A Use OS/400 VNC support.
B Telnet to the virtual console.
C Share the primary partitions console.
D Allocate a console IOA to the Linux partition.
B. Telnet to the virtual console.
Read More24 :: Explain Which two of the following SQL data types should be used to store a small binary image?
A.CLOB
B.BLOB
C.VARCHAR
D.GRAPHIC
E.VARCHAR FOR BIT DATA
E:BLOB /VARCHAR FOR BIT DATA
Read More25 :: Explain Which of the following tools is used to create subscription sets and add subscription?set members to subscription sets?
A.Journal
B.License Center
C.Replication Center
D.Development Center
C.Replication Center
