IBM DB2 11.1 Fundamentals for LUW - C2090-616 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

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

A. Double-dot notation to specify a database object B. YEARSBETWEEN C. BINARY and VARBINARY data types D. OFFSET x ROWS FETCH FIRST y ROWS ONLY E. TRANSLATE (char-string-exp, from-string-exp, to-string-exp)

Discussion 0

Correct Answer: A,E Vote an answer

Question 2

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

A. Shadow tables do not store their data on disk B. Shadow tables cannot be queried directly C. Shadow tables must be organized by column D. You cannot join shadow tables to other kinds of tables E. Shadow tables must be maintained by replication

Discussion 0

Correct Answer: C,E Vote an answer

Question 3

Which of the following statements about triggers are TRUE? (Choose two.)

A. The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time B. Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view C. Triggers can be activated as a result of changes due to referential constraint enforcement D. Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers E. There is a limit of 8 for the maximum number of cascading trigger activations

Discussion 0

Correct Answer: C,D Vote an answer

Question 4

Which of the following editions of DB2 include support for Federation with Oracle database?

A. DB2 Enterprise Server Edition B. DB2 Express-C C. DB2 Developer Edition D. DB2 Workgroup Server Edition

Discussion 0

Correct Answer: A Vote an answer

Question 5

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?

A. INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101) B. INSERT INTO t1 (c1, c3) VALUES ('100', '100.00') C. INSERT INTO t1 (c1, c2) VALUES (100) D. INSERT INTO t1 VALUES (100)

Discussion 0

Correct Answer: C Vote an answer

Question 6

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

A. A ROLLBACK command executed just after the COMMIT command cancels that COMMIT B. It finishes the current T1 unit of work and a new one is initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed C. Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command D. It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT

Discussion 0

Correct Answer: B Vote an answer

Question 7

Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?

A. Lock conversion B. Deadlock C. Lock escalation D. Lock timeout

Discussion 0

Correct Answer: B Vote an answer