C2090-600 Online Practice Questions and Answers

Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

A. db2pd

B. db2dart

C. db2expln

D. db2advis

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?

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

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

C. After 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.

D. After 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.

Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

A. Catalog a storage access alias in the DB2 database

B. Create an FTP account on IBM Softlayer Object Storage

C. Use the DB2REMOTE parameter of the LOAD command

D. Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect

E. Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

Which options are valid for an online reorganization operation?

A. FULL and RECLAIM EXTENTS

B. CLASSIC and RECLAIM EXTENTS

C. FULL and CLEANUP OVERFLOWS

D. CLEAN OVERFLOWS and RECLAIM EXTENTS

What is an advantage of using range partitioned tables?

A. Abilityto run utilities against the partitions in parallel

B. Increased query performance through data partition elimination

C. Block indexes are much smaller than RID indexes, providing better performance

D. Table data is automatically and continuously clustered, requiring minimal reorganization

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?

A. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

B. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

C. CONNECT TO sample;UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;CONNECT RESET;

D. ATTACH TO db2inst1;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

An HADR environment has two standby databases ?one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?

A. SYNC

B. ASYNC

C. NEARSYNC

D. SUPERASYNC

Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

A. XML

B. REAL

C. NUMBER

D. VRCHAR2

E. VARBINARY

You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

A. LOAD

B. INGEST

C. IMPORT

D. TRANSPORT

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

A. CONNECT TO mydbPRUNE HISTORY TO /outdir

B. db2trc on –db mydb –m “backup,load”run the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off

C. BACKUP DATABASE mydb NO TABLESPACE TO /outdir

D. db2setDB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump