On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 53

Q1 | Which of the following is the default trigger that is created using the CREATETRIGGER command?
  • Row level Trigger
  • Statement level Trigger
  • BEFORE Trigger
  • AFTER Trigger
Q2 | Which of the following command is used to delete a trigger?
  • DELETE TRIGGER
  • REPLACE TRIGGER
  • DROP TRIGGER
  • None of the above
Q3 | What is the name of a trigger that initiates another trigger?
  • Triggering Trigger
  • Automatic Initiation Trigger
  • Cascading Trigger
  • None of the above
Q4 | Which of the following specifies a boolean expression that must be true for the triggerto fire?
  • Trigger Action
  • Triggering Event
  • Trigger Restriction
  • None of the above
Q5 | Which of the following trigger will be executed before modifying each row affected bythe triggering statement?
  • Before Statement Trigger
  • After Row Trigger
  • Before Row Trigger
  • None of the above
Q6 | Which of the following is not true in case of triggers?
  • Triggers accept parameters.
  • Triggers are executed implicitly
  • Execution of triggers is transparent to the users.
  • A trigger can invoke another trigger.
Q7 | A database is divided into logical storage units called as
  • Tables
  • Records
  • Tablespaces
  • None of the above
Q8 | A file used to govern the initialization of the instance is known as
  • Shared file
  • Parameter file
  • Read-only file
  • None of the above
Q9 | SGA stands for
  • System Go Ahead
  • Software Global Area
  • System Global Area
  • None of the above
Q10 | Under which two circumstances do you design database triggers? (Choose two)
  • To duplicate the functionality of other triggers.
  • To replicate built-in constraints in the Oracle server such as primary key and foreign key.
  • To guarantee that when a specific operation is performed, related actions are perform
Q11 | This statement fails when executed: CREATE OR REPLACE TRI GGER CALC_TEAM_AVG AFTER I NSERT ON PLAYER BEGIN INSERT INTO PLAYER_BATSTAT ( PLAYER_I D, SEASON_YEAR, AT_BATS, HI TS) VALUES ( : NEW. I D, 1 997, 0, 0) ; END; To which type must you convert the trigger to correct the error?
  • Row
  • Statement
  • ORACLE FORM trigger
  • Before
Q12 | The OLD and NEW qualifiers can be used in which type of trigger?
  • Row level DML trigger
  • Row level system trigger
  • Statement level DML trigger
  • Row level application trigger
Q13 | Trigger are not supported in
  • Delete
  • Update
  • Views
  • All of the mentioned
Q14 | The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTERINSERT trigger.
  • for insert, on
  • On, for insert
  • For, insert
  • Both a and c
Q15 | What are the after triggers ?
  • Triggers generated after a particular operation
  • These triggers run after an insert, update or delete on a table
  • These triggers run after an insert, views, update or delete on a table
  • Both b and c
Q16 | The variables in the triggers are declared using
  • -
  • @
  • /
  • /@
Q17 | Which of the following is NOT an Oracle-supported trigger?
  • BEFORE
  • DURING
  • AFTER
  • INSTEAD OF
Q18 | Which of the following is true concerning triggers?
  • We do not create them with SQL.
  • They execute against only some applications that access a database.
  • They have an event, condition, and action.
  • They cannot cascade (cause another trigger to fire).
Q19 | Which prefixes are available to Oracle triggers?
  • : new only
  • : old only
  • Both :new and : old
  • Neither :new nor : old
Q20 | Which type of entity represents a logical generalization whose actual occurrence isrepresented by a second, associated entity?
  • Supertype entity
  • Subtype entity
  • Archetype entity
  • Instance entity
Q21 | Which of the following is the preferred way to recover a database after a transactionin progress terminates abnormally?
  • Rollback
  • Rollforward
  • Switch to duplicate database
  • Reprocess transactions
Q22 | Concurrency control is important for which of the following reasons?
  • To ensure data integrity when updates occur to the database in a multiuser environment
  • To ensure data integrity when updates occur to the database in a single-user environment
  • To ensure data integrity while reading data occurs to the database in a multiuser environment
  • To ensure data integrity while reading data occurs to the database in a singleuser environment
Q23 | The transaction log includes which of the following?
  • The before-image of a record
  • The after-image of a record
  • The before and after-image of a record
  • The essential data of the record
Q24 | Which of the following is not true of SQL views?
  • Oracle views cannot use the ORDER BY clause in view definitions.
  • Oracle views are created using the standard SQL-92 CREATE VIEW command.
  • Oracle views can by queri
Q25 | What is the type of Oracle backup in which all uncommitted changes have been removedfrom the datafiles?
  • Full backup
  • Consistent backup
  • Inconsistent backup
  • Differential backup