1Z0-144 | The Up to date Guide To 1Z0-144 exam question


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

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

Q43. Which two statements are true about PL/SQL exception propagation? (Choose two.) 

A. The exception reproduces Itself In successive enclosing blocks until a handler is found. 

B. Exception- can propagate across the remote subprograms that are called through database links. 

C. If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception. 

D. If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception. 

Answer: A,C 

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

Answer: B,C 

Q45. The STRING_TAB table has the following structure: 

View the Exhibit and examine the code. 

What is the outcome on execution? 

A. It displays 

Output buffer not long enough. 

This is my test string.-. 

B. It displays only 

Output buffer not long enough, and exits the anonymous block. 

C. It displays only 

This is my test string. - Because EXCEPTION should have been defined in the anonymous 

block to get the error message. 

D. It does not display any of the MEMS_PUTPUT messages and gives an error because a 

transaction control statement cannot be used in the exception section of a procedure. 

Answer:

Q46. View the Exhibit to examine the PL/SQL block. 

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

A. It executes successfully and gives the desired output. 

B. It does not execute because the definition of type population is indexed by VARCHAR2. 

C. It executes, and the string keys of an associative array are not stored in creation order, but in sorted order. 

D. It does not execute because the value that is once assigned to the element of the associative array cannot be changed. 

Answer:

Q47. View the Exhibit and examine the code: 

Which statement is true about the COMPILE_CODE procedure? 

A. It gives an error in line 6. 

B. It gives an error in line 8. 

C. It gives an error in line 5. 

D. It executes successfully, but displays a warning about the unreachable code when used for the PROC1 procedure. 

E. It executes successfully, but a warning about the unreachable code is not displayed when used for the PROC1 procedure. 

Answer:

Q48. View the Exhibit to examine the PIVSQL block. 

Which statement is true about the output of the PL/SQL block? 

A. It executes and the Output is emprec.deptname: . 

B. It executes and the Output is emprec.deptname: Sales. 

C. It produces an error because NULL is assigned to the emprec.empid field in the record. 

D. It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record. 

Answer:

Q49. Which statements are true about PL/SQL procedures? (Choose all that apply.) 

A. Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself. 

B. Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time. 

C. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance. 

D. A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java. 

Answer: B,D 

Q50. Examine the following PL/SQL code: 

Which statement is true about the fetch statements in the PL/SQL code? 

A. Each fetch retrieves the first row and assigns values to the target variables. 

B. Each fetch retrieves the next consecutive row and assigns values to the target variables. 

C. They produce an error because you must close and reopen the cursor before each fetch -statement. 

D. Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an error. 

Answer: