CS403 Midterm MCQs by VU Topper RM

Which is not the function of Database Management System?

➢failure response services

The conceptual database design can be transformed into any .

Which is the second stage in the database development process?

➢Requirement analysis

Functional dependencies under interference rule reflexivity are called

➢Trival

If many instances of the “Book” entity are associated with the many instances of the “Student” entity, then the relationship between them is:

➢Mant to many

Which of the following constraints enforces entity integrity?

➢Primary key

Unary operations involves

➢Only one relation

entity has a primary key that is partially or totally derived from the parent entity in the relationship. ➢weak

In appropriate data model is chosen.

➢Logical database design

Which of the following is drawback of standardization?

➢Lack of uniqueness

Recursive relationship is also called .

➢Unary

Binary relation

➢Home relation

DFD does not provide us a way to represent

➢Decision

is used to maintain a connection between the users of the database system.

➢File server

Which of the following is an advantage of using the Traditional File Organization?

➢Simplicity

Which of the following is the input to Analysis Phase?

➢DFD

Name and are part of the definitions of an attribute.

➢Domain

Which of the following most certainly implies the need for an entire table to implement?

➢A ternary relationship

Core of the Database Architecture is

➢Interval level

is same as equi-join with a slight difference.