Final Exam MSCD650
Name:_________________
True/False
Indicate whether the sentence or statement is true or false.
____ 1. The EXECUTE IMMEDIATE statement prepares (parses) and immediately executes a dynamic SQL statement or an anonymous PL/SQL block.
____ 2. The %TYPE feature allows you to anchor variable declarations to a column in a table.
____ 3. COMMIT and ROLLBACK end the active autonomous transaction but do not exit the autonomous routine.
____ 4. The only required sections of a PL/SQL block are BEGIN and END.
____ 5. The EXCEPTION handling section is an optional section in a PL/SQL block.
____ 6. The keyword DEFAULT can be used in place of the := symbol to assign initial values to the variables within the declaration statement.
____ 7. Declaring a table of records variable in a package specification allows it to persist for a user session.
____ 8. Implicit cursors are declared automatically for all INSERT, UPDATE, and DELETE statements issued within a PL/SQL block.
____ 9. You can process multiple rows of data from a database by creating explicit cursors.
____ 10. With an implicit cursor, Oracle closes the SQL cursor automatically after executing its associated SQL statement. As a result, %ISOPEN always yields FALSE.
____ 11. The basic loop uses the LOOP and END LOOP markers to begin and end the loop code.
____ 12. Dynamic SQL lets you write schema-management procedures that can be centralized in one schema, and can be called from other schemas and operate on the objects in those schemas.
____ 13. In PL/SQL, if a SELECT ... INTO statement returns no rows, Oracle does not return an error.
____ 14. In PL/SQL, a SELECT ... INTO statement is an example of an explicit cursor.
____ 15. In Oracle 10g, PL/SQL performance is improved across the board. Most improvements are automatic, with no action required from