Which three statements can process a dynamic multi-row query? (Choose three.)

• A.INTO
• B.FETCH
• C.WHEN
• D.OPEN
• E.CLOSE
• F.OPEN-FOR
• G.DECLARE

Comment: *

Name: *

Email: *

Verification: *

Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

• A.ANONYMOUS BLOCK
• B.TRIGGER BODY
• C.PACKAGES
• D.DATABASE LINKS
• E.VARIABLES

Comment: *

Name: *

Email: *

Verification: *

User ORA41 executes these statements successfully:
Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)

• A.ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
• B.The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
• C.The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
• D.The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
• E.No update happens even though the procedure executes successfully.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about functions and procedures? (Choose three.)

• A.In a procedure the RETURN statement cannot specify an expression.
• B.In a function every RETURN statement must specify an expression.
• C.Both can be invoked from within SQL statements.
• D.Both can have only constants as actual parameters for IN mode parameters.
• E.In a function, every execution path must lead to a RETURN statement.
• F.The ACCESSIBLE BY clause can be used only for procedures.

Comment: *

Name: *

Email: *

Verification: *

Examine this code:
ALTER SESSION SET plsql_warnings='ENABLE:ALL';
/
You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?

• A.It fails compilation.
• B.An information compilation warning is generated.
• C.A performance compilation warning is generated.
• D.There are no compilation warnings or errors.
• E.A severe compilation warning is generated.

Comment: *

Name: *

Email: *

Verification: *