Chapter 1, Overview of PL/SQL Programming Concepts

Question No.	Answer	Explanation
1	c	Currently, SQL Developer doesn't provide backup and recovery features. However, it can be done using a regular database export from SQL Developer.
2	a, c, and d	A function can be called from a SQL expression only if it doesn't hinder the database state and purity level.
3	a	The ALL_DEPENDENCIES dictionary view has been filtered by REFERENCED_TYPE and REFERENCED_OWNER for SYS owned tables and views.
4	c	The local variables are local to the block only. They cannot be referred outside their native PL/SQL block.
5	a, b, and d	An exception variable cannot be simply declared and used with RAISE_APPLICATION_ERROR. It has to be mapped to a self defined error number using PRAGMA EXCEPTION_INIT, and then raised through RAISE_APPLICATION_ERROR with an exception message.
6	a and b	A function must return a value using the RETURN statement while a procedure might return a value through the OUT parameters. Standalone subprograms (functions and procedures) cannot be overloaded. Only the subprograms declared in a package can be overloaded. Both procedures and functions can accept parameters in either of the two modes— pass by value and pass by reference.
7	c	For implicit cursors, the %FOUND attribute is set to TRUE, if the SQL statement fetches a minimum of one record.