Which three SQL statements would execute successfully?

Here is the structure and data of the CUST_TRANS table:
Exhibit:

Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table. Which three SQL statements
would execute successfully? (Choose three.)

Here is the structure and data of the CUST_TRANS table:
Exhibit:

Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table. Which three SQL statements
would execute successfully? (Choose three.)

A.
SELECT transdate + ’10’ FROM cust_trans;

B.
SELECT * FROM cust_trans WHERE transdate = ’01-01-07′;

C.
SELECT transamt FROM cust_trans WHERE custno > ’11’;

D.
SELECT * FROM cust_trans WHERE transdate=’01-JANUARY-07′;

E.
SELECT custno + ‘A’ FROM cust_trans WHERE transamt > 2000;



Leave a Reply 0

Your email address will not be published. Required fields are marked *