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

Page: 1 / 14
Total 63 questions

Question 1

What is the maximum precision for the DECIMAL data type?



Answer : D

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?



Answer : A

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?



Answer : B

Question 4

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



Answer : C, D

Question 5

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

Db2 CONNECT



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?



Answer : D

Question 7

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



Answer : D

Page:    1 / 14   
Total 63 questions