Want to know Ucertify 1Z0-144 Exam practice test features? Want to lear more about Oracle Oracle Database 11g: Program with PL/SQL certification experience? Study Printable Oracle 1Z0-144 answers to Updated 1Z0-144 questions at Ucertify. Gat a success with an absolute guarantee to pass Oracle 1Z0-144 (Oracle Database 11g: Program with PL/SQL) test on your first attempt.

2016 Dec 1z0-144 oracle database 11g program with pl/sql:

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

View Exhibit2 and examine the code created by the user SCOTT: 

SCOTT grants the necessary privileges to green to access the EMP table and execute the package. 

Examine the following sequence of activities: 

SCOTT starts a session and issues the SQL>EXEC CURS_PKG.OPEN command. 

SCOTT then issues the SQL>EXEC CURS_PKG.NEXT command. 

green starts a session while SCOTT’s session is running and issues THE SQL>EXEC 

CURS_PKG.NEXT command. 

SCOTT issues the SQI>>EXEC SCOTT.CURS_PKG.NEXT command. 

The EMP table contains sequential EMPNOS from 100 through 108. 

Which statement correctly describes the output? 

A. SCOTT’s session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT’s session shows an error. 

B. SCOTT’s session shows the EMPNO 100, GREEN'S session shows EMPNO 100, and SCOTT’s session shows the EMPNO 101. 

C. SCOTT’s session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT’s session shows the second EMPNO 101. 

D. SCOTT’s session shows the EMPNO 100, GREEN'S session shows EMPNO 101, and SCOTT’s session shows the second EMPNO 102. 

Answer:


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

SERVEROUTPUT is on for the session. 

Which statement is true about the execution of the code? 

A. The execution fails because of the misplaced else clause. 

B. The execution is successful even if there is no employee with EMPLOYEE_ID 115. 

C. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found. 

D. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found. 

Answer:


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


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


Q15. Which two statements are correct about PL/SQL package components? (Choose two) 

A. A package must have both specification and body. 

B. A package body can exist without the package specification. 

C. A package specification can exist without the package body. 

D. When a packaged public variable is called for the first time in a session, the entire package is loaded into memory. 

Answer: C,D 


Improved 1z0-144 pdf free download:

Q16. Examine the following code that you plan to execute: 

What correction should be performed in the above code? 

A. The PROC2 procedure code should be defined in the package body. 

B. The PROC3 procedure should be declared in the package specification. 

C. The PROC3 procedure header should be declared at the beginning of the package body. 

D. The variable x must be declared in the package body and removed from the specification, 

Answer: A,B 


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


Q18. View the Exhibit and examine the structure of the departments table in SCOTT’s schema. 

Examine the following block of code: 

CREATE OR REPLACE PROCEDURE add_dept( 

p_id NUMBER, p_name VARCHAR2) IS 

BEGIN 

INSERT INTO departments VALUES <p_id, p_name, NULL, NULL); 

END; 

The above procedure is created by user SCOTT. Another user JONES needs to use the 

procedure. 

Which two statements are true in the above scenario? (Choose two.) 

A. JONES executes the procedure with definer's rights. 

B. JONES executes the procedure with invoker's rights. 

C. SCOTT should grant only the execute privilege for the procedure to JONES. 

D. SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to 

Answer: A,C 


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


Q20. View Exhibit1 and examine the structure of the employees table. 

View Exhibit2 and examine the code. 

What would be the outcome when the code is executed? 

A. It executes successfully. 

B. It gives an error because the SAL variable is not visible in the increase function. 

C. It gives an error because the increase function cannot be called from the RAISE_SALARY procedure. 

D. It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declarations. 

Answer: