IBM Certification Interview Preparation Guide
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:
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
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.
8 :: What is a requirement to connect a V6R1 IBM i host to an XIV Storage System?
A. XIV firmware V10.0.8
B. Host Attachment Kit V1.0.1
C. SAN Volume Controller (SVC)V4.2
D. Virtual I/O Server (VIOS) V2.1.1
D.Virtual I/O Server (VIOS) V2.1.1
9 :: Which statement correctly changes the next extent size?
A. ALTER TABLE customer MODIFY NEXT SIZE 300
B. ALTER TABLE customer MODIFY NEXT EXTENT SIZE 300
C. ALTER TABLE customer MODIFY EXTENT SIZE 300
D. ALTER TABLE customer NEXT SIZE 300
A.ALTER TABLE customer MODIFY NEXT SIZE 300
10 :: Explain Which two solutions, once installed and configured, can be used to move workloads without disruption? (Choose two)
A. XIV partitions
B. XIV Data Mover (XDM)
C. SAN Volume Controller
D. XIV Data Migration Function
E. Tivoli Storage Productivity Center for Replication V4
C. SAN Volume Controller
D. XIV Data Migration Function
D. XIV Data Migration Function