exam questions

Exam 1z0-071 All Questions

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

Exam 1z0-071 topic 1 question 151 discussion

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

Which two queries return the string Hello! We're ready? (Choose two.)

  • A. SELECT "Hello! We're ready" FROM DUAL;
  • B. SELECT 'Hello! We're ready' FROM DUAL;
  • C. SELECT q'!Hello! We're ready!' FROM DUAL;
  • D. SELECT q'[Hello! We're ready]' FROM DUAL;
  • E. SELECT 'Hello! We\'re ready’ ESCAPE '\' FROM DUAL;
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️

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
lucemqy
1 month, 3 weeks ago
Selected Answer: CD
CD is the correct answer
upvoted 2 times
...
WingL
6 months ago
Selected Answer: CD
100% C and D
upvoted 2 times
...
zouve
6 months, 2 weeks ago
CD are correct
upvoted 1 times
...
Orxan_H
6 months, 3 weeks ago
Selected Answer: CD
C D are correct
upvoted 1 times
...
Darnun
9 months, 2 weeks ago
Selected Answer: CD
CD is correct, checked in SQL Dev.
upvoted 1 times
...
Orakol
10 months, 2 weeks ago
Selected Answer: CD
A - ORA-00904 ERROR. B - ORA-00923 ERROR. C - Hello! We're ready D - Hello! We're ready E - ORA-00923 So correct: CD. I'm not sure what kind of Oracle Compiling tools use the people from other comments, but these are definitely the correct answers using Oracle Developer...
upvoted 3 times
...
Zumrud_Apaydin
10 months, 3 weeks ago
DE is correct answer
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