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.)
Which feature introduced in DB2 9.7 allows faster roll-in and roll-out of data partitions?
Which feature introduced in DB2 9.7 allows faster roll-in and roll-out
of data partitions?
What would be the number of extents allocated for each table after the successful creation of both tables?
Refer to the Exhibit.
Refer to the exhibit for information on how tables TABA and TABB were created.
What would be the number of extents allocated for each table after the
successful creation of both tables?
What are two available forms of compression in DB2 9.7?
What are two available forms of compression in DB2 9.7? (Choose two.)