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 custno + ‘A’ FROM cust_trans WHERE transamt > 2000;
C.
SELECT * FROM cust_trans WHERE transdate=’01-JANUARY-07′;
D.
SELECT * FROM cust_trans WHERE transdate = ’01-01-07′;
E.
SELECT transamt FROM cust_trans WHERE custno > ’11’;
‘D’ seems right too, isnt it? Implicit conversion to date format without error:
select * from (select trunc(sysdate) t from dual) a where a.t > ’01-01-07′
While C depends on nls language settings.
D is not correct.
The implictit conversion will not work because the Dates are stored in the
default date format dd-mm-rr.
The following statment gives an error ( ORA-01843: not a valid month)
SELECT 2 FROM dual WHERE sysdate > ’01-01-07′;