READ Free Dumps For Oracle- 1z0-001
| Question ID 8089 | You want to create a cursor that can be used several times in a block. Selecting a different active set each time that it is opened. Which type of cursor do you create?
|
| Option A | A cursor FOR loop.
|
| Option B | A multiple selection cursor.
|
| Option C | A cursor for each active set.
|
| Option D | A cursor that uses parameters.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct because a cursor with parameters can be used several times in a block, selecting active set each time that it was opened depending on parameters' values. Incorrect Answers: A: A cursor for loop used for different purpose. B: A multiple selection cursor does not exist. C: A cursor for each active set does not allow to use the same cursor several times in a block. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 231-233 Chapter 5: Introducing PL/SQL
| Question ID 8090 | Which statement is true when writing a cursor FORloop?
|
| Option A | You must explicitly fetch the rows within a cursor FOR loop.
|
| Option B | You must explicitly open the cursor prior to the cursor FOR loop.
|
| Option C | You must explicitly close the cursor prior to the end of program.
|
| Option D | You do not explicitly open, fetch or close a cursor within a cursor FOR loop.
|
| Option E | You must explicitly declare the record variable that holds the row returned from the cursor.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer B is correct because when using a cursor FOR loop you don't need explicitly open, fetch or close a cursor (by definition of a cursor FOR loop). Incorrect Answers: A: You don't need explicitly fetch the cursor within a cursor FOR loop. B: You don't need explicitly open the cursor within a cursor FOR loop. C: You don't need explicitly close the cursor within a cursor FOR loop. E: You don't need to declare the record variable to hold the row from the cursor if you use a cursor FOR loop. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 233-234 Chapter 5: Introducing PL/SQL