What must you do before an online table space backup operation can be performed?
A. Create an incremental backup image of the table space.
B. Set the DB2_ENABLE_ONLINEBKUP registry variable to ON.
C. Create a full database backup image.
D. Create one or more tables in the table space.
正解:C
質問 2:
Where is the HADR_TARGET_LIST configuration parameter set?
A. On the tertiary standby databases.
B. On all participating databases.
C. On the primary database only.
D. On the auxiliary standby databases only.
正解:B
質問 3:
Which statement about block indexes is correct?
A. Prefetching of data pages relies on sequential detection when block indexes are used.
B. Block indexes improve performance when data is not clustered on sequential pages.
C. The records for each block are retrieved using a mini-relational scan of saved data pages.
D. Because of their large size, block indexes are extremely efficient.
正解:A
質問 4:
What event category is used with the db2audit command to capture SQL data, such as host variable and parameter marker values, that are associated with an SQL statement?
A. EXECUTE
B. CONTEXT
C. VALIDATE
D. AUDIT
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
A DBA wants to create a table named SALES that has the following characteristics: ?effective data clustering and management of space utilization ?rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?
A. ORGANIZE BY TIME PERIOD
B. ORGANIZE BY DIMENSIONS
C. ORGANIZE BY INSERT TIME
D. ORGANIZE BY KEY SEQUENCE
正解:C
質問 6:
A database administrator needs to create a federated database and configure access to join data from 3 Oracle instances, 2 SQL Server instances, and 1 DB2 database. Which objects are needed to establish the specified connections?
A. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, and nicknames for all databases.
B. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, 1 DB2 server, 1 DB2 wrapper, and nicknames for alldatabases.
C. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, and nicknames for all databases.
D. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, 1 DB2 server, 1 DB2 wrapper, and nicknames for alldatabases.
正解:B