000-611 試験問題を無料オンラインアクセス

Which command can be used to restore a corrupted database using only the recovery history file?

• A.ROLLFORWARD DATABASE
• B.RESTART DATABASE
• C.RESTORE DATABASE
• D.RECOVER DATABASE

Table TAB_A resides within table space TBSP_1.

Which statement is correct?

• A.The indexes for TAB_A will not be completely rebuilt because the INCREMENTAL indexing mode is used. Instead, new index keys will beappended to the original indexes. This will improve concurrency for the applications that are reading TAB_A during the LOAD operation.
• B.A flash copy of TAB_A will be made at the beginning of the LOAD because of the COPY YES option. This copy allows applications to read thedata that existed in the table prior to the LOAD operation and improves performance since the read operations will not collide with the LOAD.
• C.The indexes for TAB_A will be copied at the beginning of the LOAD operation because of the COPY YES option. Since the indexes will also bebuilt using the INCREMENTAL indexing mode, the concurrency of table TAB_A will be maximized for any applications that wish to access thetable.
• D.TAB_A is a table that has implicitly hidden columns and the file DEL_FILE contains data for both regular columns and hidden columns. Whilenew data is being loaded into TAB_A, applications will be able to read the data that existed prior to the LOAD operation.

Which command is used to export connectivity configuration information from a file known as a configuration profile?

• A.db2cfimp
• B.db2cfexp
• C.db2cfgexp
• D.db2ca

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.HSJOIN
• B.IXSCAN
• C.TBSCAN
• D.NLJOIN

Which authorities can be audited with the AUDIT statement?

• A.SYSADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SECADM cannot.
• B.DBADM, SYSMAINT, ACCESSCTRL, and DATAACCESS can be audited, but SYSADM and SECADM cannot.
• C.SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.
• D.SECADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SYSADM cannot.