Chapter 10, Analyzing PL/SQL Code

Question No.	Answer	Explanation
1	b	The ALL_ARGUMENTS dictionary view captures the information about the subprogram arguments.
2	d	Server places the identifier information in the SYSAUX tablespace.
3	a	The parameter values used in the subprograms of the DBMS_METADATA package are case sensitive.
4	b	The FORMAT_CALL_STACK forms the stack of all program units traversed by the server.
5	b and c	The DBMS_METADATA package can generate reports for table grants, object dependencies and DDL of given objects in a schema.
6	b	The PL/Scope tool can store the identifier data in the SYSAUX tablespace only.
7	a and b	For tables and views, the DDL script can be extracted without a storage clause by setting the STORAGE parameter to FALSE. Similarly, views scripts can be made force free by setting the FORCE parameter to FALSE.