1Z0-144 Exam Questions

View the Exhibit and examine the structure of the EMP table. Which stages are performed when the above block is executed? (Choose all that apply)

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

Which two statements are true about the instead of triggers? (Choose two.)

What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?

You need to remove the database trigger BUSINESS_HOUR. Which command do you use to remove the trigger in the SQL*Plus environment?

Which three are valid ways to minimize dependency failure? (Choose three.)

Which statement about multiple column subqueries is true?

You are updating the employee table. Jane has been granted the same privileges as you on the employee table. You ask Jane to log on to the database to check your work before you is...

For which three tasks would you use the WHERE clause? (Choose three.)

When using a packaged function in a query, what is true?

You want to create a PL/SQL block of code that calculates discounts on customer orders. This code will be invoked from several places, but only within the program unit ORDERTOTAL ....

Which statements are true? (Choose all that apply.)

What is a conditional predicate in a DML trigger?

Examine the trigger heading: CREATE OR REPLACE TRIGGER salary_check BEFORE UPDATE OF sal, job ON emp FOR EACH ROW Under which condition does this trigger fire?

Which four triggering events can cause a trigger to fire? (Choose four.)

A dependent procedure or a function directly or indirectly references one or more of which four objects? (Choose four.)

Which command must you issue to allow users to access the UPD_TEAM_STAT trigger on the TEAM table?

Which three are true regarding error propagation? (Choose three.)

You need to implement a virtual private database (vpd). In order to have the vpd functionality, a trigger is required to fire when every user initiates a session in the database. W...

The add_player procedure inserts rows into the PLAYER table. Which command will show this direct dependency?

Which statement is true about removing packages?

Which two does the INSTEAD OF clause in a trigger identify? (Choose two.)

Within a PL/SQL loop, you need to test if the current fetch was successful. Which SQL cursor attribute would you use to accomplish this task?

Which two conditions in a PL/SQL block cause an exception to occur? (Choose two.)