최신IBM DB2 9.7 Advanced DBA for LUW - C2090-544무료샘플문제
문제1
Which option of the REORG TABLE statement will release blocks that contain no rows from a multi-dimensional clustering (MDC) table?
Which option of the REORG TABLE statement will release blocks that contain no rows from a multi-dimensional clustering (MDC) table?
정답: B
문제2
A DBA has configured an Oracle data source in a federated database (that references a table named ORA1). How do you update the statistics for table ORA1 at the federated server?
A DBA has configured an Oracle data source in a federated database (that references a table named ORA1). How do you update the statistics for table ORA1 at the federated server?
정답: C
문제3
Which command CANNOT be used to create the compression dictionary for a table?
Which command CANNOT be used to create the compression dictionary for a table?
정답: D
문제4
A user with Security Administrator (SECADM) authority executes the following statements:
If user USER2 queries the table S.TAB1, how many rows will be returned?
A user with Security Administrator (SECADM) authority executes the following statements:
If user USER2 queries the table S.TAB1, how many rows will be returned?
정답: D
문제5
A database and a table space were created using the following commands:
Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert both the database and table space TBSP1?
A database and a table space were created using the following commands:
Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert both the database and table space TBSP1?
정답: B
문제6
Which command would be used to obtain the name of the first active log file for a database with log retain enabled?
Which command would be used to obtain the name of the first active log file for a database with log retain enabled?
정답: D
문제7
Which type of table queue is used to pass data between database partitions when rows are being fetched?
Which type of table queue is used to pass data between database partitions when rows are being fetched?
정답: A