Your success in Oracle 1Z0-144 is our sole target and we develop all our 1Z0-144 braindumps in a way that facilitates the attainment of this target. Not only is our 1Z0-144 study material the best you can find, it is also the most detailed and the most updated. 1Z0-144 Practice Exams for Oracle Database 11g 1Z0-144 are written to the highest standards of technical accuracy.

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


Q32. View Exhibit1 and examine the structure of the EMP table. 

View Exhibit2 and examine the PIVSQL block of code. 

What is the outcome? 

A. It gives an error because the return type is not valid. 

B. It gives an error because the record type is not defined within the function 

C. It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid 

D. It executes successfully and displays the names and salaries of all employees who earn the highest salary. 

E. It executes successfully but does not display the names and salaries of all employees who earn the highest salary. 

Answer:


Q33. ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code: 

Which statement is correct about the above code? 

A. It gives an error in line 3 

B. It gives an error in line 4 

C. It gives an error in line 6 

D. It executes successfully and displays the output. 

Answer:


Q34. Which two statements are true about the PL/SQL initialization parameters? (Choose two.) 

A. To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l. 

B. The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance. 

C. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations. 

D. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled 

Answer: B,C 


Q35. View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green. 

Examine the following sequence of commands issued by SCOTT: 

What is the outcome? 

A. SCOTT’S session displays 5, and then 0, greets session displays 0. 

B. SCOTT’S session displays 5, and then 0; green's session displays 5. 

C. SCOTT’S session displays 5, and then 5 again, green's session displays 0. 

D. SCOTT’S session displays 5, and then 5 again; green's session displays 5. 

Answer:


Q36. View the Exhibit and examine the structure of the EMP table. 

Which stages are performed when the above block is executed? (Choose all that apply) 

A. Bind 

B. Parse 

C. Fetch 

D. Execute 

Answer: B,C,D 


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

You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number. 

Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.) 

A. The procedures can be either stand-alone or packaged. 

B. The procedures should be created only as packaged subprograms 

C. The procedures should be created only as stand-alone subprograms 

D. Each subprogram's formal parameters should differ in both name and data type. 

E. The formal parameters of each subprogram should differ in data type but can use the same names. 

Answer: B,E 


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


Q39. 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 run time 

E. When privileges need to be granted to a new user to access an existing schema at run time 

Answer: B,C 


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

Answer: