A.SELECT order_idFROM order_itemsGROUP BY order_idHAVING
SUM(unit_price*quantity) = (SELECT MAX (SUM(unit_price*quantity))FROM order_items GROUP BY order_id);

B.SELECT order_idFROM order_itemsWHERE(unit_price*quantity)
MAX(unit_price*quantity)GROUP BY order_id);

C.SELECT order_idFROM order_itemsWHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity)FROM order_itemsGROUP BY order_id)

D.SELECT order_idFROM order_itemsWHERE(unit_price*quantity) = (SELECT MAX (SUM(unit_price*quantity)FROM order_items) GROUP BY order_id);

A.Multiple columns or expressions can be compared between the main query and subquery.

B.Subqueries can contain ORDER BYbut not the GROUP BYclause.

C.Main query and subquery can get data from different tables.

D.Subqueries can contain GROUP BY and ORDER BYclauses.

E.Main query and subquery must get data from the same tables.

F.Only one column or expression can be compared between the main query and subquery.

A.The FIRST_NAME column can be dropped even if it is part of a composite PRIMARY KEY provided the CASCADE option is added to the SQL statement.

B.The FIRST_NAME column would be dropped provided at least one column remains in the table.

C.The drop of the FIRST_NAME column can be rolled back provided the SET UNUSED option is added to the SQL statement.

D.The FIRST_NAME column would be dropped provided it does not contain any data.

A.the access driver TYPE clause

B.the ACCESS PARAMETERS clause

C.the DEFAULT DIRECTORY clause

D.the LOCATION clause

E.the REJECT LIMIT clause

A.All roles are owned by the SYS schema.

B.System privileges always set privileges for an entire database.

C.A user has all object privileges for every object in their schema by default.

D.PUBLIC acts as a default role granted to every user in a database.

E.PUBLIC can be revoked from a user.

F.A role can contain a combination of several privileges and roles.

G.A role is owned by the user who created it.