IBM C2090-616 Exam Practice Test Instant Access

Question 1

What is the maximum precision for the DECIMAL data type?

B15

C23

D31

Answer : D

A decimal number is a packed decimal number with an implicit decimal point. The position of the decimal point is determined by the precision and the scale of the number. The scale, which is the number of digits in the fractional part of the number, cannot be negative or greater than the precision. The maximum precision is 31 digits.

Question 2

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 3

Your manager has asked you to review cloud service offering for hosting a DB2 database. As the DBA, you still want to maintain control over all maintenance and patching operations. Which of the following Cloud offerings best suits your needs?

ACloudant

BDB2 on Cloud

CdashDB for analytics

DdashDB for transactions

Answer : B

Question 4

Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)

AShadow tables cannot be queried directly

BShadow tables do not store their data on disk

CShadow tables must be organized by column

DShadow tables must be maintained by replication

EYou cannot join shadow tables to other kinds of tables

Answer : C, D

Question 5

If you are already connected to a database, what does running the following statement do?

Db2 CONNECT

APrompts you for the database name or alias

BReturns information about the current server

CPrompts you for the authentication information

DReturns an error, because you provided no database or alias

Answer : B

Question 6

The DDL statement is used to create table T1:

CREATE TABLEt1 (

c1 INTEGER,

c2 INTEGER NOT NULL,

c1 DECIMAL(11,2),

c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP

)

Which of the following INSERT statements will execute successfully?

AINSERT INTO t1 VALUES (100)

BINSERT INTO t1 (c1, c2) VALUES (100)

CINSERT INTO t1 (c1, c3) VALUES ('100', '100.00')

DINSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)

Answer : D

Question 7

The creator of an index or an index specification automatically receives which privilege on the index?

ASELECT

BDELETE

CUPDATE

DCONTROL

Answer : D

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