Our pass rate is high to 98.9% and the similarity percentage between our 1Z0-144 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Oracle 1Z0-144 exam in just one try? I am currently studying for the Oracle 1Z0-144 exam. Latest Oracle 1Z0-144 Test exam practice questions and answers, Try Oracle 1Z0-144 Brain Dumps First.
Q51. 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.
Q52. 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
Q53. In which of the following scenarios would you recommend using PL/SQL records?
A. when you want to retrieve an entire row from a table and perform calculations
B. when you know the number of elements in advance and the elements are usually accessed sequentially
C. when you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries
D. when you want to create a relatively small lookup table, where the collection can be constructed in memory each time a subprogram is invoked
Q54. Which two statements are true about the exit statement encountered in loop? (Choose two)
A. The PL/SQL block execution terminates immediately after the exit statement.
B. The loop completes immediately and control passes to the statement after end loop
C. The statements after the exit statement in the Iteration are not executed before terminating the LOOP.
D. The current iteration of the loop completes immediately and control passes to the next iteration of the loop.
Explanation: Reference: http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/04_struc.htm
Q55. View the exhibit and examine the structure of the products table.
Examine the following code
Which statement is true when the procedure DELETE_DETAILS is invoked?
A. It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table
B. It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
C. It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.
D. It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.
Explanation: In this case, the debug output will only occur if there is an exception.
Q56. Identify two features of obfuscation. (Choose two.)
A. The Import and Export utilities accept wrapped files.
B. SQL' Plus cannot process the obfuscated source files.
C. Only the wrap utility can obfuscate multiple programs at a time.
D. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.
E. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View
Q57. View Exhibit1 and examine the structure of the DO table.
View Exhibit2 and examine the code.
The anonymous block gives an error on execution. What is the reason?
A. The assignment in line 7 is not valid.
B. The SQL does not support the Boolean data type.
C. A null value cannot be applied to the bind arguments In the using clause in line 10
D. The names of bind variables must be the same as the using clause bind arguments in line 10
Q58. 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 KB.
C. A trigger can contain a maximum of 32 lines of code.
D. Triggers fired by DML statements cannot cascade simultaneously.
E. Both DML and DDL statements can cascade any number of triggers,
F. Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers
Explanation: Reference: http://www.dba-oracle.com/m_trigger.htm
Q59. Which statement is true about transactions in PL/SQL?
A. A transaction can span multiple blocks.
B. A block can contain only a single transaction.
C. SERVERPOINTS cannot be created in a PL/SQL block.
D. The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block.
Q60. Which two statements correctly differentiate functions and procedures? (Choose two.)
A. A function can be called only as part of a SQL statement, whereas a procedure can be called only as a PL7SQL statement.
B. A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.
C. A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure can be called only as a PL/SQL statement.
D. A function may return one or more values to the calling environment, whereas a procedure must return a single value to its calling environment.