IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 61:

  What is the minimum product required for DB2 connectivity across all platforms?

  A. DB2 Personal Edition
  B. DB2 Development Edition
  C. DB2 Connect Personal Edition
  D. DB2 Development Unlimited Edition
  C. DB2 Connect Personal Edition

• Question 62:

  Which statement is true about an index that is used to support a UNIQUE constraint?

  A. It must not contain more than one column.
  B. It cannot be used in a referential constraint.
  C. It must be defined with the UNIQUE attribute.
  D. It must be defined as UNIQUE WHERE NOT NULL.
  C. It must be defined with the UNIQUE attribute.

• Question 63:

  Which method for restricting data access relies on a SQL search condition that describes what set of rows a user has access to?

  A. Authentication
  B. Authorities and privileges
  C. Label-based access control
  D. Row and column access control
  D. Row and column access control

• Question 64:

  Which DB2 object is used to provide a logical grouping of other database objects?

  A. Alias
  B. Index
  C. Schema
  D. Collection
  C. Schema

• Question 65:

  A table named EMPLOYEES was created as follows:

  

  What will be the results?

  B. 1
  C. 2
  D. 3
  C. 2

• Question 66:

  Which statement about application-period temporal tables is true?

  A. Consists of explicitly-supplied timestamps and a separate associated history table.
  B. Is based on explicitly-supplied timestamps that define the time periods during which data is valid.
  C. Is useful when one wants to keep both user-based period information and system-based historical information.
  D. Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current.
  B. Is based on explicitly-supplied timestamps that define the time periods during which data is valid.

• Question 67:

  Which statement about a deadlock is true?

  A. The victim will be rolled back.
  B. The victim will read through the lock.
  C. Both victim and holder are rolled back.
  D. The victim must wait until the holder releases the lock.
  A. The victim will be rolled back.

• Question 68:

  Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?

  A. SALES can be the name of a schema.
  B. SALES can be the name of a package.
  C. SALES can be the name of an existing alias.
  D. SALES can be the name of a declared global temporary table.
  C. SALES can be the name of an existing alias.

• Question 69:

  A table named STATES was created as follows: What will happen?

  

  A. An error will be returned and the operation will fail.
  B. A warning will be returned and the unique index INDX1 will become the index for the primary key.
  C. The primary key will be successfully added and the unique index INDX1 will be dropped and recreated as the primary key index.
  D. The primary key will be successfully added, the unique index INDX1 will be dropped, and a new index will be created for the primary key.
  B. A warning will be returned and the unique index INDX1 will become the index for the primary key.

• Question 70:

  Which object can a buffer pool be assigned to?

  A. Schema
  B. Table space
  C. Storage group
  D. Stored procedure
  B. Table space