What are three implementations for DB2 Workload Management?
What are three implementations for DB2 Workload Management? (Choose three.)
What are three default service classes used by Work Load Management?
What are three default service classes used by Work Load Management? (Choose
three.)
which produces readable text output from the data generated by an event monitor?
Which DB2 tool is a Java-based, generic XML parser which produces readable
text output from the data generated by an event monitor?
What does the SQL in the exhibit show?
Refer to the Exhibit.
What does the SQL in the exhibit show?
What can be used to monitor static and dynamic SQL statements?
What can be used to monitor static and dynamic SQL statements?
Which CREATE statement will accomplish this?
You are asked to create a new database called PRODDB where no privileges
will be automatically granted to PUBLIC
Which CREATE statement will accomplish this?
What is the purpose of the XMLPARSE() function?
What is the purpose of the XMLPARSE() function?
Which modification to index TAB 1X1 can be performed with an ALTER INDEX statement?
Index TAB 1X1 was created as shown below:
CREATE INDEX tablxl ON tab1(col_1)
Which modification to index TAB 1X1 can be performed with an ALTER INDEX
statement?
Which SQL statement will retrieve XML documents from the CUSTOMER table and convert them to character strings?
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?
Which three table features can be used concurrently in the same table?
Which three table features can be used concurrently in the same table?
(Choose three.)