ALTER TABLE SPLIT PARTITION

ALTER TABLE MERGE PARTITION

ALTER TABLE TRUNCATE PARTITION

ALTER TABLE ADD PARTITION

ALTER TABLE DROP PARTITION

They can be performed on external tables using SQL* Loader.

They can be performed on relational tables.

They can be performed only by using a subquery.

They can insert each computed row into more than one table.

They can be performed on views.

The nested query executes after the outer query returns the row.

The nested query executes first and then the outer query executes.

The outer query executes only once for the result returned by the inner query.

Each row returned by the outer query is evaluated for the results returned by the inner
query.

SELECT LISTAGG(last_name)WITHIN GROUP ORDER BY (hire_date) “Emp_list”, MIN(hire_date)
“Earliest”FROM employeesWHERE department_id = 30;

SELECT LISTAGG(last_name, '; ')WITHIN GROUP ORDER BY (hire_date) “Emp_list”,
MIN(hire_date) “Earliest”FROM employeesWHERE department_id = 30;

SELECT LISTAGG(last_name, '; ') “Emp_list”, MIN(hire_date) “Earliest”FROM employeesWHERE
department_id = 30;WITHIN GROUP ORDER BY (hire_date);

SELECT LISTAGG(last_name, '; ') “Emp_list”, MIN(hire_date) “Earliest”FROM employeesWHERE
department_id = 30;ORDER BY (hire_date);

The data dictionary is created and maintained by the database administrator.

Data dictionary views consist of joins of dictionary base tables and user-defined tables.

The usernames of all users including database administrators are stored in the data dictionary.

The USER_CONS_COLUMNS view should be queried to find the names of columns to which
constraints apply.

Both USER_OBJECTS and CAT views provide the same information about all objects that are owned
by the user.

The WHERE and HAVING clauses can be used in the same statement only if they are
applied to different columns in the table.

The aggregate functions and columns used in the HAVING clause must be specified in
the SELECT list of the query.

The WHERE clause can be used to exclude rows after dividing them into groups.

The HAVING clause can be used with aggregate functions in subqueries.

The WHERE clause can be used to exclude rows before dividing them into groups.

The output is sorted by the UNION ALL operator

The names of columns selected in each SELECT statement must be identical

The number of columns selected in each SELECT statement must be identical

Duplicates are eliminated automatically by the UNION ALL operator

NULLS are not ignored during duplicate checking

Option A

Option B

Option C

Option D