IBM DB2 9.7 DBA for Linux UNIX and Windows - C2090-541 Exam Practice Test
A file named db2advise.in contains the text shown below:
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?
Correct Answer: B
Vote an answer
Which two data types can be in-lined to enhance compression? (Choose two.)
Correct Answer: A,C
Vote an answer
Which command will reorg all indexes for a table named TABA?
Correct Answer: B
Vote an answer
Which method may be used to collect deadlock information in DB2 9.7?
Correct Answer: C
Vote an answer
Which administrative authority is needed to run the audit stored procedures and table functions such as the AUDIT_DELIM_EXTRACT stored procedure?
Correct Answer: C
Vote an answer
Which command will reorg all indexes for a table named TABA?
Correct Answer: B
Vote an answer
You have a UTIL_IMPACT_LIM of 50 and a UTIL_IMPACT_PRIORITY of 60 for the backup utility. What are the maximum amount of system resources that the backup utility can use?
Correct Answer: C
Vote an answer
A database named PAYROLL resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which command can be used to accomplish this?
Correct Answer: D
Vote an answer
Which group of memory consumers can be adjusted by the Self-Tuning Memory Manager (STMM)?
Correct Answer: D
Vote an answer