A2090-610 Online Practice Questions and Answers

What are two valid objects that can be created in DB2? (Choose two.)

A. Tree

B. Node

C. Trigger

D. Contexts

E. Sequence

What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on the same resource known as?

A. Lock escalation

B. Lock substitution

C. Lock switch/exchange

D. Lock conversion/promotion

Which statement is true regarding constraints?

A. A table can only have one unique key constraint.

B. A table can have multiple primary key constraints.

C. Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.

D. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreignkey.

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

Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads?

A. DB2 Connect

B. DB2 pureScale

C. Workload Manager

D. High Availability Disaster Recovery

Which DB2 product is NOT suitable for very large data warehouse applications?

A. DB2 for i

B. DB2 for AIX

C. DB2 for z/OS

D. DB2 for Linux

Which SQL statement will retrieve the department number (WORKDEPT) and average departmental salary (SALARY) for all departments in a table named EMPLOYEE and arrange the result set in ascending order by average departmental salary?

A. SELECT workdept, AVG(salary)FROM employeeORDER BY workdeptGROUP BY 2

B. SELECT workdept, AVG(salary)FROM employeeORDER BY workdeptARRANGE BY 2

C. SELECT workdept, AVERAGE(salary)FROM employeeGROUP BY workdeptORDER BY 2

D. SELECT workdept, AVG(salary)FROM employeeGROUP BY workdeptORDER BY 2

Which statement about UPDATE processing is FALSE?

A. The UPDATE statement logs the before and after value of every column it modifies.

B. A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row.

C. When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified.

D. The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect.

Which statement about foreign keys is true?

A. A table can have only one foreign key.

B. Foreign keys can only be defined when a table is created.

C. A foreign key can be defined on a column or a set of columns in a table.

D. Foreign keys are enforced only during the execution of INSERT statements.

The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of the following?

A. Define a view on one or more tables or views.

B. Revalidate all invalid objects that are referenced on a view's fullselect.

C. Ensure that any inserted or updated rows conform to the definition of the view.

D. Define a view that only consists of columns that have check constraints defined.