|
1) | B | When the SELECT statements are combined into a PL/SQL program, they are sent to the server as a single unit thus reducing network traffic. |
2) | B | Executable section is the only mandatory section for a PL/SQL block. As a result,
BEGIN
NULL; -- null statement
END;
is a valid PL/SQL block. |
3) | B | When a runtime error occurs in the PL/SQL block, control is passed to the exception-handling section of the block, where the error is evaluated and a specific exception is raised or executed. |
4) | A | A PL/SQL compiler is able to detect only syntax errors. It cannot detect any runtime errors because they do not occur prior to the execution of the program. |
5) | B | For named PL/SQL blocks, p-code is generated and stored in the database at the time of compilation. When named PL/SQL block is executed, its p-code is retrieved from the database and executed. For anonymous PL/SQL blocks, p-code is not stored in the database and is generated every time the PL/SQL block is executed. |
No comments:
Post a Comment