Examine the structure and data of the CUSTJTRANS table: CUSTJRANS Name Null? Type
CUSTNO NOT NULL CHAR(2) TRANSDATE DATE TRANSAMT NUMBER(6.2) CUSTNO
TRANSDATE TRANSAMT 11 01-JAN-07 1000 22 01-FEB-07 2000 33 01-MAR-07 3000
Dates are stored in the default date format dd-mon-rr in the CUSTJTRANS table. Which
three SQL statements would execute successfully? (Choose three.)
A.
SELECT transdate + ’10’ FROM custjrans;
B.
SELECT * FROM custjrans WHERE transdate = ’01-01-07′:
C.
SELECT transamt FROM custjrans WHERE custno > ’11’:
D.
SELECT * FROM custjrans WHERE transdate=’01-JANUARY-07′:
E.
SELECT custno – ‘A’ FROM custjrans WHERE transamt > 2000:
A, C, D
http://www.aiotestking.com/oracle/examine-the-structure-and-data-of-the-custjtrans-table-custjrans-name-null/