exam questions

Exam 1z0-144 All Questions

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

Exam 1z0-144 topic 1 question 105 discussion

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

View Exhibit 1 and examine the structure of the EMP table.

View Exhibit 2 and examine the PL/SQL block of code.

What is the outcome?

  • A. It gives an error because the return type is not valid.
  • B. It gives an error because the record type is not defined within the function.
  • C. It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid
  • D. It executes successfully and displays the names and salaries of all employees who earn the highest salary.
  • E. It executes successfully but does not display the names and salaries of all employees who earn the highest salary.
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️

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
luiseng
4 years, 8 months ago
Yeah, that's why answer is E
upvoted 2 times
Gianluca1988
4 years, 3 months ago
But the field names of the customed type and of the table do not match at all
upvoted 1 times
...
...
pancernick76
4 years, 10 months ago
Only one record will be returned.
upvoted 2 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