Which data type should be used to store data in a column that represents money and accurately returns a two position scale? A. BIGINT B. BINARY C. DOUBLE D. DECIMAL
What is the primary purpose for using the INCLUDE clause with a CREATE UNIQUE INDEX statement? A. To override the limit on index key columns. B. To further enforce the uniqueness of index values. C. To combine two or more…
What are INSTEAD OF triggers used for? A. To update data in other tables. B. To perform insert, update, and delete operations against complex views. C. To check or modify values before they are actually stored in a database. D.…
User USER1 wants to store part numbers and part descriptions in a table named PARTS; user USER1 also wants to ensure that any comparisons of part descriptions that are made will be done so in binary, regardless of the database…
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
Which type of constraint can be used to tell the DB2 Optimizer that a parent-child relationship exists between two tables, but that the relationship is not enforced? A. Check B. Unique C. Referential D. Informational
Which event will NOT cause a trigger to be fired? A. Execution of an INSERT statement. B. Execution of LOAD REPLACE operation. C. Execution of an INSERT operation of a MERGE statement. D. Execution of an UPDATE operation of a…
Which database object provides an alternative way of describing data that exists in one or more base tables? A. Alias B. View C. Index D. Sequence
The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of the following? A. Define a view on one or more tables or views. B. Revalidate all invalid objects that are referenced on a view’s…
Which type of table is best suited for recording results from application data manipulation that is not required to be persistent? A. Base Table B. Temporal Table C. Transition Table D. Temporary Table