×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
When storing XML data in a DB2 database, which statement is valid?
2.
If table TAB_A is created as follows: Assuming the cardinality of the columns is the same, which statement will create an index that will benefit the most from compression?
3.
Which of following is true when decomposing multiple XML documents?
4.
If table TAB_A has just been created as follows: Which command will create a compression dictionary for table TAB_A?
5.
Which is true regarding collecting distribution statistics for XML data?
6.
Table TAB_A and index TABA_IDX were created by executing these SQL statements:
If this SQL statement is executed after 100,000 records have been inserted into table TAB_A:
ALTER INDEX taba_idx COMPRESS NO;
Which statement correctly describes what will happen to index TABA_IDX?
If this SQL statement is executed after 100,000 records have been inserted into table TAB_A:
ALTER INDEX taba_idx COMPRESS NO;
Which statement correctly describes what will happen to index TABA_IDX?
7.
Index INDEX1 has been created as follows: CREATE INDEX index1 ON table_x (cola) Which of the following actions can be done through an ALTER INDEX statement?
8.
Given the following DDL statements: What is the end result of the CREATE INDEX statement?
9.
Which of the following SQL statements will return monitoring information of tables in the DB2USER schema that begin with the letter 'A'?
10.
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?