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

• Question 51:

  Which protocol provides applications the ability to connect to and update multiple DB2 databases within the same transaction?

  A. Type-1 connect

  B. Type-2 connect

  C. Type-3 connect

  D. Type-4 connect

  Correct Answer: B

• Question 52:

  Which statement about bitemporal tables is valid?

  A. Bitemporal tables are system tables and can only be queried by the schema owner.

  B. Creating a bitemporal table is similar to creating a regular table except users must specify a system time period column.

  C. When data in a bitemporal table is updated, a row is added to it's associated history table.

  D. Querying a bitemporal table will produce results for a complete timeline; a view must be created to obtain results for a specific time period.

  Correct Answer: C

• Question 53:

  Which object can a buffer pool be assigned to?

  A. Schema

  B. Table space

  C. Storage group

  D. Stored procedure

  Correct Answer: B

• Question 54:

  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.

  Correct Answer: C

• Question 55:

  Which DB2 object limits the user's ability to retrieve data from a table by defining a SQL statement in the object?

  A. View

  B. Index

  C. Trigger

  D. Check constraint

  Correct Answer: A

• Question 56:

  Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency?

  A. CREATE DISTINCT ALIAS canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

  B. CREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

  C. CREATE DISTINCT PROCEDURE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

  D. CREATE DISTINCT FUNCTION canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

  Correct Answer: B

• Question 57:

  Which object can be enabled for compression?

  A. View

  B. Buffer pool

  C. Storage group

  D. Temporary table

  Correct Answer: D

• Question 58:

  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

  Correct Answer: C

• Question 59:

  Which of the following privileges allow a user to update the comment on a sequence?

  A. ALTER

  B. USAGE

  C. UPDATE

  D. COMMENT

  Correct Answer: A

• Question 60:

  Which statement is valid about the Row and Column Access Control (RCAC) feature?

  A. A row mask's access control rule is defined by an SQL CASE expression; a column permission's access control rule is defined by an SQLsearch condition.

  B. A row permission's access control rule is defined by an SQL CASE expression; a column mask's access control rule is defined by an SQLsearch condition.

  C. A row mask's access control rule is defined by an SQL search condition; a column permission's access control rule is defined by an SQL CASEexpression.

  D. A row permission's access control rule is defined by an SQL search condition; a column mask's access control rule is defined by an SQL CASEexpression.

  Correct Answer: D