DB2 11.1 Fundamentals for LUW Free Sample Questions

Description

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

Try simulator

C2090-616 Sample Questions

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

  2. Question 4

    Multiple answers

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

    Answer and explanation

    Correct answers: B, E

  3. Question 5

    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?

    Answer and explanation

    Correct answer: B

    Reference: https://www.ibm.com/support/knowledgecenter/en/ssw ibm i 72/sqlp/rbafyolap.htm

  4. Question 6

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

    Answer and explanation

    Correct answer: B

    B

  5. Question 8

    Which of the following statements about stored procedures is TRUE?

    Answer and explanation

    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

  6. Question 9

    Multiple answers

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

    Answer and explanation

    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

  7. Question 10

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

    Answer and explanation

    Correct answer: C

    Reference: https://www.ibm.eom/support/knowledgecenter/en/SSEPEK 10.0.0/sqlref/src/tpc/db2z sql rollback.html

Register free for 10 more questions

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