A.16

B.200

C.100

D.160

E.150

A.IT executes successfully and gives the correct output.

B.It executes successfully but does not give the correct output.

C.It generates an error because the concatenation operator can be used to combine only two items.

D.It generates an error because the usage of the ROUNDfunction in the expression is not valid.

E.It generates an error because the alias is not valid.

A.SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP

B.COUNT(*) > 10;
SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP

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

D.

E.BY COUNT(*) > 10;
SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;

A.You cannot use SYSDATEin the condition of a CHECKconstraint.

B.You cannot use ORD_NOand ITEM_NOcolumns as a composite primary key because ORD_NOis also the FOREIGN KEY.

C.You cannot use the NEXTVALsequence value as a DEFAULTvalue for a column.

D.You cannot use the BETWEENclause in the condition of a CHECKconstraint.

A.By default, the output is not sorted.

B.Null values are not ignored during duplicate checking.

C.Names of all columns must be identical across all select statements.

D.The number of columns selected in all select statements need not be the same.