A.It displays prod IDs in the promo with the lowest cost.

B.It displays prod IDs in the promos with the highest cost in the same time interval.

C.It displays prod IDs in the promos which cost less than the highest cost in the same time interval.

D.It displays prod IDs in the promos with the lowest cost in the same time interval.

A.WHEREand HAVINGclauses cannot be used together in a SQL statement.

B.The HAVINGclause conditions can have aggregate functions.

C.The WHEREclause is used to exclude rows before the grouping of data.

D.The HAVINGclause conditions can use aliases for the columns.

E.The HAVINGclause is used to exclude one or more aggregated results after grouping data.

A.The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

B.Insert statements can always be done on a table through a view.

C.Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.

D.Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.

E.Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains aggregating functions.

F.Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

A.SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;

B.SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM BOOKS_TRANSACTIONS;

C.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

D.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

A.If a query filters on an indexed column then it will always be used during execution of the query

B.A DROP INDEX statement always prevents updates to the table during the drop operation

C.A UNIQUE and non-unique index can be created on the same table column

D.An index can be created as part of a CREATE TABLE statement.

E.An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table.

F.A descending index is a type of function-based index