Cause all that matters here is passing the Oracle 1Z0-144 exam. Cause all that you need is a high score of 1Z0-144 Oracle Database 11g: Program with PL/SQL exam. The only one thing you need to do is downloading Ucertify 1Z0-144 exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-144 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-144 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-144-exam-dumps.html
Q1. You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded.
The procedure should return an "error" condition to the caller in a manner consistent with other Oracle server errors.
Which construct should be used to handle this requirement?
A. The SQLERRM function
B. The PRAGMA EXCEPTION_INIT function
C. The RAISE_APPLICATION_ERROR procedure
D. A user-defined exception used with a raise statement
Answer: B
Explanation:
Reference: http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/exceptioninit_pragma.htm#LNPL S01315
Q2. View the Exhibit to examine the PL/SQL block.
Which statement is true about the execution of the PL/SQL block?
A. It executes successfully and gives the desired output.
B. It does not execute because the definition of type population is indexed by VARCHAR2.
C. It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.
D. It does not execute because the value that is once assigned to the element of the associative array cannot be changed.
Answer: A
Q3. 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. using the CREATE DIRECTORY statement to associate an alias with an operating system directory
E. granting read and WRITE privileges to control the type of access to files in the operating system
Answer: B,C
Q4. View Exhibit1 and examine the structure of the EMP table.
View Exhibit2 and examine the code.
EKPNOS 7845 and 7900 exist in the EMP table.
Which two calls to the RAISE_SALABY procedure in the anonymous block execute successfully? (Choose two.)
A. call in line 6
B. call in line 7
C. call in line 8
D. call in line 9
Answer: C,D
Q5. Examine the following partial code:
Which statement is correct about the unnamed block of code at the end of a package body?
A. It generates an error because all the blocks of code in a package body must be named.
B. It generates an error because V_TAXRATE is a public variable that is already initialized in the package specification.
C. It acts as a package initialization block that executes once, when the package is first invoked within the user session.
D. It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variable value.
Answer: C
Q6. Examine the following block of code:
Which two statements are correct about the code above? (Choose two.)
A. The function goes through only the parse and executes phases.
B. The function goes through the parse, bind, and execute phases.
C. The function goes through the parse, bind, execute, and fetch phases.
D. All the processing phases for the function are performed only at run time.
E. Only the EXECUTE IMMEDIATE statement inside the function is parsed at run time.
Answer: D,E
Q7. Examine the following PL/SQL code:
The server output is on for the session. Which statement is true about the execution of the code?
A. The code executes successfully and gives the desired output.
B. The code generates an error because the EMP_RECORD variable is not declared.
C. The code generates an error because the cursor is not opened before the FOR loop.
D. The code generates an error because the loop does not have the exit when clause.
Answer: A
Q8. Which two statements are true about triggers? (Choose two.)
A. All the triggers that are created on a table cannot be disabled simultaneously.
B. Any user who has the alter privilege on a table can create a trigger using that table.
C. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database.
D. 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.
Answer: C,D
Q9. Examine the following code:
What is the outcome?
A. The procedure is created successfully and displays the values 20 and 30 when it is called.
B. The procedure gives errors because the parameters should be in out mode.
C. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedure.
D. The procedure is created successfully but does not display any values when it is called because the host variables cannot be displayed inside the procedure.
Answer: C
Q10. View the Exhibit and examine the structure of the customer table.
You create the following trigger to ensure that customers belonging to category "A" or "B" in the customer table can have a credit limit of more than 8000.
What is the outcome?
A. The trigger is fired, a message is displayed, and the update is successful
B. The trigger is fired and a message is displayed, but the update is rolled back.
C. The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.
D. The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.
Answer: D
