IBM C2090-600 Exam Questions Instant Access

Question 1

Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

ATo prunethe contents of a staging table.

BTo prune the contents of a synopsis table.

CTo prune the contents of a materialized query table (MQT).

DTo prune the contents of a declared global temporary table.

Answer : A

Question 2

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

AXML

BREAL

CNUMBER

DVRCHAR2

EVARBINARY

Answer : C, E

Question 3

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

AREORG TABLE sales INPLACE RESETDICTIONARY

BREORG TABLE sales INPLACE REBUILDDICTIONARY

CREORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY

DREORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

Answer : C

Question 4

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

ALBAC protection can be applied to a nickname

BLBAC cannot be used to restrict access to a staging table

CLBAC cannot be used to restrict access to data of columns and rows in the same table

DLBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

Answer : D

Question 5

A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity (inserts, updates, and deletes).

Sunday -- Delta

Monday -- Incremental

Tuesday -- Delta

Wednesday -- Delta

Thursday -- Incremental

Friday -- Delta

Saturday -- Full

Which day would you expect a RECOVER DATABASE following that day's backup to take the longest time to complete?

AFriday

BMonday

CSaturday

DWednesday

Answer : A

Question 6

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?

ASG1

BSG2

CIBMSTOGROUP

DIBMDEFAULTTSG

Answer : C

Question 7

Which of the following are valid Explain operators? (Choose two.)

ACTQ

BXSCAN

CIXSCAN

DSELECT

ECOLSCAN

Answer : B, C

IBM DB2 11.1 DBA for LUW C2090-600 Exam Questions