If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?

A. 4

B. 8

C. 16

D. 32

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

What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

A. Read stability (RS)

B. Cursor stability (CS)

C. Repeatable read (RR)

D. Uncommitted read (UR)

Which function can be used to obtain values from XML documents that are to be inserted into one or more tables?

A. XMLTABLE

B. XMLPARSE

C. XMLEXISTS

D. XMLATTRIBUTES

Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and earns a salary of less than $35,000.00 per year?

A. SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' AND salary < 35000

B. SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' AND salary < 35000

C. SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' OR salary < 35000

D. SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' OR salary < 35000

Which statement about application-period temporal tables is true?

A. Consists of explicitly-supplied timestamps and a separate associated history table.

B. Is based on explicitly-supplied timestamps that define the time periods during which data is valid.

C. Is useful when one wants to keep both user-based period information and system-based historical information.

D. Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current.

Which statement about roll back operations is correct?

A. When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.

B. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.

C. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are released.

D. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.

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 employee ORDER BY workdept GROUP BY 2

B. SELECT workdept, AVG(salary) FROM employee ORDER BY workdept ARRANGE BY 2

C. SELECT workdept, AVERAGE(salary) FROM employee GROUP BY workdept ORDER BY 2

D. SELECT workdept, AVG(salary) FROM employee GROUP BY workdept ORDER BY 2

When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?

A. The SYSIBM schema.

B. The SYSFUN schema.

C. A schema with the name of the UDF.

D. A schema with the userid of the UDF definer.

Which type of table is best suited for recording results from application data manipulation that is not required to be persistent?

A. Base Table

B. Temporal Table

C. Transition Table

D. Temporary Table