IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade - C2090-546 Exam Practice Test
A DBA wants to use XQuery on a XML document to determine the number of lock waits for a particular workload. Which of the following table functions should be used?
Correct Answer: B
Vote an answer
Which two registry variables that are normally used to delay or avoid acquiring locks are affected by Currently Committed (CC) semantics when the Cursor Stability (CS) isolation level are used? (Choose two.)
Correct Answer: A,B
Vote an answer
Which DB2 9.7 database authority can be granted to the group PUBLIC?
Correct Answer: C
Vote an answer
Click on the Exhibit button Given the following DDL statements:
If COL2 contains XML documents similar to the scenario, what is the end result of the CREATE INDEX statement?
If COL2 contains XML documents similar to the scenario, what is the end result of the CREATE INDEX statement?
Correct Answer: A
Vote an answer
Which statement describes the state of the DMS table space TBS_1 after the successful execution of the following script? ALTER TABLESPACE tbs_1 MANAGED BY AUTOMATIC STORAGE
Correct Answer: A
Vote an answer
Which DB2 authority is required to manage workload objects for a database?
Correct Answer: A
Vote an answer
After using the lock event monitor to capture binary lock event data in an unformatted event table, you can convert the data into an XML or text document using which of the following Java-based tools?
Correct Answer: D
Vote an answer
How would you set the client information for a particular activity in a database using Workload Manager (WLM)?
Correct Answer: D
Vote an answer