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.
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?
A. Option
B. Option
C. Option
D. Option
Which three are true about the procedure overloading feature? (Choose three.)
A. Each procedure can be a nested subprogram.
B. Each procedure's formal parameters can differ in data type or name.
C. Each procedure must use named notation to specify the corresponding actual parameters.
D. Each procedure's formal parameters must differ in name.
E. Each procedure can be a packaged subprogram.
F. Each procedure must use positional notation to specify the corresponding actual parameters.
G. Each procedure can be a standalone subprogram.
Examine the EMPLOYEES table structure:
Now, examine this code:
Which statement is true about the result of executing this block?
A. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.
B. It will return an error at line 2.
C. It will return an error at line 3.
D. It will return an error at line 8.
E. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
Examine this anonymous block of code:
Which two statements are true about the results of executing it? (Choose two.)
A. It will set all salaries to 0 if it executes successfully.
B. It will always return a compile time error because it lacks an EXCEPTION section.
C. It might return a run time error depending on who invokes it.
D. It will always automatically initialize v_raise.
E. It will set all salaries to NULL if it executes successfully.
F. It will always return a run time error because v_raise is not initialized.
Examine this statement which is submitted for compilation:
Which three are true? (Choose three.)
A. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
B. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
C. This program unit will compile successfully.
D. Initialization of min_bal can be done while using this packaged constant in another program.
E. Initialization of loan_amount can be done while using this packaged variable in another program.
F. This will not compile successfully because the min_bal constant must be initialized.
G. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
Which is true about counter variables in a FOR loop?
A. It must explicitly be declared.
B. It can be modified in the body of the loop.
C. It cannot be NULL.
D. It is accessible outside the body of the loop.
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
Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)
A. CREATE
B. DROP
C. UPDATE
D. SELECT
E. DELETE
F. ALTER
G. INSERT
Examine these statements:
Which two are true? (Choose two.)
A. Neither table will have a row inserted and committed.
B. Both tables will have a row inserted and committed.
C. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
D. The bank_activity_proc will not compile because of the commit.
E. Only one table will have a row inserted and committed.