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

• Question 11:

  What takes place when a process accesses a data object on which it already holds a lock, and the access mode requires a more restrictive lock than the one currently held?

  A. Lock wait

  B. Lock timeout

  C. Lock escalation

  D. Lock conversion

  Correct Answer: D

• Question 12:

  What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?

  A. Lock exchange

  B. Lock promotion

  C. Lock escalation

  D. Lock conversion

  Correct Answer: C

• Question 13:

  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 collating sequence used. Which statement should user USER1 execute to create the desired table?

  A. CREATE TABLE parts (part_no INTEGER, desc CLOB))

  B. CREATE TABLE parts (part_no INTEGER, desc VARCHAR(200))

  C. CREATE TABLE parts (part_no INTEGER, desc CLOB FOR BIT DATA))

  D. CREATE TABLE parts (part_no INTEGER, desc VARCHAR(200) FOR BIT DATA)

  Correct Answer: D

• Question 14:

  Which database object provides an alternative way of describing data that exists in one or more base tables?

  A. Alias

  B. View

  C. ndex

  D. Sequence

  Correct Answer: B

• Question 15:

  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 fullselect.

  C. Ensure that any inserted or updated rows conform to the definition of the view.

  D. Define a view that only consists of columns that have check constraints defined.

  Correct Answer: C

• Question 16:

  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

  Correct Answer: D

• Question 17:

  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 MERGE statement.

  Correct Answer: B

• Question 18:

  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 indexes to create a single unique index.

  D. To improve performance of some queries by allowing index-only access.

  Correct Answer: D

• Question 19:

  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. To run non-database operations that are coded in user-defined functions.

  Correct Answer: B

• Question 20:

  What is a function of a table check constraint?

  A. To provide a method of avoiding duplicate entries for a column.

  B. To provide a method of ensuring a column's values are within a specific range.

  C. To ensure that XML columns are properly populated in an associated XML table space.

  D. To enforce relationships between tables by checking the existence of rows in one table against another.

  Correct Answer: B