CS403 Midterm and Final Term Combined

Q1. Which is not the function of Database Management System?

1. A user accessible Catalog
2. Concurrency Control Services
3. Failure Response Service
4. Support for Data Communication

Q2. The conceptual database design can be transformed into any

1. Data model
2. Database design
3. E-R model
4. Entity set

Q3. Which is the second stage in the database development process?

1. Database design
2. Preliminary Study
3. Physical Design
4. Requirement Analysis

Q4. Functional dependencies under interference rule reflexivity are called ________ dependencies.

1. Augmentation
2. Transitivity
3. Projectivity
4. Trivial

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

1. One to one
2. One to many
3. Many to many
4. Many to one

Q6. Which of the following constraints enforces entity integrity?

1. PRIMARY KEY
2. FOREIGN KEY
3. CHECK
4. NOT NULL

Q7. Unary operations involves

1. Only one relation
2. Only two relations
3. More than two relations
4. Not more than five relations

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

1. Strong
2. Weak

c.

Business

d. Relationship

Q9. In ____________ appropriate data model is chosen.

1. ERD
2. Conceptual Database Design
3. Logical Database Design
4. DFA

10.

Which of the following is drawback of standardization?

1. Difficult to understand
2. Uniformity
3. Lack of uniqueness
4. 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

15.

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

1. Time consuming
2. Data security
3. Simplicity
4. Efficiency

16.

Which of the following is the input to Analysis Phase?

1. DFD
2. Logical database design
3. Physical database design
4. Data model

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

a. Domain · b. Symbol · c. Property · d. Entity instance

18.

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

1. A ternary relationship
2. A recursive relationship
3. An identify relationship
4. A binary relationship

19.