000-731  Exam

Exam # of questions Description  Update
000-731 129 DB2 9 DBA for Linux, UNIX and Windows... 02/15/2011
[Practice Test]    [Download Study Guide(PDF)]   [Update Exam]

000-731 - Exam Information
  • Description: DB2 9 DBA for Linux, UNIX and Windows
  • Passing Score: 0%
  • Practice Test - Number of questions: 129 questions
  • Simulation Test - Number of questions: 129 questions
  • Simulation Test Duration: 120 minutes
  • Has explanations: No

Question of the day

The DB2 command: LOAD FROM /dev/null OF DEL REPLACE INTO edw.chanl_dim; will do which of the following?

Answer(s)

  1. Report an error on "/dev/null" and fail.
  2. Drop the table EDW.CHANL_DIM from the database.
  3. Delete all the rows from the table EDW.CHANL_DIM.
  4. Load all the columns in the table EDW.CHANL_DIM with NULLs.
Correct Answer

Delete all the rows from the table EDW.CHANL_DIM.