Free IBM 000-541 Exam Dumps Questions & Answers

Which three commands will apply the specified action to all objects in schema PAY1 in database PRODDB? (Choose three.)

• A.  RUNSTATS ON SCHEMApayl D REORGCHK UPDATE STATISTICS ON SCHEMA payl
• B.  db2look-dproddb -z payl
• C.  GRANT SELECT ON TABLEpayl * TO USER userl
• D.  GRANT DROPIN ON SCHEMApayl TO USER userl

Which two DB2 commands are used to extract, format, and present diagnostic information? (Choose two.)

• A.  db2diag
• B.  db2dart
• C.  db2xprt
• D.  db2exfmt

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?

• A.  SELECT XM LP AR S E (c usti nf o AS VARCHAR(350)) FROM customer
• B.  SELECT XM LS E RIALIZE (c usti nf o AS VARCHAR(350)) FROM customer
• C.  SELECTXMLCAST(custinfo AS VARCHAR(350)) FROM customer
• D.  SELECTXMLTEXT(custinfo AS VARCHAR(350)) FROM customer

Which method may be used to collect deadlock information in DB2 9.7?

• A.  DEADLOCKS event monitor
• B.  DB2_CAPTURE_LOCKTIMEOUT registry variable
• C.  LOCKING event monitor
• D.  DB2DETAILDEADLOCK event monitor

Which command will reorg all indexes for a table named TABA?

• A.  REORG TABLEtaba AND INDEXES ALL
• B.  REORG INDEXES ALL FOR TABLEtaba
• C.  REORG TABLEtaba INDEXES INPLACE
• D.  REORG INDEXES FORtaba