Question 1

Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?

ACONNECT TO mydbPRUNE HISTORY TO /outdir

Bdb2trc on --db mydb --m ''backup,load''run the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off

CBACKUP DATABASE mydb NO TABLESPACE TO /outdir

Ddb2setDB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump <outfile>

Answer : B

Question 2

The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time ''pit''.

BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE

QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE

QUIESCE TABLESPACES FOR TABLE tab1 RESET

Which of the following is TRUE?

AThe QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes.

BOnce the first QUIESCE completes, there are no runningtransactions involving tab1, but there might be running transactions against other tables in TS1.

CAfter application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. There might besome uncommitted data in TS1.

DAfter application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. This ensures none of the application changes were applied.

Answer : D

Question 3

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

AThe PAGESIZE database configuration parameter is set to 32K.

BThe AUTO_REORG database configurationparameter is set to NO.

CThe DFT_EXTENT_SZ database configuration parameter is set to 8.

DThe DFT_TABLE_ORG database configuration parameter is set to COLUMN.

EThe INTRA_PARALLEL database manager configuration parameter is set to NO.

Answer : D, E

Question 4

Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)

ACreating, using, or altering thresholds

BGranting, altering, or revoking workload privileges

CUsing or altering the default service classes and workloads

DCreating service classes, service subclasses, and workloads

ECreating, activating, stopping or dropping workload management event monitors

Answer : B, D

Question 5

Which of the following are all valid types of trigger?

AAFTER, ATOMIC, BEFORE

BAFTER, ATOMIC, INSTEAD OF

CAFTER, BEFORE, INSTEAD OF

DATOMIC, BEFORE, INSTEAD OF

Answer : C

Free Practice Questions for IBM C2090-600 Exam

Question 1

Question 2

Question 3

Question 4

Question 5