IBM DB2 9.7 Advanced DBA for LUW - C2090-544 Exam Practice Test
If you know that the table space containers for your database reside on RAID-5 3+p arrays, which registry variable should be assigned the value *:3 to help improve performance?
Correct Answer: D
Vote an answer
At which two levels can events be audited? (Choose two.)
Correct Answer: A,E
Vote an answer
Which database configuration parameters can be used to limit the amount of memory allocated for the LOAD utility?
Correct Answer: C
Vote an answer
Which type of table queue is used to pass data between database partitions when rows are being fetched?
Correct Answer: D
Vote an answer
How can a DBA validate that an existing backup was compressed?
Correct Answer: B
Vote an answer
A database named DB1 has a database partition group named MULTIPG that has been defined
across partitions 3, 4 and 5.
The DBA issues the following series of commands/SQL statements:
CONNECT TO db1;
SET CURRENT DBPARTITIONNUM 4;
ALTER DATABASE PARTITION GROUP multigp ADD DBPARTITIONNUM (6);
Which partition will DB2 use as a model for table spaces on partition 6?
across partitions 3, 4 and 5.
The DBA issues the following series of commands/SQL statements:
CONNECT TO db1;
SET CURRENT DBPARTITIONNUM 4;
ALTER DATABASE PARTITION GROUP multigp ADD DBPARTITIONNUM (6);
Which partition will DB2 use as a model for table spaces on partition 6?
Correct Answer: D
Vote an answer
What is the minimum authority required to execute the RUNSTATS command against a table?
Correct Answer: C
Vote an answer
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?
Correct Answer: A
Vote an answer
The RECOVER command is used in an attempt to fix a damaged table space. What will the system do during the RECOVER process?
Correct Answer: C
Vote an answer