Which two are true about exception handling? (Choose two.)

• A.Predefined exceptions are globally declared in the standard package.
• B.User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
• C.Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
• D.All declared exceptions are raised implicitly by the runtime system.
• E.Internally defined exceptions can be handled only by the OTHERS exception handler.

Comment: *

Name: *

Email: *

Verification: *

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 PARALLEL_ENABLE clause can be specified for a nested function.
• C.A function is deterministic if it always returns the same result for a specific combination of input values.
• D.The NOCOPY hint asks the compiler to pass the actual parameters by value.
• E.A deterministic function's results always depend on the state of session variables.
• F.The NOCOPY hint asks the compiler to pass the actual parameters by reference.
• 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.

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.
A row exists with EMPLOYEE_ID 201.
Examine these packages created by user HR:

EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)

• A.Call HR.HELPER.H1 from the HR schema.
• B.Call HR.API.P1 from the SH schema.
• C.Call HR.API.P1 from the HR schema.
• D.Create and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.
• E.Call HR.HELPER.H1 from the SH schema.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about user-defined records?

• A.The number of fields must match the number of columns in a table.
• B.Field names must match selected column names.
• C.They can be returned from a function.
• D.Field types must match column types.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *