IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Sample Questions:
1. A DBA wants to create a table named SALES that has the following characteristics: ?effective data clustering and management of space utilization ?rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?
A) ORGANIZE BY DIMENSIONS
B) ORGANIZE BY TIME PERIOD
C) ORGANIZE BY KEY SEQUENCE
D) ORGANIZE BY INSERT TIME
2. What must you do before an online table space backup operation can be performed?
A) Set the DB2_ENABLE_ONLINEBKUP registry variable to ON.
B) Create an incremental backup image of the table space.
C) Create a full database backup image.
D) Create one or more tables in the table space.
3. Which configuration parameter setting(s) are needed to force authentication to happen at the data source in a federated database environment?
A) FEDERATED set to YES
B) FEDERATED set to YES FED_NOAUTH set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT
C) FEDERATED set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT
D) FEDERATED set to YES FED_NOAUTH set to YES
4. What can be done to prevent applications from failing when DB2 cannot create a new log file?
A) Set BLK_LOG_DSK_FUL to YES
B) Set MAX_LOG to 0
C) Set LOGSECOND to -1
D) Set LOGBUFSZ to -1
5. Which statement about Q Replication is correct?
A) It uses replication control tables and changed data tables to replicate from the source database to the target database.
B) It uses WebSphere MQ message queues to transmit transactions between source and target databases.
C) It uses continuous log shipping to replicate from the source database to the target database.
D) It uses HADR message queues to transmit transactions between source and target databases.
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: C | Question # 3 Answer: B | Question # 4 Answer: A | Question # 5 Answer: B |
0 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
