1Z0-144 | What Realistic 1Z0-144 practice test Is?


Q31. 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. 

Answer:

Q32. 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. It displays null if no employee with employee_id 123 exists. 

B. It produces the ora-01403: no data found error if no employee with employee_id 123 exists. 

C. It displays an error because the select into clause cannot be used to populate the PL/SQL record type. 

D. The code executes successfully even if no employee with employee_id 123 exists and displays Record Not Found. 

Answer:

Q33. Which two statements are true about the %ROWTYPE attribute? (Choose two.) 

A. It is used to declare a record that can hold multiple rows of a table. 

B. The attributes of fields in the record with the %ROWTYPE attribute can be modified manually. 

C. The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variable. 

D. It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altered. 

Answer: C,D 

Q34. Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor. 

A. when you want to lock the rows fetched by the cursor 

B. when you want to update or delete the result set without affecting the rows in the table C. when you want the database not to wait if the requested rows are locked by another user 

D. when you want to ensure that the current rows fetched by the cursor are updated or deleted 

Answer:

Q35. /temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this folder 

Examine the following commands that are executed by the DBA: 

SQL>CREATE DIRECTION my_dir AS ‘ /temp/my_files’: 

SQL>GRANT READ ON DIRECTORY my_dir To pubiic: 

View the Exhibit and examine the procedure created by user SCOTT to read the list of faculty names from the text file. 

SCOTT executes the procedure as follows: 

SQL>SET SERVEROUTPUT ON 

SQL>EXEC read_file (‘MY_DIR’, FACULTYLIST.TXT’) 

What is the outcome? 

A. It goes into an infinite loop. 

B. It executes successfully and displays only the list of faculty names. 

C. It does not execute and displays an error message because the end-of-file condition is not taken care of. 

D. It executes successfully and displays the list of faculty names followed by a "no data found” error message. 

Answer:

Q36. Examine the following package specification. 

SQL>CREATE OR REPLACE PACKAGE emp_pkf IS 

PROCEDURE search_emp (empdet NUMBER); 

PROCEDURE search_emp (empdet DATE); 

PROCEDURE search_emp (empdet NUMBER); RETURN VERCHAR2 

PROCEDURE search_emp (empdet NUMBER); RETURN DATE 

END emp_pkg 

The package is compiled successfully 

Why would it generate an error at run tune? 

A. Because function cannot be overload 

B. Because function cannot differ only in return type. 

C. Because all the functions and procedures In the package cannot have the same number of parameters with the same parameter name 

D. Because the search EMP (EMPDET NUMBER) procedure and the SEARCH_DEPT (EMPDET NUMBER) cannot have identical parameter names and data types 

Answer:

Q37. View the Exhibit and examine the structure of the AUDIR_CUST table. 

Exhibit Missing 

CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table. 

Examine the following trigger code: 

Which statement is true about the above trigger? 

A. It gives an error on compilation because it should be a statement-level trigger. 

B. It compiles and fires successfully when the credit limit is updated in the customer table. 

C. It gives an error on compilation because of the commit command in the trigger code 

D. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger. 

Answer:

Q38. 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 

Q39. Examine the following PL/SQL code: 

Which statement is true about the execution of the PL/SQL code? 

A. It executes successfully. 

B. It generates a run-time exception. 

C. It does not execute because of syntax error 

D. It executes successfully and generates a warning. 

Answer:

Explanation: Reference: http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/errors.htm 

Q40. 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: