최신IBM DB2 11.1 DBA for LUW - C2090-600무료샘플문제
문제1
Which of the following are valid Explain operators? (Choose two.)
Which of the following are valid Explain operators? (Choose two.)
정답: B,C
문제2
A table named MYTABLE contains an XML column and an XML storage object dictionary already exists.
What is the effect of enabling compression and then running the command REORG TABLE mytable
KEEPDICTIONARY?
A table named MYTABLE contains an XML column and an XML storage object dictionary already exists.
What is the effect of enabling compression and then running the command REORG TABLE mytable
KEEPDICTIONARY?
정답: D
문제3
Which statement regarding event monitors is TRUE?
Which statement regarding event monitors is TRUE?
정답: C
문제4
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
정답: A
문제5
If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sgl ON '/datal';
CREATE STOGROUP ibmstogroup ON '/data2';
CREATE STOGROUP sg2 ON '/data3';
Which storage group is the default storage group for the TESTDB database?
If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sgl ON '/datal';
CREATE STOGROUP ibmstogroup ON '/data2';
CREATE STOGROUP sg2 ON '/data3';
Which storage group is the default storage group for the TESTDB database?
정답: A
문제6
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?
정답: B