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

問題1

What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?

A. Restore the database from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASE command withthe RECOVER DROPPED TABLE option to restore the database and recover the dropped table.

B. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover thedropped table.

C. Restore the appropriate table space from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASEcommand with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.

D. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the droppedtable.

正確答案: C

問題2

Which system command can be used to locate and return only ADM4500W messages from the DB2 diagnostics log file?

A. db2trace

B. db2diag

C. db2pd

D. db2fmtdiag

正確答案: B

問題3

Which statement about the REORGCHK command is true?

A. It automatically calls REORG if it is determined that a reorg is necessary.

B. It cannot be run against multidimensional clustering tables.

C. It cannot be run against the system catalog.

D. It automatically calls RUNSTATS by default.

正確答案: D

問題4

What is the MAX_LOG database configuration parameter used for?

A. To limit the total number of secondary log files a transaction can consume before infinite logging is enabled.

B. To limit how many log files a single transaction can span.

C. To limit the percentage of primary log space a running transaction can consume.

D. To limit the total number of primary and secondary log files a database can consume.

正確答案: C

問題5

A table named SALES was created as follows:

If management wants to use Label-Based Access Control (LBAC) to protect individual rows in the SALES table, and the security policy needed (SEC_POLICY) has already been created, what must be done to protect the table as desired?

A. Add a column with the DB2SECURITYLABEL data type to the SALES table.

B. Associate the SEC_POLICY security policy with the SALES table.

C. Add a SECURED WITH clause to every column in the SALES table and then associate the SEC_POLICY security policy with the SALES table.

D. Add a column with the DB2SECURITYLABEL data type to the SALES table and then associate the SEC_POLICY security policy with the table.

正確答案: D

問題6

Which of the following table types is NOT supported by the load utility?

A. A Temporal table

B. A Multidimensional Clustering table

C. A Global Temporary table

D. A Range Partitioned table

正確答案: C

問題7

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

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

聯系我們

站內鏈接

最新更新