1⟩ Explain What are three advantages of fragmentation? A. higher availability B. reduced disk space requirements C. parallel scans are possible with PDQ D. finer granularity of archives and resources
A.higher availability
IBM Certification
Home Certifications IBM Certification
“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
2⟩ Explain Given the following SQL statement GRANT REFERENCES ON TABLE tab1 TO USER usera Which of the following describes what USERA is allowed to do? A.Create a read?only view using TAB1. B.Alter TAB1 to add a check constraint. C.Define a primary key or unique constraint on TAB1. D.Define a dependent table where TAB1 is the parent.
D.Define a dependent table where TAB1 is the parent.
3⟩ What help ensure that the XIV Systems cache does not become a bottleneck? A. central cache locking mechanism B. use of industry standard chip technology C. each module is responsible for caching the data in that module D. having all modules understand what is held cache at all times
C.Each module is responsible for caching the data in that module
4⟩ Which statement fragments a table as round robin? A. FRAGMENT AS ROUND ROBIN IN dbspace 1, dbspace 2 B. FRAGMENT TABLE BY ROUND ROBIN IN dbspace1, dbspace 2 C. FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2 D. FRAGMENT BY ROUND ROBIN
C.FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2
5⟩ Which of the following can be kept in memory when the DB2 configuration parameter KEEPFENCED is enabled? A. SQLDAS after their cursor is closed. B. Referential integrity maps after a join. C. Stored procedure processes after they are run. D. Tables after they have been read into the buffer pool.
C.Stored procedure processes after they are run.
6⟩ 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.
7⟩ 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>
8⟩ 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
9⟩ 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
10⟩ 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
11⟩ 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
12⟩ Explain What is database administration NOT concerned with? A. indexing B. creating tables C. accessing data D. application building
D.Application building
13⟩ 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
14⟩ 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
15⟩ 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
16⟩ 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
17⟩ 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
18⟩ 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
19⟩ 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
20⟩ 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
