A. To provide a method of ensuring a column's values are within a specific range.

B. To ensure that XML columns are properly populated in an associated XML table space.

C. To enforce relationships between tables by checking the existence of rows in one table against another.

D. To provide a method of avoiding duplicate entries for a column.

A. View

B. Temporary table

C. Storage group

D. Buffer pool

A. SELECT job, MIN(salary), MAX(salary)
FROM employee
ORDER BY job;

B. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job, MIN(salary), MAX(salary);

C. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job;

D. SELECT JOB, MIN(salary), MAX(salary)
FROM employee
ORDER BY job, MIN(salary), MAX(salary);

A. SALES can be the name of a declared global temporary table.

B. SALES can be the name of a schema.

C. SALES can be the name of a package.

D. SALES can be the name of an existing alias.

A. The temporary table is converted to a base table and the data is persistent.

B. The data in the table is deleted and the table is implicitly dropped.

C. The data in the table is deleted and the table persists.

D. The temporary table is converted to a base table and the data is deleted.

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.

A. Primary keys and foreign keys are used to define relationships.

B. A foreign key can reference multiple primary keys.

C. A primary key can be referenced by only one foreign key.

D. Multiple primary keys can be defined for a table.