READ Free Dumps For Oracle- 1z0-001
| Question ID 8126 | In which section of a PL/SQL block is a user defined exception raised?
|
| Option A | Heading.
|
| Option B | Executable.
|
| Option C | Declarative.
|
| Option D | Exception handling.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because in the executable section of PL/SQL block a user-defined exception raised. See also question # 42. Incorrect Answers: A: Heading section of PL/SQL block is used for function, procedure, package naming, not for exceptions. C: Declarative section of PL/SQL block, which is optional, identifies all variables constructs that will be used in the code block. D: Exception handling section of PL/SQL block defines all errors that may occur in the block and specifies how they should be handled. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 209 Chapter 5: Introducing PL/SQL
| Question ID 8127 | Which statement is true about nesting blocks?
|
| Option A | Variable name must be unique between blocks.
|
| Option B | A variable defined in the outer block is visible in the inner blocks.
|
| Option C | A variable defined in the inner block is visible in the outer blocks.
|
| Option D | A variable is in an inner block may have the same name as a variable in an outer block only if the data types are different.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because a variable defined in the outer block is visible and can be used in the inner block. Incorrect Answers: A: Variables can have the same names in the outer and inner blocks. Question where and what variable will be used will be defined by the block scopes. C: A variable from the inner block IS NOT visible from the outer block. D: Both variables in the inner and outer blocks can have the same name and the same data type. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 213 Chapter 5: Introducing PL/SQL