最新的IBM 000-611免費考試真題

問題1

A table named CUSTOMER and an index named CUST_IDX were created as follows:

Which operation would you expect to see in the access plan diagram produced?

A. IXSCAN

B. HSJOIN

C. NLJOIN

D. TBSCAN

正確答案: A

問題2

The following commands are executed against a database named MY_DB, which has been configured to use archival logging:

Which statement is true?

A. Upon completion of the Load, a backup image of table T1 is automatically generated.

B. Upon completion of the Load, the table T1 is placed into "Backup Pending" state.

C. After a Restore and Rollforward operation, table T1 would be marked unavailable and can only be dropped.

D. After a Restore and Rollforward operation, the loaded data is stored into a copy-image file and table T1 is fully available.

正確答案: C

問題3

If the following statement is executed:

What indexes will be created for table TAB1?

A. 1 dimension-block index and 3 composite-block indexes

B. 1 dimension-block index and 1 composite-block index

C. 3 dimension-block indexes and 3 composite-block indexes

D. 3 dimension-block indexes and 1 composite-block index

正確答案: D

問題4

Which statement regarding snapshot administrative views and snapshot monitor table functions is true?

A. Snapshot administrative views provide the option to choose between data from a single database partition or a data subset from across alldatabase partitions while snapshot table functions provide access to data from each database partition.

B. Snapshot administrative views cannot be used with monitor switches or monitor reset commands while snapshot table functions have no suchrestrictions.

C. Snapshot administrative views provide access to data from each database partition while snapshot table functions provide the option to choosebetween data from a single database partition or a data subset from across all database partitions.

D. Snapshot table functions cannot be used with monitor switches or monitor reset commands while snapshot administrative views have no suchrestrictions.

正確答案: C

問題5

Which statement about BEFORE triggers is FALSE?

A. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.

B. A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.

C. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.

D. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.

正確答案: D

問題6

What can be used to provide input to the Design Advisor?

A. A query workload file.

B. The database configuration file.

C. An XML file.

D. The database manager configuration file.

正確答案: A

問題7

What is the purpose of the Design Advisor?

A. To recommend database configuration parameter changes.

B. To recommend physical changes to objects in a database.

C. To generate query definitions required to create usage reports.

D. To generate profiles for autonomic activity within the database.

正確答案: B

問題8

Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.)

A. A page-level compression dictionary does not already exist for the table.

B. The table does not have any indexes defined on it that have not been enabled for compression.

C. A table-level compression dictionary does not already exist for the table.

D. The table contains a sufficient amount of data.

E. The table is not a system temporary table.

正確答案: C,D

問題9

How is the time that an agent waits for log records to be flushed to disk calculated?

A. LOG_END_TIME divided by TOTAL_COMMITS

B. LOG_WAIT_TIME divided by TOTAL_COMMITS

C. LOG_WRITE_TIME divided by TOTAL_COMMITS

D. LOG_FLUSH_TIME divided by TOTAL_COMMITS

正確答案: C

最新的IBM DB2 10.1 DBA for Linux, UNIX, and Windows - 000-611免費考試真題

聯系我們

站內鏈接

最新更新