DB2-10-1-Fundamentals-(C2090-610).pdf - IBM C2090-610 DB2 10.1 Fundamentals http\/killexams.com\/exam-detail\/C2090-610 QUESTION 125 What mechanism is

DB2-10-1-Fundamentals-(C2090-610).pdf - IBM C2090-610 DB2...

This preview shows page 1 - 3 out of 7 pages.

C2090-610 IBM DB2 10.1 Fundamentals
Image of page 1
QUESTION: 125 What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts? A. Trigger B. Procedure C. Table function D. Scalar function Answer: A QUESTION: 126 Which data type should be used to store data in a column that represents money and accurately returns a two position scale? D QUESTION: 127 User USER1 wants to define arequired relationship between two tables named TAB1 and TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are deleted from table TAB2. What must user USER1 do to accomplish this? A. 1) Create a primary key on tableTAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1and adheres to the ON DELETE CASCADE rule. B. 1) Create a primary key on table TAB2;2) Create a foreign key on table TAB1 that references the primary key on table TAB2and adheres to the ON DELETE CASCADE rule. C. 1) Create a primary key on table TAB1;2) Create a foreign key on table TAB2 that references the primary key on table TAB1and adheres to the ON DELETE RESTRICT rule.
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture