IBM C2090-616 Exam Questions Instant Access

Question 1

Which optional NPS compatibility features will be activated by executing the following? (Choose two.)

SET SQL_COMPAT='NPS'

AYEARSBETWEEN

BBINARY and VARBINARY data types

CDouble-dot notation to specify a database object

DOFFSET x ROWS FETCH FIRST y ROWS ONLY

ETRANSLATE (char-string-exp, from-string-exp, to-string-exp)

Answer : C, E

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

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 4

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

ASQLADM

BCONNECT

CDATAACESS

DACCESSCTRL

Answer : B

Question 5

Which of the following is fundamental to BLU acceleration?

ApureScale

BColumn organized tables

CMultidimensional clustering

DPurchasing new hardware that is compatible with BLU acceleration and compression

Answer : B

Question 6

Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable?

AImplicit casting

BDouble-dot notation

CUse of bitmap indexes

DSelecting from the DUAL table

Answer : D

Question 7

A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)

AEasy scalability

BManagement of very large data sets

CContinuously available dataset solution

DIncreased throughput of many concurrent short running queries

EFaster response time of long-running or complex queries with I/O spread across many computers

Answer : B, E

IBM DB2 11.1 Fundamentals for LUW C2090-616 Exam Questions