Deprecated PL SQL Elements

1- Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.) A. PACKAGES B. VARIABLES C. ANONYMOUS BLOCK D. TRIGGER BODY E. DATABASE LINKS 2- Which three are true about functions and procedures? (Choose three.) ​ A. The ACCESSIBLE BY clause can be used only for procedures. ​ B. In a function, every execution path must lead to a RETURN statement. ​ C. Both can have only constants as actual parameters for IN mode parameters. ​ D. Both can be invoked from within SQL statements. ​ E. In a procedure the RETURN statement cannot specify an expression. ​ F. In a function every RETURN statement must specify an expression. ​ 3- Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.) ​ A. PL/SQL code can be compiled and executed based on different versions of the operating system. ​ B. PL/SQL code can be compiled and executed based on different versions of Oracle. ​ C. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'. ​ D. Conditional compilation is disabled by default. ​ E. The PL/SQL compiler can conditionally include selected parts of a program. ​ 4- Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.) ​ A. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement. ​ B. The NOCOPY hint asks the compiler to pass the actual parameters by reference. ​ C. A deterministic function's results always depend on the state of session variables. ​ D. The NOCOPY hint asks the compiler to pass the actual parameters by value. ​ E. A function is deterministic if it always returns the same result for a specific combination of input values. ​ F. The PARALLEL_ENABLE clause can be specified for a nested function. ​ G. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement. 5- Which two are true about INDEX-BY tables? (Choose two.) ​ A. The index can be integer or string. ​ B. The index can be integer only. ​ C. INDEX-BY table types can be created in PL/SQL blocks only. ​ D. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks. ​ E. INDEX-BY table types can be created with the CREATE TYPE statement. 6- Which three are true about anonymous blocks and subprograms? (Choose three.) ​ A. Named subprograms cannot be called from other packages. ​ B. PROCEDURE subprograms can accept parameters. ​ C. A FUNCTION subprogram must return one or more values. ​ D. Anonymous blocks cannot use packaged variables. ​ E. Named subprograms are stored in the database server. ​ F. Anonymous blocks must always start with the Declare keyword. ​ G. FUNCTION subprograms must be called and passed through one or more parameters. 7- Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.) ​ A. Function based indexes remain usable when replacing the function on which the index depends. ​ B. Object privileges to execute a replaced function must be regranted to those users who had the privilege. ​ C. This clause can be used only for procedures and functions. ​ D. A function definition can be modified without dropping and re-creating it. ​ E. Object privileges to execute a replaced function are retained by those users who had the privileges. 8- Examine the SH.PRODUCTS table: A row exists in SH.PRODUCTS with PDT_ID = 1. Now, examine this code and output executed by SH Now, examine this block of code: Which error message(s) does it display on execution by user SH? ​ A. Error in inner block ​ B. Error in inner block Error in outer block ​ C. Error in inner block Error in calling block ​ D. Error in inner block Error in outer block Error in calling block