IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 111:

  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
  C. Lock escalation

• Question 112:

  User USER1 wants to define a required relationship between two tables named TAB1 and TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are deleted from table TAB2. What must user USER1 do to accomplish this?

  A. 1) Create a primary key on table TAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and 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 TAB2 and 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 and adheres to the ON DELETE RESTRICT rule.
  D. 1) Create a primary key on table TAB2; 2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE RESTRICT rule.
  A. 1) Create a primary key on table TAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE CASCADE rule.

• Question 113:

  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.
  D. A schema with the userid of the UDF definer.

• Question 114:

  Which statement regarding referential integrity constraints is true?

  A. Multiple primary keys can be defined for a table.
  B. A foreign key can reference multiple primary keys.
  C. A primary key can be referenced by only one foreign key.
  D. Primary keys and foreign keys are used to define relationships.
  D. Primary keys and foreign keys are used to define relationships.

• Question 115:

  Which action needs to be performed in order to complete the definition of an application-period temporal table?

  A. A transaction-start-id column must be defined for the table.
  B. A history table must be defined and associated with the base table.
  C. A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.
  D. A unique index must be created that prevents overlapping of the BUSINESS_TIME period of the table.
  C. A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.

• Question 116:

  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
  A. Primary key

• Question 117:

  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.
  C. To combine data from multiple tables.

• Question 118:

  A column mask that is to be used for row and column access control (RCAC) was created with the DISABLE option specified. What must be done if this mask is to be used to restrict access to data stored in a table named EMPLOYEE?

  A. The column mask must be enabled; the EMPLOYEE table must be altered to activate column access control.
  B. The column mask must be enabled (column access control for the EMPLOYEE table will be activated automatically).
  C. The EMPLOYEE table must be altered to activate column access control (the column mask will be enabled automatically).
  D. The EMPLOYEE table must be altered to activate column access control; row permission must be granted to everyone who needs to use thecolumn mask.
  A. The column mask must be enabled; the EMPLOYEE table must be altered to activate column access control.

• Question 119:

  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.
  D. To improve performance of some queries by allowing index-only access.

• Question 120:

  Which clause should be included in a ALTER TABLE statement to update a table definition with a new column?

  A. ADD COLUMN
  B. ALTER COLUMN
  C. APPEND COLUMN
  D. RENAME COLUMN
  A. ADD COLUMN