C2090-600 Online Practice Questions and Answers

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 of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?

A. db2cluster –cfs –list –filesystem datafs

B. db2cluster –cfs –display –filesystem datafs

C. db2cluster –cfs –listconfig –filesystem datafs

D. db2cluster –cfs –displayconfig –filesystem datafs

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.

Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

A. REORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;

B. REORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;

C. RUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;

D. RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

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

The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.

Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table

A. REORG TABLE sales INPLACE RESETDICTIONARY

B. REORG TABLE sales INPLACE REBUILDDICTIONARY

C. REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY

D. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?

A. It does not acquire locks on the table

B. It does not require additional temporary disk space

C. It enables the user to control when the table will be offline

D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments

The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)

A. You can change the principal standby of the primary without first stopping HADR on the primary.

B. The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.

C. You can remove the primarydatabase from the target list of a standby although the standby is connected to the primary.

D. You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.

E. You cannot remove a standby from the list if it is connected to the primary. To disconnect a standby, simply deactivate it. The you can remove it from the primary's target list.

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

What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?

A. NONE

B. LOCAL

C. DOMAIN

D. GLOBAL

Which statement about label-based access control (LBAC) is TRUE?

A. LBAC protection can be applied to a nickname

B. LBAC cannot be used to restrict access to a staging table

C. LBAC cannot be used to restrict access to data of columns and rows in the same table

D. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type