Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?

A. ALTER TABLE sales ADD COLUMN item CHAR(40);

B. ALTER TABLE sales ALTER COLUMN item CHAR(40);

C. ALTER TABLE sales MODIFY COLUMN item CHAR(40);

D. ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);

Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. Which SQL statement will produce the desired list?

A. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON employees.id = sales.emp_id

B. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON sales.emp_id = employees.id

C. SELECT employees.name, sales.revenue FROM sales LEFT OUTER JOIN employees ON employees.id = sales.emp_id

D. SELECT employees.name, sales.revenue FROM sales RIGHT OUTER JOIN employees ON employees.id = sales.emp_id

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 privilege is required to invoke a user defined function?

A. CALL

B. USAGE

C. EXECUTE

D. REFERENCES

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 type of constraint can be used to tell the DB2 Optimizer that a parent-child relationship exists between two tables, but that the relationship is not enforced?

A. Check

B. Unique

C. Referential

D. Informational

What is the primary purpose for using the INCLUDE clause with a CREATE UNIQUE INDEX statement?

A. To override the limit on index key columns.

B. To further enforce the uniqueness of index values.

C. To combine two or more indexes to create a single unique index.

D. To improve performance of some queries by allowing index-only access.

What are INSTEAD OF triggers used for?

A. To update data in other tables.

B. To perform insert, update, and delete operations against complex views.

C. To check or modify values before they are actually stored in a database.

D. To run non-database operations that are coded in user-defined functions.

Application APP_A is performing updates to table TAB1 using the read stability (RS) isolation level. Which isolation level will allow application APP_B to retrieve all rows from table TAB1 immediately, rather than have to wait until application APP_A has finished making updates?

A. Read Stability (RS)

B. Cursor Stability (CS)

C. Repeatable Read (RR)

D. Uncommitted Read (UR)

If no isolation level is specified, what is the default isolation level used?

A. Cursor Stability (CS)

B. Repeatable Read (RR)

C. Read Stability (RS) with Currently Committed semantics

D. Cursor Stability (CS) with Currently Committed semantics