IBM Certification Interview Preparation Guide
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 youre interview-ready.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.
6 :: Explain 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?
A The Linux command mt
B The Linux command cpio
C The OS/400 command RST option(*print)
D The OS/400 command DSPTAP option(*savrst)
B. The Linux command cpio
7 :: Suppose A customer has ordered a 10 module XIV System. How many interface modules are active in this configuration?
B. 4
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