Get real exam questions for 1Z0-144 Oracle Database 11g: Program with PL/SQL. 100% Free.
Q1. 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
Q1. 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 b
Q1. Which type of exceptions is qualified as no predefined Oracle server errors? A. the exceptions that are explicitly raised by the program and can be caught by the exception handler B. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler C. an exception that the developer determines as abnormal, are in the declarative section and raised ex
Q1. Examine the following DECLARE section of PL/SQL block: Which line in the above declaration would generate an error? A. Line 2 B. Line 3 C. Line 4 D. Line 5 E. Line 6 View AnswerAnswer: D Q2. Which two statements are true about the handling of internally defined or user-defined PL7SQL exceptions? (Choose two.) A. Add exception handlers whenever errors occur. B. An exception handler
Q1. You want to maintain an audit of the date and time when each user of the database logs off. Examine the following code: Which two clauses should be used to fill in the blanks and complete the above code? (Choose two.) A. ON SCHEMA B. ON QRXABASE C. AFTER LOGOFF D. BEFORE LOGOFF View AnswerAnswer: A,D Q2. Examine the following block of code: Which line in the above code would result
Q1. Identify two situations where the DBMS_SQL package should be used. (Choose two.) A. The SELECT list is not known until run time. B. The dynamic SQL statement retrieves rows into records. C. You do not know how many columns a select statement will return, or what their data types will. D. You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert o
Q1. 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
Q1. 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 b
Q1. Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.) A. When a query returns multiple rows B. When a column name in a where clause is unknown at compile time. C. When the number of columns selected in a query is not known until run time D. When a table needs to be created based on an existing table structure at
Q1. View Exhibit 1 and examine the structure of the EMP and dept tables. View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table. What is the outcome on compilation? A. It compiles and executes successfully. B. It gives an error on compilation because it is not a row-level t