IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 131:

  Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3, BUSINESS_TIME WITHOUT_OVERLAPS);

  A. The index must be partitioned.
  B. The index must use page size > 4K.
  C. The index must be defined as UNIQUE.
  D. The index must be defined as CLUSTER.
  C. The index must be defined as UNIQUE.

• Question 132:

  What is the appropriate action to maintain data consistency if your page set is in REFP restrictive state?

  A. Recover the table space to current.
  B. Run the REORG utility with SHRLEVEL NONE.
  C. Run a Point In Time RECOVER or the LOAD REPLACE utility.
  D. Issue command -START DB(yourdb) SP(yourtbspace) ACCESS(FORCE).
  C. Run a Point In Time RECOVER or the LOAD REPLACE utility.

• Question 133:

  What should be implemented in order to audit all the activity of the install SYSADM?

  A. DATA CAPTURE CHANGES should be set on all tables.
  B. A DB2 audit policy should be established, identifying the SYSADM ID to be audited.
  C. The DB2 authorization exit should be modified to convert the install SYSADM ID to another ID.
  D. Nothing can be done, the install SYSADM has the highest authority and is not controlled or monitored.
  B. A DB2 audit policy should be established, identifying the SYSADM ID to be audited.

• Question 134:

  What must be done in order to audit read access to a table?

  A. AUDIT ALL must be set on the table and an audit trace must be started.
  B. An EDITPROC must be defined on the table and an audit trace must be started.
  C. DATA CAPTURE CHANGES must be set on the table and the DB2 log must be captured.
  D. A security label column should be defined on the table within a trusted context.
  A. AUDIT ALL must be set on the table and an audit trace must be started.