IBM IBM Certifications C2090-600 Questions & Answers

• Question 21:

  Which of the following statements about audit policies is TRUE?

  A. Audit policy changes are applied instantly and affect all inflight transactions.

  B. Multiple audit policies can be associated with the same table at the same time.

  C. The audit policy applied to a table is automatically applied to any view based on that table.

  D. If a user is switched within a trusted connection, the applicable audit policies are re- evaluated for the new user without regard to audit policies for the original user.

  Correct Answer: D

• Question 22:

  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

  Correct Answer: D

• Question 23:

  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

  Correct Answer: C

• Question 24:

  If the following SQL statements are executed:

  CREATE DATABASE testdb AUTOMATIC STORAGE NO;

  CONNECT TO testdb;

  CREATE STOGROUP sg1 ON `/data1';

  CREATE STOGROUP ibmstogroup ON `/data2';

  CREATE STOGROUP sg2 ON `/data3';

  Which storage group is the default storage group for the TESTDB database?

  A. SG1

  B. SG2

  C. IBMSTOGROUP

  D. IBMDEFAULTTSG

  Correct Answer: C

• Question 25:

  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

  Correct Answer: D

• Question 26:

  What does dsmtop use to gather metrics?

  A. db2pd

  B. db2dart

  C. the system catalog

  D. monitoring tablefunctions

  Correct Answer: D

• Question 27:

  Which security mechanism is responsible for verifying that users are indeed who the claim to be?

  A. Authentication

  B. Roles and privileges

  C. Mandatory access control

  D. Discretionary access control

  Correct Answer: A

• Question 28:

  When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?

  A. The page size is too small.

  B. The extent size is too small.

  C. Low cardinality of the dimension(s) chosen.

  D. High cardinality of the dimension(s) chosen.

  Correct Answer: D

• Question 29:

  Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)

  A. ALTER TABLE tab1 APPEND ON

  B. ALTER TABLE tab1 DROP COLUMN col1

  C. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL

  D. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1

  E. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)

  Correct Answer: BC

• Question 30:

  Which statement regarding event monitors is TRUE?

  A. Event monitor data can be reviewed while the event monitor is active

  B. Event monitors must always be started manually after activating a database

  C. Event monitors must write data to .EVT files before the data can be loaded into database tables

  D. Event monitors are used to obtain information about how a database system looks at a specific point in time

  Correct Answer: B