Which three are true about anonymous blocks and subprograms? (Choose three.)

• A.PROCEDURE subprograms can accept parameters.
• B.Anonymous blocks must always start with the Declare keyword.
• C.Anonymous blocks cannot use packaged variables.
• D.A FUNCTION subprogram must return one or more values.
• E.FUNCTION subprograms must be called and passed through one or more parameters.
• F.Named subprograms cannot be called from other packages.
• G.Named subprograms are stored in the database server.

Comment: *

Name: *

Email: *

Verification: *

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: *

Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

• A.%Isopen is always false in Explicit Cursor.
• B.Implicit cursor returns only one record.
• C.%Isopen is always false in Implicit Cursor.
• D.%Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
• E.%Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
• F.Explicit cursor can return more than one record.
• G.%Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

• A.ENABLE
• B.ERROR
• C.SEVERE
• D.ALL
• E.DISABLE

Comment: *

Name: *

Email: *

Verification: *