We provide real 1Z0-144 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Oracle 1Z0-144 Exam quickly & easily. The 1Z0-144 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Oracle 1Z0-144 dumps pdf and vce product and material, you can easily pass the 1Z0-144 exam.
♥♥ 2017 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
Q21. View Exhibit1 and examine the structure of the employees table.
View Exhibit2 and examine the code.
What is the outcome when the code is executed?
A. Both blocks compile and execute successfully when called.
B. Both blocks compile successfully but the CALC_SAL procedure gives an error on execution.
C. The CALC_SAL procedure gives an error on compilation because the amt variable should be declared in the RAISE_SALARY procedure.
D. The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY procedure cannot call the stand-alone increase function.
Q22. Examine the following PL/SQL code;
The execution of the code produces errors. Identify the error in the code.
A. The open cursor is missing
B. The fetch clause is missing
C. The exit when condition is missing
D. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.
Q23. View the Exhibit to examine the PL/SQL code.
SERVEROUTPUT is on for the session.
Which statement is true about the execution of the code?
A. The execution fails because of the misplaced else clause.
B. The execution is successful even if there is no employee with EMPLOYEE_ID 115.
C. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found.
D. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.
Q24. View the exhibit and examine the structure of the EMPLOYEE table.
EMPLOYEE_SEQ is an existing sequence.
Examine the following block of code:
Which statement is true about the above block of code?
A. It consists of two transactions
B. It consists of a single transaction,
C. The data is automatically committed after the block execution ends,
D. It gives an error on execution because sequences cannot be used in anonymous blocks.
Q25. View the exhibit to examine the PL/SQL code.
Which statement is true about the exception handlers in the PL/SQL code?
A. All the exceptions in the code are trapped by the exception handler.
B. All the "no data found" errors in the code are trapped by the exception handler.
C. The PL/SQL program does not execute because an exception is not declared in the declare section.
D. An exception handler in the code traps the "no data found" error after executing the handler code and the program flow returns to the next line of code.
Q26. View Exhibit1 and examine the structure of the product table.
View Exhiblt2 and examine the procedure you created. The procedure uses the prod id to determine whether the list price is within a given range.
You then create the following trigger on the product table.
CREATE OR REPLACE TRIGGER check_price__trg
BEF0RE INSERT OR UPDATE OF prod_id, prod_list_price
ON product FOR EACH ROW
WHEN (nev.prod_id <> NVX(old.prod_id,0) OR
New.prod__list_price <> NVL(old.prod_list_price, 0) )
check_price (: new.prod_id) ;
Examine the following update command for an existing row in the product table.
SQL> UPDATE produce SET prod_list_price = 10 WHERE prod_id=115;
Why does it generate an error?
A. Because the procedure call in the trigger is not valid
B. Because the condition specified in the when clause is not valid
C. Because both the procedure and trigger access the same table
D. Because the WHEN clause cannot be used with a row-level trigger
E. Because the column list specified with UPDATE in the trigger is not valid
Q27. View the Exhibit and examine the structure of the SALGRADE table.
Examine the following code:
What is the outcome?
A. It is created successfully.
B. It gives an error because the return clause condition is invalid.
C. It gives an error because the usage of the host variables is invalid.
D. It gives an error because the data type of the return clause is invalid.
Q28. Which statement is true about triggers on data definition language (DDL) statements?
A. They can be used to track changes only to a table or index.
B. They can be defined by all users in the database or only by a specific user.
C. They are fired only when the owner of the object Issues the DDL statement.
D. They can be used to track changes to a table, table space, view, or synonym.
Q29. Examine the following code:
The above code generates an error on execution.
What must you do to ensure that the code executes successfully?
A. Use the TO_DATE function in line 2.
B. Use the TO_DATE function in line 7.
C. Use the TO_NUMBER function in line 6.
D. Use both the TO_DATE function in line 2 and the TO_NUMBER function in line 6.
Q30. Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)
A. AFTER LOGON
B. AFTER STARTUP
C. BEFORE SHUTDOWN
D. AFTER SERVERERROR