What is the maximum precision for the DECIMAL data type?
Answer : D
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
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
Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)
Answer : C, D
If you are already connected to a database, what does running the following statement do?
Db2 CONNECT
Answer : B
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
The creator of an index or an index specification automatically receives which privilege on the index?
Answer : D