Vital IBM Certification Interview Preparation Guide Download PDF
IBM Certification Exams Frequently Asked Questions in various IBM Certification Exams Interviews asked by the interviewer. So learn IBM Certification Exams with the help of this IBM Certification Exams Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any IBM Certification Exams Interview Question or answer by the comment feature available on the page.
38 IBM Certification Questions and Answers:
Table of Contents:
![Vital IBM Certification Job Interview Questions and Answers](https://globalguideline.com/public/images/interview/27.png)
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
2 :: 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.
6 :: 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.
7 :: 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.
9 :: 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>
10 :: 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
13 :: Explain What is database administration NOT concerned with?
A. indexing
B. creating tables
C. accessing data
D. application building
D.Application building
16 :: 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
18 :: 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
19 :: 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
21 :: 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
22 :: 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
24 :: 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
25 :: 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
![IBM Certification Interview Questions and Answers](https://globalguideline.com/public/images/interview/5.png)