READ Free Dumps For Oracle- 1z0-001
| Question ID 8093 | Evaluate this PL/SQL block: DECLARE v-result NUMBER(2); BEGINDELETE FROM employee WHERE dep_id IN (10,20,30); v-result:= SQL%ROWCOUNT; COMMIT; END; What will be the value of v_result if no rows are deleted?
|
| Option A | 0
|
| Option B | 1
|
| Option C | True
|
| Option D | Null
|
| Correct Answer | A |
Explanation Explanation/Reference: Explanation: Answer A is correct because if no rows are deleted SQL%ROWCOUNT attribute of cursor will return 0 - number of deleted rows. Incorrect Answers: B: No rows are deleted so SQL%ROWCOUNT will return 0, not 1. C: SQL%ROWCOUNT attribute of cursor returns always a numeric value, not BOOLEAN. D: SQL%ROWCOUNT attribute of cursor returns always a numeric value, which cannot be a NULL. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 224 Chapter 5: Introducing PL/SQL
| Question ID 8094 | Which two conditions in a PL/SQL block cause an exception error to occur? (Choose two)
|
| Option A | Select statement does not return a row.
|
| Option B | Select statement returns more than one row.
|
| Option C | Select statement contains a group by clause.
|
| Option D | Select statement does not have where clause.
|
| Option E | The data type in the select list are inconsistent with the data types in the into clause.
|
| Correct Answer | AB |
Explanation Explanation/Reference: Explanation: Answers A and B is correct because there are two common exceptions can cause an error : NO_DATA_FOUND, if no rows were selected or changed by the SQL operation or TOO_MANY_ROWS, if more than one row was obtained by a single-row subquery, or in another SQL statement operation where Oracle was expecting one row. Incorrect Answers: C: It will not be an exception error if SELECT statement contains a GROUP BY clause. D: It will not be an exception error if SELECT statement contains a WHERE clause. E: It will ROWTYPE_MISMATCH an exception error if the datatypes of the record to which data from the cursor is assigned are INCOMPATIBLE, but not INCONSISTENT as answer E says. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 239 Chapter 5: Introducing PL/SQL