IBM C2090-610 Exam Questions & Answers

Which statement about INSERT operations is true?

A. The INSERT statement is used to insert rows into a table, view, or table function.

B. Inserted values must satisfy the conditions of any check constraints defined on the table.

C. If an INSERT statement omits any column from the inserted row that is defined as NULL or NOT NULL WITH DEFAULT, the statement will fail.

D. If the underlying table of a view being referenced by an INSERT statement has one or more unique indexes, each row inserted does not have to conform to the constraints imposed by those indexes.

Which two statements are true about foreign key constraints? (Choose two.)

A. The foreign key constraint columns must be supported by an index.

B. The foreign key constraint columns must be defined as NOT NULL.

C. The number and data types of foreign key constraint columns must match the parent key.

D. The columns of one foreign key constraint cannot be used in another foreign key constraint.

E. To define a foreign key constraint there must be an associated primary key or unique key in the same or different table.

When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?

A. The SYSIBM schema.

B. The SYSFUN schema.

C. A schema with the name of the UDF.

D. A schema with the userid of the UDF definer.