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;