IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Sample Questions:
1. 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?
A) ALTER TABLE tab_a ADD PRIMARY KEY (c1)
B) CREATE UNIQUE INDEX taba_idx ON tab_a (c2)
C) CREATE INDEX taba_idx ON tab_a (c4)
D) CREATE INDEX taba_idx ON tab_a (c2)
2. You are creating a table with 1 LOB column. The size of the LOB column is less than the size of the LOB descriptor. When creating this table you did not specify an INLINE LENGTH. Which option is correct?
A) Only the LOB data will be stored in the base table.
B) Both the LOB descriptor and the LOB data will be stored in the base table.
C) Only the LOB descriptor will be stored in base table and the LOB data will be stored in the LOB storage object.
D) The ALTER TABLE .. INLINE LENGTH .. command is required so the LOB data can be included in the base table.
3. When using an SQL UPDATE statement on an XML column, which statement is valid?
A) An SQL UPDATE statement on an XML column must supply the complete new XML document.
B) An SQL UPDATE statement can update an XML column using an XMLQUERY transform expression.
C) An SQL UPDATE statement can modify a portion of an XML column using the SUBSTR function.
D) An SQL UPDATE statement cannot be used on an XML column.
4. 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.)
A) DB2_SKIPINSERTED Extended Option:
B) DB2_EVALUNCOMMITTED Extended Option:
C) DB2_SKIPUPDATED Extended Option:
D) DB2_EVALCOMMITTED Extended Option:
E) DB2_WAITFOROUTCOME Extended Option:
5. Which SQL statement must be executed in order to give a user named USER1 the ability to query the system catalog tables and views?
A) GRANT DATAACCESS ON DATABASE TO user1
B) GRANT WLMADM ON DATABASE TO user1
C) GRANT ACCESSCTRL ON DATABASE TO user1
D) GRANT SQLADM ON DATABASE TO user1
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: A | Question # 3 Answer: B | Question # 4 Answer: A,B | Question # 5 Answer: A |
0 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
