IBM C2090-616 Actual Free Exam Questions & Community Discussion
Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?
Correct Answer: A
Vote an answer
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'
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'
Correct Answer: C
Vote an answer
Which of the following authorities are sufficient for creating a database? (Choose two.)
Correct Answer: C,E
Vote an answer
Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?
Correct Answer: C
Vote an answer
Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?
Correct Answer: A
Vote an answer
The current user wants to produce a list of all user privileges she has been granted. Which table or view can be queried to produce the desired result?
Correct Answer: A
Vote an answer
Which edition of DB2 LUW has been discontinued in v11.1?
Correct Answer: A
Vote an answer
0
0
0
10