A database named MYDB was created as follows: CREATE DATABASE mydb AUTOMATIC STORAGE NO What is the recommended way to convert the database MYDB to an automatic storage database?
A. Use the CREATE STOGROUP statement to define a new storage group in the database and to assign storage paths to the new storage group.
B. Use the UPDATE DATABASE CONFIGURATION command to change the AUTOMATIC STORAGE configuration parameter for the database toYES.
C. Use the ALTER DATABASE statement to add storage paths to the database.
D. Use the DROP DATABASE command to drop the database; then, recreate the database by executing a CREATE DATABASE commandstatement that does not contain the
AUTOMATIC STORAGE NO option.
正解:A
質問 2:
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
質問 3:
Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?
A. IMPORT WITH BUFFERED INSERT
B. INGEST
C. REPLICATION
D. LOAD WITH READ ACCESS
正解:B
質問 4:
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 table-level compression dictionary does not already exist for the table.
B. A page-level compression dictionary does not already exist for the table.
C. The table contains a sufficient amount of data.
D. The table is not a system temporary table.
E. The table does not have any indexes defined on it that have not been enabled for compression.
正解:A,C
質問 5:
How can you remove all effects of compression from an index?
A. Execute the ALTER INDEX statement to turn compression off.
B. Execute the ALTER TABLE statement to turn compression off.
C. Execute the ALTER INDEX statement to turn compression off; then execute the REORG command to removed the compression dictionary.
D. Execute the ALTER TABLE statement to turn compression off; then execute the RUNSTATS command to tell the DB2 optimizer thatcompression is no longer used.
正解:C
質問 6:
When a table space is moved to a new storage group, what action will occur for the containers in the old storage group?
A. They are marked as "Dropped Pending."
B. They are marked as "Move Pending."
C. They are automatically dropped.
D. They are automatically moved to the new table space.
正解:A