Which statement is correct when describing trusted contexts?
A. A trusted context defines a trust relationship between a user and a table allowing that user additional capabilities.
B. A trusted context defines a trust relationship for a connection between the database and an external entity.
C. A trusted context promotes the authorization level of the connection initiator and grants them DBADM authority.
D. A trusted context gives the database connection the ability to bypass auditing since authentication has already occurred.
正解:B
質問 2:
Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?
A. UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2
B. db2set SECONDARY_DIAGPATH=/db2data/db2dump2
C. db2set ALT_DIAGPATH=/db2data/db2dump2
D. UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2
正解:D
質問 3:
Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command should be used to recover the database and repair the corruption in table space TBSP_1?
A. ROLLFORWARD DATABASE
B. RESTORE DATABASE
C. RESTORE TABLESPACE
D. RESTART DATABASE
正解:B
質問 4:
If the following statement is executed:
What indexes will be created for table TAB1?
A. 1 dimension-block index and 1 composite-block index
B. 3 dimension-block indexes and 1 composite-block index
C. 3 dimension-block indexes and 3 composite-block indexes
D. 1 dimension-block index and 3 composite-block indexes
正解:B
質問 5:
Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command can be used to recover the database and repair the corruption in table space TBSP_1?
A. ROLLFORWARD DATABASE
B. RECOVER DATABASE
C. RESTORE TABLESPACE
D. RESTART DATABASE
正解:B
質問 6:
If the following command is executed:
CREATE DATABASE sample RESTRICTIVE
Which statement is true?
A. PUBLIC will hold only SELECT privilege on the system catalog views.
B. The RESTRICT_ACCESS database configuration parameter must be set to YES by the creator.
C. Only the creator is allowed to access the SAMPLE database.
D. No authorities or privileges will be granted to PUBLIC.
正解:D