C2090-616 Free Sample Questions

Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?

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?

Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?

A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)

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?

Which of the following authorities is sufficient for connecting to a database?

BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)

Which of the following statements about stored procedures is TRUE?

Which of the following authorities are sufficient for creating a database? (Choose two.)

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