exam questions

Exam 1z0-051 All Questions

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

Exam 1z0-051 topic 1 question 3 discussion

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

Here is the structure and data of the CUST_TRANS table:
Exhibit:

CUST_TRANS -
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-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 * FROM cust_trans WHERE transdate = '01-01-07';
  • C. SELECT transamt FROM cust_trans WHERE custno > '11';
  • D. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';
  • E. SELECT custno + 'A' FROM cust_trans 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
PhilA99
1 year, 5 months ago
option d does not work because you need to convert string to a date using to_date
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