IBM Information Management DB2 10 Technical Mastery Test v3 - P2090-018 模擬練習

A. HADR allows up to three HADR standby databases.

B. HADR allows up to four HADR standby databases.

C. HADR allows up to two HADR standby databases.

D. HADR allows up to five HADR standby databases.

A. Authorization is the process where the DB2 database checks with Windows security to see if you have access to the DB2 database.

B. Authorization is the process where the DBA gathers information to see who will have access to the database.

C. Authorization is a process that validates that you are who you claim to be by verifying your user ID and password.

D. Authorization is a process that checks whether you have sufficient privileges to perform the desired database operation.

A. A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.

B. A buffer pool is a logical storage grouping composed of one or more containers.

C. A buffer pool is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as it is read from the physical media.

D. A buffer pool is a DB2 component that manages connections to databases.

A. Table partitioning allows you to create result set tables from a join query, which automatically splits the data into smaller chunks, thereby increasing the performance of your DB2 database.

B. Table partitioning allows you to partition the table data based on the hash values of the primary key.

C. Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing the performance of your DB2 database.

D. Table partitioning allows you to create very large tables that are divided across multiple storage objects so that you can quickly attach and detach large quantities of data from the tables.