A2090-610 Online Practice Questions and Answers

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

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.

If a table named MY_TAB contains 100 rows and the following statement is executed:

What will happen?

A. The last 5 rows in the table will be deleted.

B. The first 5 rows in the table will be deleted.

C. The statement will fail because a subquery cannot be used with a DELETE statement.

D. The statement will fail because a table name was not specified with the DELETE statement.

Which statement about triggers is true?

A. A trigger is designed to return specific types of values and contains executable code.

B. A trigger is designed to return specific types of values but contains no executable code.

C. A trigger performs actions to capture details about an activity like a join operation against multiple tables.

D. A trigger performs actions in response to an event like an INSERT, UPDATE or DELETE operation on a table.

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.

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.

Which object can be enabled for compression?

A. View

B. Buffer pool

C. Storage group

D. Temporary table

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

Which two DB2 objects can a view be derived from? (Choose two.)

A. View

B. Index

C. Table

D. Trigger

E. Procedure

Which statement about large object (LOB) locators is true?

A. A LOB locator is a data type that is used to store LOB data in binary files.

B. A LOB locator is a data type that is used to store LOB data in a database.

C. A LOB locator represents a value for a LOB resource that is stored in a database.

D. A LOB locator represents a value for a LOB resource that is stored in a binary file.