1Z1-144 試験問題を無料オンラインアクセス

Which tasks must be performed during the installation of the UTL_MAIL package? (Choose all that apply.)

• A.granting read and WRITE privileges to control the type of access to files in the operating system
• B.using the CREATE DIRECTORY statement to associate an alias with an operating system directory
• C.setting the UTL_FILE_DIR initialization parameter
• D.running the UTLMAIL.SQL and prvtmail.plb scripts
• E.setting the SMTP_OUT_SERVER initialization parameter

View the Exhibit and examine the code:

Which statement is true about the COMPILE_CODE procedure?

• A.It executes successfully, but displays a warning about the unreachable code when used for the PROC1 procedure.
• B.It gives an error in line 6.
• C.It executes successfully, but a warning about the unreachable code is not displayed when used for the PROC1 procedure.
• D.It gives an error in line 5.
• E.It gives an error in line 8.

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

• A.A procedure can contain a return statement without a value.
• B.A function can return multiple values using a single return clause,
• C.A procedure can be executed as part of a SQL expression or as a PL/SQL statement,
• D.A function can contain zero or more parameters that are transferred from the calling environment.

Which two statements are true about database triggers? (Choose two.)

• A.Each trigger can be of any size.
• B.Each trigger can be of a maximum size of 32 K
• C.Both DML and DDL statements can cascade any number of triggers,
• D.Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers
• E.Triggers fired by DML statements cannot cascade simultaneously.
• F.A trigger can contain a maximum of 32 lines of code.

View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables.
EMPLOYEES

DEPAERTMENT

EMP_BY_DEPT

Examine the following code:

What is the outcome on execution of the above code?

• A.It gives an error because the INSERT SELECT construct cannot be used with the FORALL
• B.It gives an error because the SQL%ROWCOUNT attribute cannot be used with BULK COLLECT.
• C.It executes successfully but the output statements show different values.
• D.It executes successfully and both output statements show the same values.