IBM C2090-616 Exam Practice Test Instant Access

Question 1

Which operation typically requires a Share (S) lock?

AINSERT

BSELECT

CDELETE

DUPDATE

Answer : B

Question 2

Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?

ADB2 Connect

BDB2 Runtime Client

CDB2 Data Server Client

DDB2 Enterprise Server Edition

Answer : A

Question 3

Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?

ARead Stability

BCursor Stability

CRepeatable Read

DCursor Stability with WAIT FOR OUTCOME clause

Answer : A

Read stability (RS) locks only those rows that an application retrieves within a unit of work. It ensures that any qualifying row read during a unit of work is not changed by other application processes until the unit of work completes, and that any row changed by another application process is not read until the change is committed by that process

Question 4

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 5

Which of the following statements about stored procedures is TRUE?

AStored procedures can be written in SQL PL, but not in the PL/SQL dialect

BThe CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database

CThere are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures

DTwo identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

Answer : B

Question 6

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 7

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

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