What new security authorities have been introduced in DB2 V9.7?
A. WLMADM, ACCESSCTRL, SECADMIN
B. EXPLAIN, SECADMIN, DATAACCESS
C. WLMADM, SQLADM, EXPLAIN
D. SECADMIN, ACCESSCTRL, SQLADM
正解:C
質問 2:
In which two environments would intra-partition parallelism be used? (Choose two.)
A. Multiple database partitions, single processor core
B. Single database partition, single processor core
C. Single database partition, multiple processor cores
D. Multiple database partitions, multiple processor cores
正解:C,D
質問 3:
Which registry variable allows you to limit the size of individual containers for automatic storage table spaces?
A. DB2_SET_MAX_CONTAINER_SIZE
B. DB2_LIMIT_AS_CONTAINER_BLOCKS
C. DB2_ALLOCATION_SIZE
D. DB2_TRUNCATE_AS_STORAGE
正解:A
質問 4:
Which action(s) will cause a compression dictionary to be removed from a table?
A. Set the table COMPRESS attribute to NO; run RUNSTATS against the table.
B. Set the table COMPRESS attribute to NO; run REORG against the table.
C. Set the table COMPRESS attribute to NO; run INSPECTESETDICTIONARY against the table.
D. Set the table COMPRESS attribute to NO.
正解:B
質問 5:
Given the following statement: Which statement will successfully add a new partition to table T1 for April 2010?
A. Export data from the main partitioned table; create a table with the same definition as the partitioned table; attach to the main partitioned table; import data into the main partitioned table; run the SET INTEGRITY statement.
B. Create a table with the same definition as the partitioned table; attach to the main partitioned table; data will be automatically redistributed across all table partitions.
C. Create a table with the same definition as the partitioned table; load the new table with data; attach the new table to the main partitioned table; run the SET INTEGRITY statement.
D. Export data from the main partitioned table; drop the main partitioned table; create the main partitioned table with new partitioning range; import data into the main partitioned table.
正解:C
質問 6:
When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?
A. It is placed in the agent pool if the connection is terminated.
B. It remains active as long as the MAXAGENTS setting is not exceeded.
C. It terminates immediately.
D. It automatically releases the database connection and returns to the pool.
正解:A
質問 7:
The RECOVER command is used in an attempt to fix a damaged table space. What will the system do during the RECOVER process?
A. Prompt the user for new container definitions for damaged or missing containers.
B. Restore the database and attempt to make as much of the database available as possible.
C. Restore the database and bypass inaccessible containers and make the rest of the table space available.
D. Create a new temporary table space if the damaged table space is a temporary table space.
正解:B
質問 8:
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. Workload Manager
B. Design Advisor
C. Configuration Advisor
D. Partition Assistant
正解:B
Odagiri -
頂いたC2090-544問題が大分本番のテストに出ていました。