Master the 1Z0-144 Oracle Database 11g: Program with PL/SQL content and be ready for exam day success quickly with this Ucertify 1Z0-144 free practice exam. We guarantee it!We make it a reality and give you real 1Z0-144 questions in our Oracle 1Z0-144 braindumps.Latest 100% VALID Oracle 1Z0-144 Exam Questions Dumps at below page. You can use our Oracle 1Z0-144 braindumps and pass your exam.

Q41. View the Exhibit to examine the PL/SQL code. 

The record for the employee with employee__id 100 in the employees table is as follows; 

Identify the correct output for the code. 

A. King 17-JUN-87 1500 

B. King 17-JUN-87 24000 

C. King current sysdate 1500 

D. King current sysdate 24000 

Answer:


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

Answer:


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


Q44. You execute the following block of code: 

Which statement is true about the outcome? 

A. Both Output statements show different values. 

B. Both output statements show exactly the same values. 

C. It gives an error because the nested blocks are not labeled. 

D. It gives an error because the V_CUSTOMER variable have different types in the nested blocks 

Answer:


Q45. Examine the following PL/SQL code: 

Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows? 

A. The program abruptly terminates and an exception is raised. 

B. The program executes successfully and the output is No ROWS_FOUND. 

C. The program executes successfully and the query fetches a null value in the V_LNAME variable. 

D. Program executes successfully, fetches a NULL value in the V_LNAME variable and an 

exception is raised. 

Answer:


Q46. View the Exhibit and examine the structure of the employees table. 

Examine the following block of code: 

What is the outcome when the above code is executed? 

A. It executes successfully. 

B. It gives an error because decode cannot be used in a PL/SQL block. 

C. It gives an error because the AVG function cannot be used in a PL/SQL block 

D. It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block. 

E. It gives an error because both the AVG and decode functions cannot be used in a PL/SQL block. 

Answer:


Q47. Examine the following package specification: 

Which statement is true? 

A. g_comm has a value of 15 at 9: 06 AM only for Jones 

B. g_comm has a value of 10 at 9: 03 AM for both Jones and smith 

C. g_comm has a value of 15 at 9: 03 AM for both Jones and smith 

D. g_comm has a value of 20 at 9: 06 AM for both Jones and smith 

Answer:

Explanation: 

Package variable state is scoped at the session level. So the only user who can see G_COMM=15 will be Jones 


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


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


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

Answer: