A.Base tables can be queried directly

B.Data dictionary views are created by joins of dictionary base tables and DBA-defined tables

C.It is owned by the SYSTEM user

D.Usernames of all users including database administrators are stored in the data dictionary

E.Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

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

A.SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;

B.SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

C.SELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;

D.SELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY COUNT(-) > 10;

E.SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;

A.They can be used in the where clause.

B.They must return a row to prevent errors in the SQL statement.

C.A SQL statement may have multiple single row subquery blocks.

D.They can be used in the having clause.

E.They must be placed on the right side of the comparison operator or condition.

F.They must be placed on the left side of the comparison operator or condition.

A.External table files can be used for other external tables in a different database

B.The ORACLE_LOADER access driver can be used to unload data from a database into an external table

C.The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

D.They cannot be partitioned

E.The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

F.They support UPDATEs but not INSERTs and DELETEs

A.They can be used only in the WHERE clause of a SELECT statement

B.The argument can be a column name, variable, literal or an expression

C.The data type returned can be different from the data type of the argument

D.They can be nested to any level

E.They can accept only one argument

F.They return a single result row per table