Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

• A.It can be used in the declaration of object types.
• B.It must be specified in the heading of a package specification.
• C.The check is enforced by this clause for direct access and access through dynamic SQL.
• D.It can be used for individual procedures and functions declared in a package specification.
• E.It must be specified in the heading of a package body.

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

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 9.
• B.It returns an error in line 4.
• C.It executes and displays output.
• D.It returns an error in line 2.

Comment: *

Name: *

Email: *

Verification: *

Examine this table in the SH schema:

User SH executes this code:

The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.
With which option must "---placeholder" be replaced?

• A.
• B.
• C.
• D.
• E.

Comment: *

Name: *

Email: *

Verification: *

Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

• A.It will return an error at line 8.
• B.It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.
• C.It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.
• D.It will return an error at line 3.
• E.It will return an error at line 2.

Comment: *

Name: *

Email: *

Verification: *