Question 1
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
Answer and explanation
Correct answer: C
C
Covers Db2 product knowledge and workload planning, data access security and privileges, creating databases and objects, SQL data manipulation, and locking and isolation levels for data concurrency.
20 free sample questions316 in the full practice test

Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
Correct answer: C
C
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?
Correct answer: B
Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?
Correct answer: B
A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)
Correct answers: B, E
Consider the following SQL statement:
SELECT workdept, empno, lastname, salary,
RANK() OVER (PARTITION BY workdept ORDER BY salary) AS rank_salary
FROM employee
ORDER BY workdept, lastname
What does the RANK() OVER (PARTITION BY workdept ORDER BY salary) clause do?
Correct answer: B
Reference: https://www.ibm.com/support/knowledgecenter/en/ssw ibm i 72/sqlp/rbafyolap.htm
Which of the following authorities is sufficient for connecting to a database?
Correct answer: B
B
BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)
Correct answers: B, C
Which of the following statements about stored procedures is TRUE?
Correct answer: B
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG 10.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0023603.html
Which of the following authorities are sufficient for creating a database? (Choose two.)
Correct answers: B, D
B, D -- Reference: https://www.ibm.eom/support/knowledgecenter/en/SSEPGG 11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html
Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?
Correct answer: C
Reference: https://www.ibm.eom/support/knowledgecenter/en/SSEPEK 10.0.0/sqlref/src/tpc/db2z sql rollback.html

Or unlock all 316 C2090-616 questions with explanations, timed mode and flashcards.