IBM IBM Certified Advanced Database Administrator A2090-610 Questions & Answers

• Question 71:

  What is used in conjunction with a foreign key to define a relationship between two tables?

  A. Primary key

  B. Partitioning key

  C. Check constraint

  D. Unique constraint

  Correct Answer: A

• Question 72:

  Which statement about BEFORE triggers is FALSE?

  A. A BEFORE trigger can be used to perform validation of input data.

  B. A BEFORE trigger can be used to automatically generate values for newly inserted rows.

  C. A BEFORE trigger is fired for each row in the set of affected rows before the trigger event executes.

  D. A BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger event.

  Correct Answer: D

• Question 73:

  By default, where is the data stored for a column defined with an XML data type?

  A. In an XML index.

  B. In line with the rest of the data for the table.

  C. In an XML storage object that is separate from the table.

  D. In line with the rest of the data for the table, for XML columns less than 32KB.

  Correct Answer: C

• Question 74:

  Which statement is true regarding constraints?

  A. A table can only have one unique key constraint.

  B. A table can have multiple primary key constraints.

  C. Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.

  D. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreignkey.

  Correct Answer: C

• Question 75:

  Which type of constraint can be used to ensure that an INTEGER column in a table will never be assigned more than one record that contains a NULL value?

  A. Unique constraint

  B. Primary key constraint

  C. Informational constraint

  D. Column default constraint

  Correct Answer: A

• Question 76:

  By default, a column defined as a TIMESTAMP includes which attributes?

  A. No fractional digits or time zone.

  B. 6 fractional digits and no time zone.

  C. 12 fractional digits plus a time zone.

  D. 12 fractional digits and no time zone.

  Correct Answer: B

• Question 77:

  Which is NOT a valid reason for creating an index?

  A. To allow queries to run more efficiently.

  B. To enforce constraints such as uniqueness on index keys.

  C. To order the columns of a table in ascending or descending sequence according to values in a row.

  D. To order the rows of a table in ascending or descending sequence according to the values in a column.

  Correct Answer: C

• Question 78:

  What is the primary purpose of a view?

  A. To enable uniqueness.

  B. To ensure data clustering.

  C. To combine data from multiple tables.

  D. To optimize queries ran against multiple tables.

  Correct Answer: C

• Question 79:

  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.

  Correct Answer: CE

• Question 80:

  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.

  Correct Answer: D