Scribd
Upload
1K views

PL/SQL Practice Quizzes Final Exam

This document contains 10 practice quiz questions about Oracle database triggers and dependencies. The questions cover topics such as the syntax of system triggers, events that fire triggers, the order that different trigger types fire, how to recompile triggers, DDL and DML events that can fire triggers, and database object dependencies.

Uploaded by

meachamrob
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
1K views

PL/SQL Practice Quizzes Final Exam

This document contains 10 practice quiz questions about Oracle database triggers and dependencies. The questions cover topics such as the syntax of system triggers, events that fire triggers, the order that different trigger types fire, how to recompile triggers, DDL and DML events that can fire triggers, and database object dependencies.

Uploaded by

meachamrob
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Practice Quiz #7

Question 1 2.5 out of 2.5 points The syntax below represents that of a(n) ____ trigger. CREATE [OR REPLACE] TRIGGER trigger_name [BEFORE, AFTER] [List of DDL or Database System Events] [ON DATABASE | SCHEMA] Trigger body; Answer Selected Answer: c. system Question 2 2.5 out of 2.5 points

In the code fragment below, which of the followings represents the event that fires the trigger? CREATE OR REPLACE TRIGGER logon_trg AFTER logon ON SCHEMA BEGIN INSERT INTO bb_audit_logon VALUES (USER, SYSDATE); END; Answer Selected Answer: a. logon Question 3 2.5 out of 2.5 points

Which of the following statements is correct? Answer Selected Answer: b. A BEFORE statement level trigger will fire before a BEFORE row level trigger. Question 4 2.5 out of 2.5 points

The statement ____ recompiles the trigger named sales_trg. Answer Selected Answer: d. ALTER TRIGGER sales_trg COMPILE; Question 5 2.5 out of 2.5 points

DDL events include all of the following, except ____. Answer Selected Answer: d. DECLARE Question 6 2.5 out of 2.5 points

In the code fragment below, which of the following represents the qualifier? CURSOR basketitem_curIS SELECT idproduct, quantity, option1 FROM bb_basketitem WHERE idbasket = :NEW.idbasket; Answer Selected Answer: d. :NEW.idbasket Question 7 2.5 out of 2.5 points

A(n) ____ performs tasks automatically when a DML action occurs on the table with which it is associated. Answer Selected Answer: d. database trigger Question 8 2.5 out of 2.5 points

All of the following would cause a trigger to fire, except ____. Answer Selected Answer: a. BEFORE Question 9 2.5 out of 2.5 points

Which of the followings does NOT fire a trigger in a database? Answer Selected Answer: b. TRUNCATE Question 10 2.5 out of 2.5 points

A(n) ____________ fires whenever a DML, a DLL, or system event occurs on a schema or database. Answer Selected Answer: b. database trigger

Question 1

2.5 out of 2.5 points

Practice Quiz #8

Which of the following statements is true? Answer Selected Answer: b. If the definition of a referenced object is altered, dependent objects may or may not continue to work properly. Question 2 2.5 out of 2.5 points

The recompilation of dependent objects is successful if: Answer Selected Answer: d. all of the above. Question 3 2.5 out of 2.5 points

Which of the following statements is true? Answer Selected Answer: d. Modifications to a package body does not change the status of dependent objects. Question 4 2.5 out of 2.5 points

Which of the followings is used to recompile a PL/SQL function? Answer Selected Answer: b. ALTER FUNCTION

Question 5

2.5 out of 2.5 points

Which of the followings is NOT a way to minimize dependency failure? Answer Selected Answer: c. specifying schema names when referencing objects Question 6 2.5 out of 2.5 points

When a procedure is compiled, the Oracle server stores the ____ of any referenced objects. Answer Selected Answer: b. signature Question 7 2.5 out of 2.5 points

Which of the following is used by Oracle to determine invalidation of remote dependent objects at runtime? Answer Selected Answer: d. signature checking Question 8 2.5 out of 2.5 points

____ can be used to check the status of database objects. Answer Selected Answer: a. USER_OBJECTS Question 9 2.5 out of 2.5 points

The ____ view can be used to review the source code of a procedure, function, or package. Answer Selected Answer: a. USER_SOURCE Question 10 2.5 out of 2.5 points

If the definition of a synonym is changed, and the dependent PL/SQL program units are not invalidated if: Answer Selected Answer: a. the column order, column names, and column data types of the tables are identical

You might also like