exam questions

Exam 1z0-061 All Questions

View all questions & answers for the 1z0-061 exam

Exam 1z0-061 topic 3 question 33 discussion

Actual exam question from Oracle's 1z0-061
Question #: 33
Topic #: 3
[All 1z0-061 Questions]

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:
Show Suggested Answer Hide Answer
Suggested Answer: ACD 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
winston
1 year, 8 months ago
i cant understand why D is correct and B is wrong, someone who understands please explain
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago