A.SELECT * FROM MEMBERS WHERE state LIKE 'A_%';

B.SELECT * FROM MEMBERS WHERE state LIKE '%A_';

C.SELECT * FROM MEMBERS WHERE state LIKE 'A%';

D.SELECT * FROM MEMBERS WHERE state LIKE 'A_';

A.Option A

B.Option B

C.Option D

D.Option C

A.CONCAT(qty_sold, invoice_date): requires explicit conversion

B.invoice_date > '01-02-2019': uses implicit conversion

C.invoice_date = '15-march-2019': uses implicit conversion

D.qty_sold BETWEEN '101' AND '110': uses implicit conversion

E.qty_sold = '0554982': requires explicit conversion

A.There is no row containing pen.

B.There is no row containing pencil.

C.The code for pen is 10.

D.The code for pen is 1.

E.There is no row containing fountain pen.

F.The code for fountain pen is 3.

A.Any GLOBAL TEMPORARY TABLErows existing at session termination will be deleted.

B.GLOBAL TEMPORARY TABLErows inserted by a session are available to any other session whose user has been granted select on the table.

C.GLOBAL TEMPORARY TABLEspace allocation occurs at session start.

D.A DELETE command on a GLOBAL TEMPORARY TABLEcannot be rolled back.

E.A GLOBAL TEMPORARY TABLE'sdefinition is available to multiple sessions.

F.A TRUNCATEcommand issued in a session causes all rows in a GLOBAL TEMPORARY TABLEfor the issuing session to be deleted.