Which two are true about packages? (Choose two.)

• A.Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.
• B.Package specifications can be compiled without their bodies.
• C.Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.
• D.A package definition must have a specification and body.
• E.Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about implicit data type conversion? (Choose two.)

• A.Comparison between character value and a number value always implicitly converts the character value to the number data type.
• B.Collections can be implicitly converted to records.
• C.RAW data types are always implicitly converted to a CLOB when used in a query.
• D.Implicit data type conversion can negatively impact performance.
• E.ROWIDS are always implicitly converted to a number when used in a query.

Comment: *

Name: *

Email: *

Verification: *

Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

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

Comment: *

Name: *

Email: *

Verification: *

Examine these statements which execute successfully:

Which anonymous block executes successfully?

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

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

Comment: *

Name: *

Email: *

Verification: *