DBMS Quiz1

The Data Model that describes how the data is actually stored is:

• internal model

• external model

• logical model

• none of these

Data about data is normally termed as:

• Directory

• Data Bank

• Meta data

• none of these

One of the following is a valid Record based data model

• Object Oriented model

• Relational model

• ER Model

• None of these

Collection of information stored in a Database at a particular moment is:

• View

• Schema

• instance

• None of these

An Association between Student and a course is:

• 1:1 relationship

• 1:M relationship

• M:N relationship

• None of these

An entity set that does not have sufficient attributes to form a Primary key is a:

• Strong Entity set

• Weak entity set

• Simple entity set

• Primary entity set

The users who use the easy to use menu are called:

• Sophisticated end users

• Naive users

• Stand alone users

• Casual End users

Suppose relation R(A,B,C,D,E) has the following functional dependencies:

A -> B

B -> C

BC -> A

A -> D

E -> A

D -> E

• A

• E

• B,C

• D

The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into:

employee1 (ID, name)

employee2 (name, street, city, salary)

• Lossless decomposition

• Lossless-join decomposition

• All of the mentioned

• None of the mentioned

Which of the following is not Armstrong’s Axiom?

• Reflexivity rule

• Transitivity rule

• Pseudotransitivity rule

• Augmentation rule