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

1. A Windows user with a local database is not able to connect to a zOS database. The System Database Directory and the Node Directory have the correct entries. Other users can connect to the database from their workstations without problems. What should be done resolve the problem?

A) Catalog the zOS database in the Database Connection Services Directory.
B) Uncatalog and re-catalog the directory entries for the zOS database and try again.
C) Catalog the zOS database in the Distributed Data Facility Directory.
D) Catalog the zOS database in the Local Database Directory.

2. Which command would be used to obtain the name of the first active log file for a database with log retain enabled?

A) GET DATABASE CONFIGURATION
B) LIST INDOUBT TRANSACTIONS
C) GET CURRENT ACTIVE LOGFILE
D) LIST LOGFILES

3. Click the Exhibit button.

Refer to the table definition shown in the exhibit.
Which will improve performance based on the query SELECT c6, c9 FROM tab3 WHERE c9 = 123456?

A) CREATE INDEX idx98 ON tab3 (c2 ASC, c6 ASC); CREATE INDEX idx99 ON tab3 (c2 ASC, c9 ASC); RUNSTATS ON TABLE myschema.tab3;
B) CREATE INDEX idx99 ON tab3 (c6 ASC, c9 DESC); REORG TABLE myschema.tab3 AND INDEXES ALL;
C) CREATE INDEX idx99 ON tab3 (c2 ASC, c9 DESC); REORG TABLE myschema.tab3 AND INDEXES ALL;
D) CREATE INDEX idx98 ON tab3 (c6 ASC); CREATE INDEX idx99 ON tab3 (c9 DESC); RUNSTATS ON TABLE myschema.tab3;

4. What is the minimum authority required to execute the RUNSTATS command against a table?

A) SYSMON
B) SQLADM
C) DATAACCESS
D) SECADM

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 the database?

A) ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
B) ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
C) ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
D) ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?

質問と回答：