IBM IBM Certifications C2090-558 Questions & Answers

• Question 41:

  Which two commands would create a table t1 with page level locking assuming default configuration parameter settings? (Choose two.)

  A. create table t1 (c1 int)

  B. create table t1 (c1 int) locking page

  C. create table t1 (c1 int) lock level page

  D. create table t1 (c1 int) lock mode page

  E. create table t1 (c1 int) locking mode page

  Correct Answer: AD

• Question 42:

  What is the default isolation level on a mode ANSI database?

  A. Dirty Read

  B. Cursor Stability

  C. Committed Read

  D. Repeatable Read

  Correct Answer: D

• Question 43:

  What is the default isolation level on a database with unbuffered logging?

  A. Dirty Read

  B. Cursor Stability

  C. Committed Read

  D. Repeatable Read

  Correct Answer: C

• Question 44:

  What is the only isolation level available on an unlogged database?

  A. Dirty Read

  B. Cursor Stability

  C. Committed Read

  D. Repeatable Read

  Correct Answer: A

• Question 45:

  Which phase of Fast Recovery rolls forward (restores) all transactions since the last checkpoint and rolls back any uncommitted transactions?

  A. Logical Recovery

  B. Physical Recovery

  C. Dbspace Recovery

  D. Transactional Recovery

  Correct Answer: A

• Question 46:

  There are two open sessions (session A and session B) that are updating the same tables. Session B is trying to read all rows in the table and is continuously receiving the error "-143 ISAM error: deadlock detected". Which action in session B would allow it to read all of the rows?

  A. commit work;

  B. set isolation to dirty read;

  C. set lock mode to not wait;

  D. set lock mode to nolocking;

  Correct Answer: B

• Question 47:

  Which configuration parameters are used by ontape logical log backup?

  A. LOGFILES, LOGSIZE, TAPEDEV

  B. LTAPEBLK, TAPEDEV, TAPESIZE

  C. LTAPESIZE, LTAPEDEV, LTAPEBLK

  D. TAPEDEV, BAR_ACT_LOG, BACKUP_FILTER

  Correct Answer: C

• Question 48:

  What functionality is exclusive to ontape (i.e. not present in onbar)?

  A. Level 1 Backup of instance

  B. Rename spaces during a restore

  C. Applying a filter to the backup data

  D. Back up the instance to standard out

  Correct Answer: D

• Question 49:

  Which command would you execute to restore an instance without using or restoring the logical logs?

  A. onbar -w

  B. onbar -e

  C. onbar -r -p

  D. onbar -r -nolog

  Correct Answer: C

• Question 50:

  Which of the following is required for a cold restore?

  A. A restore that includes the rootdbs

  B. A restore that includes temp dbspaces

  C. A restore that includes only non-critical dbspaces.

  D. A restore that includes multiple level to be restored.

  Correct Answer: A