Database Management System Set 53
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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