Exam 1z0-061 topic 1 question 12 discussion

Actual exam question from Oracle's 1z0-061

Question #: 12
Topic #: 1

You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table.
Which query will generate the required result?

A. Option A
B. Option B
C. Option C
D. Option D B

Show Suggested Answer

Suggested Answer: Explanation 🗳️
FETCH can only be used with FIRST OR NEXT. The syntax is:
FETCH { FIRST | NEXT } [integer-literal | ? ] {ROW | ROWS} ONLY
OFFSET { integer-literal | ? } {ROW | ROWS}
Reference:
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljoffsetfetch.html

by cnyce at May 13, 2019, 5:12 p.m.

Comments

Submit Cancel

testing_for_oca

3 years ago

Selected Answer: B

B is correct answer

upvoted 1 times

...

Fatthalla

5 years, 2 months ago

"B" because of "first" "Desc" and no ties.

upvoted 1 times

...

Lif

5 years, 8 months ago

Correct answer is B

upvoted 1 times

...

luizyto

5 years, 9 months ago

B, C and D are invalid sintax and A does not has the correct order.

upvoted 1 times

...

cnyce

6 years ago

What is the answer here...not listed. Is it "C"?

upvoted 1 times

[Removed]

5 years, 9 months ago

I think this is B. fetch FIRST 5 oercent rows ONLY

upvoted 1 times

...

turtle

5 years, 9 months ago

The correct answer is b, salary order desc (from highest to lowest) and then fetch first 5 percent rows only (not mention that need to fetch more if they match)

upvoted 1 times

...