A.creates a view with constraints
B.creates a view even if the underlying parent table has constraints
C.creates a view in another schema even if you don't have privileges
D.creates a view regardless of whether or not the base tables exist

A.You cannot update a view with group functions.
B.When you update a view group functions are automatically computed.
C.When you update a view only the constraints on the underlying table will be in effect.
D.When you update a view the constraints on the views always override the constraints on the underlying tables.

A.A
B.B
C.C
D.D
E.E

A.randomly
B.ascending by date
C.descending by date
D.ascending alphabetically
E.descending alphabetically

A.INSERT
B.UPDATE
C.SELECT
D.DESCRIBE
E.DELETE
F.RENAME

A.substitution variables
B.replacement variables
C.prompt variables
D.instead-of variables
E.This feature cannot be implemented through iSQL*Plus.

A.INSTR returns the numeric position of a named character.
B.NVL2 returns the first non-null expression in the expression list.
C.TRUNCATE rounds the column, expression, or value to n decimal places.
D.DECODE translates an expression after comparing it to each search value.
E.TRIM trims the heading or trailing characters (or both) from a character string.
F.NVL compares two expressions and returns null if they are equal, or the first expression if they are not equal.
G.NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.

A.SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000;
B.SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 GROUP BY dept_id;
C.SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
D.SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
E.SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;

A.COMMIT
B.MERGE
C.UPDATE
D.DELETE
E.CREATE
F.DROP...

A.Both tables have NULL values.
B.You want all unmatched data from one table.
C.You want all matched data from both tables.
D.You want all unmatched data from both tables.
E.One of the tables has more data than the other.
F.You want all matched and unmatched data from only one table.

A.ALTER TABLE commercials MODIFY (description CHAR2(1000));
B.ALTER TABLE commercials CHANGE (description CHAR2(1000));
C.ALTER TABLE commercials CHANGE (description VARCHAR2(1000));
D.ALTER TABLE commercials MODIFY (description VARCHAR2(1000));
E.You cannot increase the size of a column if the table has rows.