A.WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND (member_id = A101' OR member_id = 'A102'));

B.WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' OR member_id IN ('A101', 'A102'));

C.WHERE (borrowed_date = SYSDATE AND transaction_type = 'RM') OR member_id IN ('A101', 'A102');

D.WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');

E.WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101', 'A102');

A.It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.

B.It returns an error because the HAVINGclause should be specified after the GROUP BYclause.

C.It returns an error because all the aggregate functions used in the HAVINGclause must be specified in the SELECT list.

D.It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.

A.It must have primary-key and foreign-key constraints defined on the join columns.

B.It requires column names to be the same in all tables being joined.

C.It only applies for equijoin conditions.

D.It applies for equijoin and nonequijoin conditions.

A.ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.

B.The data and metadata for an external table are stored outside the database.

C.The default REJECT LIMIT for external tables is UNLIMITED.

D.The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table.

A.PROMO_BEGIN_DATE - 5 will return a date.

B.TO_NUMBER(PROMO_BEGIN_DATE) - 5 will return a number.

C.TO_DATE(PROMO_BEGIN_DATE * 5) will return a date.

D.PROMO_BEGIN_DATE - SYSDATE will return an error.

E.PROMO_BEGIN_DATE - SYSDATE will return a number.