IBM DB2 9.7 Advanced DBA for LUW 認定 C2090-544 試験問題:

1. A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?

A) Design Advisor
B) Workload Manager
C) Partition Assistant
D) Configuration Advisor

2. How can you change an existing non-partitioned index for a partitioned table to a partitioned index?

A) Use the REORG INDEX command.
B) Use the DROP INDEX and CREATE INDEX commands.
C) Use the ALTER INDEX and REORG INDEX commands.
D) Use the ALTER INDEX command.

3. What new security authorities have been introduced in DB2 V9.7?

A) WLMADM, SQLADM, EXPLAIN
B) SECADMIN, ACCESSCTRL, SQLADM
C) EXPLAIN, SECADMIN, DATAACCESS
D) WLMADM, ACCESSCTRL, SECADMIN

4. A database called PRODDB has a weekly full backup taken on Saturday, non-cumulative (delta) backups taken daily, and a midweek cumulative backup that is taken on Wednesday. A database crash occurs on a Saturday prior to the full backup being taken.
What is the fastest way to restore the database?

A) RESTORE DB proddb TAKEN AT (Friday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Saturday);
B) RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
C) RESTORE DB proddb TAKEN AT (Saturday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Monday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Tuesday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Wednesday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Thursday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
D) RESTORE DB proddb TAKEN AT (Saturday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);

5. 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) 1
B) 2
C) 0
D) 3

質問と回答：