Exam information

Exam 1Z0-144: Oracle Database 11g, Program with PL/SQL Exam Preparation Material

Other exams

Which statement is true about the execution of the code?

Examine the following PL/SQL code:(Exhibit)The server output is on for the session. Which statement is true about the execution of the code?

What is the outcome?

Examine the following code:(Exhibit)What is the outcome?


Which two statements are correct about the code above?

Examine the following block of code: Which two statements are correct about the code above? (Choose two.)

What must you do to ensure that the code executes successfully?

Examine the following code:(Exhibit)The above code generates an error on execution.What must you do to ensure that the code executes successfully?

What is the outcome?

View the Exhibit and examine the structure of the SALGRADE table.Examine the following code:What is the outcome?

Which line(s) in the above code are NOT valid?

Examine the following partial declare section from a block of PL/SQL code(Exhibit)Which line(s) in the above code are NOT valid? (Choose all that apply.)

Which statement is true about the execution of the code?

View the Exhibit to examine the PL/SQL code.Which statement is true about the execution of the code?

What is the outcome on compilation?

View Exhibit 1 and examine the structure of the EMP and dept tables.View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.What is the outcome on compilation?

What is the outcome when the code is executed?

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?

What is the outcome?

View Exhibit 1 and examine the structure of the EMP table.View Exhlbit2 and examine the code of the packages that you have created.You issue the following command:SQL> DROP PACKAGE manage_emp;What is the outcome?

Page 1 of 812345...Last »