1Z0-144 Exam Questions
124 real 1Z0-144 exam questions with expert-verified answers and explanations. Page 3 of 3.
- Question #101
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)
- Question #102
View the Exhibit and examine the structure of the SALGRADE table. Examine the following code: What is the outcome?
- Question #103
Which two statements are true about the instead of triggers? (Choose two.)
- Question #104
What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?
- Question #105
You need to remove the database trigger BUSINESS_HOUR. Which command do you use to remove the trigger in the SQL*Plus environment?
- Question #106
Which three are valid ways to minimize dependency failure? (Choose three.)
- Question #107
Which statement about multiple column subqueries is true?
- Question #108
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...
- Question #109
For which three tasks would you use the WHERE clause? (Choose three.)
- Question #110
When using a packaged function in a query, what is true?
- Question #111
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 ....
- Question #112
Which statements are true? (Choose all that apply.)
- Question #113
What is a conditional predicate in a DML trigger?
- Question #114
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?
- Question #115
Which four triggering events can cause a trigger to fire? (Choose four.)
- Question #116
A dependent procedure or a function directly or indirectly references one or more of which four objects? (Choose four.)
- Question #117
Which command must you issue to allow users to access the UPD_TEAM_STAT trigger on the TEAM table?
- Question #118
Which three are true regarding error propagation? (Choose three.)
- Question #119
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...
- Question #120
The add_player procedure inserts rows into the PLAYER table. Which command will show this direct dependency?
- Question #121
Which statement is true about removing packages?
- Question #122
Which two does the INSTEAD OF clause in a trigger identify? (Choose two.)
- Question #123
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?
- Question #124
Which two conditions in a PL/SQL block cause an exception to occur? (Choose two.)