DBMS

A SQL database view

• Is computed using a SQL query

• Contains data not stored in the database tables

• Takes up more disk space whenever more data is added to the database

• Is a way to improve the read time of a table in a database

• It is a trigger which is executed automatically upon deletion of an loan from loan relation.

• Trigger results in the deletion of the records from the borrower relation.

• It is a trigger which is executed automatically upon deletion of the customer (loan borrower) from borrower relation.

What is a view?

• A view is a special stored procedure executed when certain event occurs

• A view is a virtual table which results of executing a pre-compiled query

• A view is a database diagram

• Non of the mentioned

Which of the following is NOT an Oracle-supported trigger?

• BEFORE

• DURING

• AFTER

• INSTEAD OF

Which prefixes are available to Oracle triggers?

• : new only

• : old only

• Both :new and : old

• Neither :new nor : old

In ER model the details of the entities are hidden from the user. This process is called :

• generalization

• specialization

• abstraction

• None of these

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

• Single valued

• Multi valued

• Composite

• Derived

Which of the following can be a multivalued attribute?

• Phone_number

• Name

• Date_of_birth

• All of the mentioned

Which of the following is a single valued attribute?

• SUBJECT_TAKEN

• Register_number

• Address

• Reference

Pick entities from the following:

• vendor

• student

• attends

• km/hour