IBM C2090-616 Exam Practice Test Instant Access

Question 1

Which of the following editions of DB2 include support for Federation with Oracle database?

ADB2 Express-C

BDB2 Developer Edition

CDB2 Enterprise Server Edition

DDB2 Workgroup Server Edition

Answer : C

Question 2

Given the following statement:

DECLARE GLOBAL TEMPORARY TABLE TEMP1 (

ID INTEGER NOT NULL,

ITEM CHAR(30),

AMOUNT DECIMAL (10,2)

ON COMMIT DELETE ROWS NOT LOGGED;

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

ATemp1 table is accessed under schema SESSION

BTemp1 definition is available for use by other sessions

CAt the end of a transaction, data is deleted automatically

DDefinition of the table Temp1 is stored in database catalog

ERows inserted by one session are visible in other sessions

Answer : A, C

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 of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?

ARead Stability

BCursor Stability

CRepeatable Read

DUncommitted Read

Answer : C

Question 5

Which of the following authorities is sufficient for connecting to a database?

ASQLADM

BCONNECT

CDATAACESS

DACCESSCTRL

Answer : B

Question 6

Which of the following features can provide significant benefits in storage savings, performance of analytic workloads, and time to value?

ApureScale

Bauto reorg

CBLU acceleration

DSelf tuning memory manager

Answer : C

Question 7

What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?

A32672 bytes

B65344 bytes

C98016 bytes

D130688 bytes

Answer : A

IBM DB2 11.1 Fundamentals for LUW C2090-616 Exam Practice Test