IBM Information Management DB2 10 Technical Mastery Test v3 - 000-N18 Exam Practice Test

A. HADR allows up to two HADR standby databases.

B. HADR allows up to three HADR standby databases.

C. HADR allows up to five HADR standby databases.

D. HADR allows up to four HADR standby databases.

A. Multi-temperature data management reduces the total cost of ownership by allowing efficient deployment of storage hardware with minimal administrative overhead.

B. Multi-temperature data management best practices recommend that cold data should be stored in faster devices in order to maximize overall system performance.

C. Multi-temperature data management integrates with DB2's Workload Manager feature to let you prioritize your workloads based on the data being accessed.

D. You can use storage groups to implement multi-temperature data management in DB2.

A. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.

B. DB2 Express is fastest and most powerful DB2 edition.

C. DB2 Express is a tool that allows DBAs to quickly solve complex database issues.

D. DB2 Express is designed for development and testing. It is not used as a production database.

A. To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.

B. By default, the Configuration Advisor is automatically executed when you create a new database.

C. It creates database objects such as indexes and MQTs to improve performance.

D. It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.