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

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

C2090-610IBMDB2 10.1 Fundamentals
QUESTION:125What mechanism is typically used to automatically update other tables, generate ortransform values for inserted or updated rows, and perform tasks such as issuingalerts?A
QUESTION:126Which data type should be used to store data in a column that represents money andaccurately returns a two position scale?D
QUESTION:127User USER1 wants to define arequired relationship between two tables named TAB1and TAB2 in such a way that whenever a record is deleted from table TAB1, anyrelated records are deleted from table TAB2. What must user USER1 do toaccomplish 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 TAB1

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 7 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Mohammad Alizadeh
Tags
Foreign key

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture