READ Free Dumps For Oracle- 1z0-001
| Question ID 8124 | Given the executable section of a PL/SQL block FOR employee_record IN Salary_Cursor Loop employee_id_table (employee_id):= employee_record.last_name; END Loop Close Salary_Cursor; END; Why does this section cause an error?
|
| Option A | The cursor needs to be opened.
|
| Option B | Terminating conditions are missing.
|
| Option C | No FETCH statements were issued.
|
| Option D | The cursor does not need to be explicitly closed.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct because cursor does not need to be closed if it's cursor for loop. The cursor for loop opens, parses and executes the cursor automatically. Incorrect Answers: A: By definition cursor for loop does not need to be open. B: Loop will be terminated automatically when cursor will not contain any more records. C: By definition cursor for loop does not need to issue FETCH statement to extract data from cursor for processing. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 233-234 Chapter 5: Introducing PL/SQL
| Question ID 8125 | To remove all the data from employee table while leaving the table definition intact. You want to be able to undo this operation. How would you accomplish this task?
|
| Option A | DROP TABLE employee.
|
| Option B | DELETE FROM employee.
|
| Option C | TRUNCATE TABLE employee.
|
| Option D | This task can't be accomplished.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because using DELETE FROM statement you just delete all rows in the table while leaving the table definition intact. Also DELETE FROM statement is DML operation, so it can be rolled back if you want to undo this operation. Incorrect Answers: A: DROP TABLE command will delete not only all rows from the table but table itself also without possibility to undo changes. C: Command TRUNCATE TABLE will leave the table definition, deleting all rows in the table. But it is impossible to undo this operation which eliminate this answer. D: This task can be successfully completed with DELETE FROM command. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 123 Chapter 3: Creating database objects