Which is true about the PLSCOPE_SETTINGS parameter?

• A.It can be used to control execution of specific portions of the PL/SQL code conditionally.
• B.It can be used to obtain information about all identifiers when compiling a procedure.
• C.It can be used to control a user's privileges on PL/SQL objects at run time.
• D.It is deprecated in Oracle 12c.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about passing parameters to subprograms? (Choose three.)

• A.IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
• B.OUT parameters returning values to calling subprograms act like constants in the called subprogram.
• C.The actual parameter must be a variable when calling a subprogram with an OUT parameter.
• D.IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.
• E.PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.
• F.Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.
• G.IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

• A.A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
• B.The NOCOPY hint asks the compiler to pass the actual parameters by value.
• C.The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
• D.The NOCOPY hint asks the compiler to pass the actual parameters by reference.
• E.A deterministic function's results always depend on the state of session variables.
• F.The PARALLEL_ENABLE clause can be specified for a nested function.
• G.A function is deterministic if it always returns the same result for a specific combination of input values.

Comment: *

Name: *

Email: *

Verification: *

Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:

What is true about the result?

• A.It returns an error in line 2.
• B.It returns an error in line 4.
• C.It executes and displays output.
• D.It returns an error in line 9.

Comment: *

Name: *

Email: *

Verification: *

Which three are valid PL/SQL variable names? (Choose three.)

• A.Number_of_days_between_March_and_April
• B.#printer_name
• C.1to7number
• D.yesterday's_date
• E.v_fname
• F.leap$year
• G.printer_name#

Comment: *

Name: *

Email: *

Verification: *