Examine the structure and data of the CUST_TRANS table:
Dates are stored in the default date format dd-mon-rr in the CUST_TRANS table. Which three SQL statements would execute successfully?
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;
|
Download Printable PDF. VALID exam to help you PASS. |
 |