ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-148 All Questions

View all questions & answers for the 1z0-148 exam
Go to Exam

Exam 1z0-148 topic 1 question 1 discussion

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

The STUDENTS table exists in your schema.
Examine the DECLARE section of a PL/SQL block:

Which two blocks are valid?

  • A. BEGIN OPEN cursor3 FOR SELECT * FROM students; cursor1 :=cursor3; END;
  • B. BEGIN OPEN stcur; cursor1 :=stcur; END;
  • C. BEGIN OPEN cursor1 FOR SELECT * FROM students; stcur :=cursor1; END;
  • D. BEGIN OPEN stcur; cursor3 :=stcur; END;
  • E. BEGIN OPEN cursor1 FOR SELECT * FROM students; cursor2 :=cursor1;
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️
by dendevelop at March 29, 2019, 1:26 p.m.

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
Submit Cancel
dendevelop
Highly Voted 5 years, 8 months ago
AE - is correct answer
upvoted 12 times
...
Josephgreenson
Most Recent 3 years ago
Selected Answer: AE
only A and E works
upvoted 1 times
...
Benjmaz
3 years ago
A is the only correct answer. D would have qualified if it had an "END" statement. Note that code block should be in between the BEGIN and END statements
upvoted 1 times
...
sudhirdavim
3 years, 11 months ago
AE is correct answer.
upvoted 1 times
...
CosminCof
4 years ago
AE is right
upvoted 1 times
...
Swetank123
5 years, 1 month ago
AE is correct answer please check and repost the question.
upvoted 3 times
...
Dana
5 years, 3 months ago
I think that the correct answer is AE. "D" will return an "expression is of wrong type" error. Please re-check this!
upvoted 4 times
...
dendevelop
5 years, 8 months ago
Reason: You cannot assign a value to an explicit cursor, use it in an expression. stcur is explicit cursor in our example
upvoted 4 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago