Exam information

Exam 1z0-144: Oracle Database 11g: Program with PL/SQL (update May 10th, 2015)

Other exams

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

View the Exhibit to examine the PL/SQL code:SREVROUPUT is on for the session. Which statement Is true about the output of the PL/SQLblock?

What is the implication of the above command?

Examine the following command:SQL>ALTER SESSIONSET plsql_warnings *’enable: severe’,’enable: performance’,’ERROR: 05003′;What is the implication of the above command?

Which statement is true when the procedure DELETE_DETAILS is invoked?

View the exhibit and examine the structure of the products table.Examine the following codeWhich statement is true when the procedure DELETE_DETAILS is invoked?

Which two tasks should be created as functions instead of as procedures?

Which two tasks should be created as functions instead of as procedures? (Choose two.)

What would be the outcome when the code is executed?

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?

What is the correct definition of the persistent state of a packaged variable?

What is the correct definition of the persistent state of a packaged variable?

Which line in the above code would result in errors upon execution?

Examine the following block of code:Which line in the above code would result in errors upon execution?

What is the outcome when the above trigger is compiled?

View the Exhibit and examine the structure of the customer table.Examine the following trigger code:What is the outcome when the above trigger is compiled?

Which statements are true about PL/SQL procedures?

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

What is the outcome on execution?

The STRING_TAB table has the following structure:View the Exhibit and examine the code.What is the outcome on execution?

Page 1 of 1112345...10...Last »