C2090-616 by IBM Actual Free Exam Q&As

Question 1

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

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

Discussion 0

Correct Answer: C,E Vote an answer

Question 2

Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

A. ROLLBACK WORK B. UPDATE TERMINATE C. COMMIT D. SAVEPOINT

Discussion 0

Correct Answer: A Vote an answer

Question 3

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.)

A. Temp1 table is accessed under schema SESSION B. Rows inserted by one session are visible in other sessions C. At the end of a transaction, data is deleted automatically D. Temp1 definition is available for use by other sessions E. Definition of the table Temp1 is stored in database catalog

Discussion 0

Correct Answer: B,E Vote an answer

Question 4

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 (c1, c2) VALUES (100) B. INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101) C. INSERT INTO t1 (c1, c3) VALUES ('100', '100.00') D. INSERT INTO t1 VALUES (100)

Discussion 0

Correct Answer: A Vote an answer

Question 5

What is the purpose of a role?

A. To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges B. To define exactly what a specific user can and cannot do within a particular database once they have been authenticated C. To assign one or more users that need to run local DB2 applications and tools on a particular server to the DB2ADMNS or the DB2USERS group D. To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users, groups, or other roles

Discussion 0

Correct Answer: B 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. 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 B. A ROLLBACK command executed just after the COMMIT command cancels that COMMIT C. 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 D. Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command

Discussion 0

Correct Answer: A Vote an answer

Question 7

Consider the following query and the resulting set of data:
SELECT empno, lastname FROM emp WHERE empno BETWEEN '000020' and '000070' Result:
If the query below is executed, how many rows will be returned?
SELECT empno FROM emp WHERE empno > '000020' AND empno '000070'

A. 3 B. 5 C. 0 D. 1

Discussion 0

Correct Answer: A Vote an answer

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