Examine the structure and data of the CUSTJTRANS table: CUSTJRANS Name Null?

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.)

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:



Leave a Reply 3

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


Bhavin

Bhavin

because date is stored in dd-mon-yy format

vicko

vicko

why d ? explain please