CS403 MCQs

CS403 GRAND QUIZ

1. Which is not the function of Database Management System? a.

A user accessible Catalog

b. Concurrency Control Services

c.

Failure Response Service

d. Support for Data Communication

2. The conceptual database design can be transformed into any ________. a.

b. Database design

c.

E-R model

d. Entity set

3. Which is the second stage in the database development process? a.

Database design

b. Preliminary Study

c.

Physical Design

d. Requirement Analysis

4. Functional dependencies under interference rule reflexivity are called ________ dependencies. a.

Augmentation

b. Transitivity

c.

Projectivity

d. Trivial

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

One to one

b. One to many

c.

Many to many

d. Many to one

6. Which of the following constraints enforces entity integrity? a.

b. FOREIGN KEY

c.

CHECK

d. NOT NULL

7.

Unary operations involves

a.

Only one relation

b. Only two relations

c.

More than two relations

d. Not more than five relations

8. A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship. a.

Strong

b. Weak

c.

Business

d. Relationship

9. In ____________ appropriate data model is chosen. a.

ERD

b. Conceptual Database Design

c.

Logical Database Design

d. DFA

10. Which of the following is drawback of standardization? a.

Difficult to understand

b. Uniformity

c.

Lack of uniqueness

d. Easy to develop applications

11. Recursive relationship is also called _______. a.

Unary

b. Ternary

c.

Primary

d. Secondary

12. The foreign key attribute, which is present as a primary key in another relation is called as _________ of the foreign key attribute. a.

Binary relation

b. Composite relation

c.

Home relation

d. Recursive relation

13. DFD does not provide us a way to represent ________ a.

Entities

b. Decisions

c.

Date stores

d. Processes

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

Virtual server

b. File server

c.

Client server

d. FTP server

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

a.

Time consuming

b. Data security

c.

Simplicity

d. Efficiency

16. Which of the following is the input to Analysis Phase? a.

DFD

b. Logical database design

c.

Physical database design

d. Data model

17. Name and _______ are part of the definitions of an attribute. a.

Domain

b. Symbol

c.

Property

d. Entity instance

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

a.

A ternary relationship

b. A recursive relationship

c.

An identify relationship · d. A binary relationship · 19. Core of the Database Architecture is __________

a.

b. External level

c.

Conceptual level

d. ANSI SPARK

20. _________ is same as equi-join with a slight difference. a.