Online Access Free 1Z0-144 Exam Questions

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

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

Examine the following partial declare section from a block of PL/SQL code

Which line(s) in the above code are NOT valid? (Choose all that apply.)

• A.line 2
• B.line 3
• C.line 4
• D.line 5

Examine the following code:

Which statement is true about the execution of the above code?

• A.It fails because no value is assigned to the v_myage variable.
• B.It executes and control goes to the else statement.
• C.It executes and displays null.
• D.It executes and the condition returns true.

You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.
Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)

• A.It should be an after trigger.
• B.It can be a before or an after trigger.
• C.It should be a statement-level trigger.
• D.It should be a before trigger.
• E.It should be a row-level trigger.

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

• A.Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database.
• B.Any user who has the alter privilege on a table can create a trigger using that table.
• C.Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation.
• D.All the triggers that are created on a table cannot be disabled simultaneously.