Database Management System Set 53

Learning Mode Previous Next

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

Previous Next