PL/SQL Triggers MCQs

by karimhani25
114
17

pl/sql

questions

Title
Whenever a specified event occurs, the ____ is automatically triggered by the Oracle engine Whenever a specified event occurs, the ____ is automatically triggered by the Oracle engine. Cursor Trigger Exception View discuss The answer is: B. Trigger
Which of the following is TRUE about PL/SQL Trigger? Which of the following is TRUE about PL/SQL Trigger? When certain conditions are met, a trigger stored in a database is triggered. A trigger is an application that executes or fires automatically when a certain event occurs. Both A. and B. None of the above discuss The answer is: D. None of the above
In which event(s) trigger is executed? In which event(s) trigger is executed? DDL DML Database Operation All of the above discuss The answer is: D. All of the above
Which of the following is database operation? Which of the following is database operation? SERVERERROR STARTUP SHUTDOWN All of the above discuss The answer is: D. All of the above
Which of the following is not an advantage of trigger? Which of the following is not an advantage of trigger? Various column values are automatically generated by triggers Maintains the integrity of referential Tables are replicated asynchronously Validating transactions and preventing them from being invalid discuss The answer is: C. Tables are replicated asynchronously
What does INSERT or UPDATE or DELETE clauses do in Trigger syntax? What does INSERT or UPDATE or DELETE clauses do in Trigger syntax? DML Operation is performed DDL Operation is performed DCL Operation is performed TCL Operation is performed discuss The answer is: A. DML Operation is performed
Which clause(s) is/are used to specify when the trigger will get executed? Which clause(s) is/are used to specify when the trigger will get executed? BEFORE AFTER INSTEAD OF All of the above discuss The answer is: D. All of the above
Which clause is used to create trigger on a view? Which clause is used to create trigger on a view? BEFORE AFTER INSTEAD OF None of the above discuss The answer is: C. INSTEAD OF
What is the difference between OF column_name and ON table_name in trigger syntax? What is the difference between OF column_name and ON table_name in trigger syntax? OF column_name specifies the column name that is needed to be updated whereas ON table_name specified the table name that is associated with the trigger. ON table_name specifies the column name that is needed to be updated whereas OF column_name specified the table name that is associated with the trigger. OF table_name specifies the column name that is needed to be updated whereas ON column_name specified the table name that is associated with the trigger. ON column_name specifies the column name that is needed to be updated whereas OF table_name specified the table name that is associated with the trigger. discuss The answer is: A. OF column_name specifies the column name that is needed to be updated whereas ON table_name specified the table name that is associated with the trigger.
What does FOR EACH ROW clause do in Trigger syntax? What does FOR EACH ROW clause do in Trigger syntax? A row-level trigger is specified, meaning that each row is affected by this trigger When the SQL statement is run, the trigger will be executed just once, which is what is called a table-level trigger Both A. and B. None of the above discuss The answer is: C. Both A. and B.
WHEN condition is valid for which triggers? WHEN condition is valid for which triggers? Table Level Triggers Row Level Triggers Column Level Triggers Database Level Triggers discuss The answer is: B. Row Level Triggers
Which of the following statement is TRUE? Which of the following statement is TRUE? Table-level triggers do not have access to OLD and NEW references. Record-level triggers use OLD and NEW references. Record-level triggers do not have access to OLD and NEW references. Table-level triggers use OLD and NEW references. Table-level triggers have access to OLD and NEW references. Record-level triggers do not use OLD and NEW references. discuss The answer is: A. Table-level triggers do not have access to OLD and NEW references. Record-level triggers use OLD and NEW references.
Which keyword is used to query the table in the same trigger? Which keyword is used to query the table in the same trigger? BEFORE AFTER SAME EXACT discuss The answer is: B. AFTER
What does REFERENCING OLD AS o NEW AS n clause do in trigger? What does REFERENCING OLD AS o NEW AS n clause do in trigger? This clause is used to refer the old values for different DML statements. This clause is used to refer the new values for different DML statements. Both A. and B. None of the above discuss The answer is: C. Both A. and B.
Which of the following is an advantage of trigger? Which of the following is an advantage of trigger? Imposing authorizations for security Keeping track of table access events and logging them Auditing All of the above discuss The answer is: D. All of the above
Which of the following clause is not present in the syntax of trigger? Which of the following clause is not present in the syntax of trigger? DECLARE TRIGGER CURSOR INSTEAD OF discuss The answer is: C. CURSOR
Tables, views, schemas, or databases can be defined as ________ for events Tables, views, schemas, or databases can be defined as ________ for events. Procedure Views Triggers Cursors discuss The answer is: C. Triggers

total MCQs: 17

MCQs

17

Views

114

Best Answers

299

Points

5