← Back to exam page

C2090-616 – DB2 11.1 Fundamentals for LUW

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Which of the following statements about triggers are TRUE? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    There is a limit of 8 for the maximum number of cascading trigger activations
  • ○

    Triggers can be activated as a result of changes due to referential constraint enforcement
  • ○

    Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
  • ○

    Constraints associated with a subject table are applied between execution of BEFORE and AFTER
    triggers
  • ○

    The activation of the triggers for a particular table, event and activation time are conducted in descending
    order of trigger creation time
Question 2

Which of the following SQL statements will remove all rows from the table T1? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    DELETE FROM t1
  • ○

    DELETE* FROM t1
  • ○

    DELETE* TABLE t1
  • ○

    TRUNCATE TABLE t1 IMMEDIATE
  • ○

    TRUNCATE TABLE t1
Question 3

A multi-partition database environment using BLU acceleration is designed to meet which of the following

requirements? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Easy scalability
  • ○

    Management of very large data sets
  • ○

    Continuously available dataset solution
  • ○

    Increased throughput of many concurrent short running queries
  • ○

    Faster response time of long-running or complex queries with I/O spread across many computers