DBMS

DBMS - Topic Wise Multiple Choice Questions (MCQ)

Database Management System MCQ for Specialist Officer exam freshers interview Practice Multiple Choice DBMS Interview Questions and answer for MNC IT Job SO Exam



6 )

The number of entities to which another entity can be associated via a relationship set is expressed as:

Entity
Schema
Cardinality
Attributes


View Solution



7 )

Relations produced from an E-R model will always be in:

First normal form
Second normal form
Third normal form
Fourth normal form


View Solution



8 )

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

Generalization
Specialization
Abstraction
none of these above


View Solution



9 )

The file organization that provides very fast access to any arbitrary record of a file is:

Ordered file
Unordered file
Hashed file
B-tree


View Solution



10 )

What is not true about a view?

It is a definition of a restricted portion of the database
It is a security mechanism
It is always updatable like any other table
All are true


View Solution