Vendor: Oracle
Certifications: Oracle Database
Exam Name: Oracle Database 11g: Program with PL/SQL
Exam Code: 1Z0-144
Total Questions: 106 Q&As ( View Details)
Last Updated: Apr 11, 2024
Note: Product instant download. Please sign in and click My account to download your product.
VCE
Oracle 1Z0-144 Last Month Results
1Z0-144 Q&A's Detail
Exam Code: | 1Z0-144 |
Total Questions: | 106 |
Single & Multiple Choice | 106 |
CertBus Has the Latest 1Z0-144 Exam Dumps in Both PDF and VCE Format
1Z0-144 Online Practice Questions and Answers
Which two statements are true about the INSTEAD OF triggers? (Choose two.)
A. DELETE operations cannot be performed using the INSTEAD OF triggers.
B. The INSTEAD OF triggers must be created to add or modify data through any view.
C. The INSTEAD OF triggers can be written only for views, and the BEFORE and AFTER timing options are not valid.
D. The CHECK option for views is not enforced when insertions or updates to the view are performed by using the INSTEAD OF triggers.
User SCOTT has been granted CREATE ANY TRIGGER and ALTER ANY TABLE by the DBA. HR is an
existing schema in the database.
SCOTT creates the following trigger:
CREATE OR REPLACE TRIGGER drop_trigger
BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, `Cannot drop object');
END;
SCOTT does not grant the EXECUTE privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the HR schema?
A. Only HR
B. SCOTT and HR
C. Only SCOTT
D. SCOTT, HR, and SYS
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.
Examine the following snippet of PL/SQL code:
View the Exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.
Identify OPEN statements for opening the cursor that fetches the result set consisting of employees with JOB_ID as `ST_CLERK' and SALARY greater than 3000. (Choose three.)
A. OPEN c1 (NULL, 3000);
B. OPEN c1 (emp_job, 3000);
C. OPEN c1 (3000, emp_salary);
D. OPEN c1 (`ST_CLERK', 3000)
E. OPEN c1 (emp_job, emp_salary);
Which two statements are true about triggers? (Choose two.)
A. All the triggers that are created on a table cannot be disabled simultaneously.
B. Any user who has the alter privilege on a table can create a trigger using that table.
C. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database.
D. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation.
Add Comments
At first, I don’t think I can pass the 1Z0-144 exam. But when I used this dumps, I felt more confident to pass the exam. It is not out of my expectation, i passed the exam with the full score because I met many same question that i have done in this dumps. Thanks these dumps, it is useful.
A very good study material, i just used one month and i passed the exam yesterday. So you can trust on it.
the content update quickly, there are many new questions in this dumps. thanks very much.
i have passed today, All the questions are from their dumps, thanks for this dumps.
This dumps is valid, and this dumps is the only study material i used for this exam. Surprisingly i met the same question in the exam, so i passed the exam without doubt. Thanks for this dumps and i will recommend it to my friends.
i cannot image that i would pass the exam with so high score, thanks for this dumps. Recommend.
i'm so happy that i passed the exam with full score, thanks for this dumps, thanks all.
A valid dumps. It helped me pass the exam in short time. Thanks a million.
A very helpful study material, I have passed the exam with the help of this dumps. So i will introduce this dumps to other friend.
This dumps is valid. I just pass the exam with it. The answers are accurate.Recommend.