Exit 1Z0-061 Oracle Database 12c: SQL Fundamentals
Question 5 of 5
0% complete
Q5 Multiple choice

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

Select all that apply.

  • 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:

Previous Save & finish