A2090-610 Online Practice Questions and Answers

Which DB2 object can be used to improve the execution performance of qualified SELECT statements?

A. Trigger

B. SQL Procedure

C. Sequence Object

D. Materialized Query Table

When is it appropriate to use a sequence?

A. When you want to control the order in which triggers are fired.

B. When you want to control the order in which stored procedures can be invoked.

C. When you want to automatically generate a numeric value that is not tied to any specific column or table.

D. When you want to automatically generate a numeric value for each row that is added to a specific table.

An SQL function designed to convert temperatures from Fahrenheit to Celsius was created as follows:

How can this function be used to convert average temperature (AVG_TEMP) data stored in a table called CLIMATE_INFO?

A. CALL conv_temp(climate_info.avg_temp);

B. CALL convert_ftoc(climate_info.avg_temp);

C. SELECT conv_temp(avg_temp) FROM climate_info;

D. SELECT convert_ftoc(avg_temp) FROM climate_info;

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.

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.

By default, where is the data stored for a column defined with an XML data type?

A. In an XML index.

B. In line with the rest of the data for the table.

C. In an XML storage object that is separate from the table.

D. In line with the rest of the data for the table, for XML columns less than 32KB.

Which object can be enabled for compression?

A. View

B. Buffer pool

C. Storage group

D. Temporary table

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

Which product replaced the Control Center used in versions prior to DB2 v10?

A. IBM Data Studio

B. IBM Administrator

C. IBM Data Manager

D. IBM Command Center

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