IBM C2090-616 Exam Questions Instant Access

Question 1

Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

ACOMMIT

BSAVEPOINT

CROLLBACK WORK

DUPDATE TERMINATE

Answer : C

Question 2

Which of the following authorities are sufficient for creating a database? (Choose two.)

ADBADM

BSYSADM

CSECADM

DSYSCTRL

ESYSMAINT

Answer : B, D

Question 3

The following statements are executed:

GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;

GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;

GRANT ROLE role A to USER db2inst3;

GRANT ROLE role B to USER db2inst3;

Which of the following is TRUE if this statement is executed later?

REVOKE ROLE roleB FROM USER db2inst3;

AThis statement will succeed and DB2 INST3 will still be able to create in the database

BThis statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database

CThis statement will fail as CREATETAB is granted to two different roles and must be revoked at the same time

DThis statement will succeed with a warning since CREATETAB cannot be totally revoked. DB2INST3 will retain both roles

Answer : D

Question 4

Which operation typically requires a Share (S) lock?

AINSERT

BSELECT

CDELETE

DUPDATE

Answer : B

Question 5

BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)

ADirect Standard Edition

BEnterprise Server Edition

CWorkgroup Server Edition

DDB2 Direct Advanced Edition

EAdvanced Enterprise Server Edition

Answer : B, C

Question 6

Which of the following statements about triggers are TRUE? (Choose two.)

AThere is a limit of 8 for the maximum number of cascading trigger activations

BTriggers can be activated as a result of changes due to referential constraint enforcement

CMultiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view

DConstraints associated with a subject table are applied between execution of BEFORE and AFTER triggers

EThe activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time

Answer : B, D

Question 7

What is the primary use case for creating an index with the RANDOM option on a table?

AMaximize performance with OLTP random key queries

BMaximize performance when inserting into an expression based index containing the RAND() function

CMinimize contention due to ascending key or descending key inserts, especially in a pureScale environment

DMinimize hashing skew on a table in a multiple database partition environment, especially with column organized tables

Answer : C

IBM DB2 11.1 Fundamentals for LUW C2090-616 Exam Questions