IBM DB2 9.7 DBA for Linux UNIX and Windows - C2090-541 FREE EXAM DUMPS QUESTIONS & ANSWERS
The event monitor for transactions has been replaced in DB2 9.7 with which tool?
Correct Answer: A
Vote an answer
You have a new table created with COMPRESS YES and a delimited ASCII file. You use the LOAD utility to load the data from the ASCII file into the table. When will all of the rows in the table be compressed?
Correct Answer: B
Vote an answer
When using Optim Database Administrator to generate a change script, users are given which two EXPORT utility output formats to preserve their data when they drop a table then create a new table with the data? (Choose two.)
Correct Answer: A,B
Vote an answer
Which statement is correct when describing the AUTOCONFIGURE command?
Correct Answer: C
Vote an answer
Which two plug-in types does the DB2 database system provide? (Choose two.)
Correct Answer: A,C
Vote an answer
A table named CUSTOMER has an XML column named CUSTINFO that contains several XML documents. Which SQL statement will retrieve XML documents from the CUSTOMER table and convert them to character strings?
Correct Answer: B
Vote an answer
A file named db2advise.in contains the following text:
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT AVG(bonus), AVG(salary) FROM employee
GROUP BY workdept ORDER BY workdept;
Which command will cause the Design Advisor to make recommendations for a database named
SAMPLE, using the information found in this file?
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT AVG(bonus), AVG(salary) FROM employee
GROUP BY workdept ORDER BY workdept;
Which command will cause the Design Advisor to make recommendations for a database named
SAMPLE, using the information found in this file?
Correct Answer: D
Vote an answer