CS403 Quiz 2 by VU Topper RM

Q1. Vu-Topper RM (1 marks)

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 Page 134

D. Recursive relation

Q2. Vu-Topper RM (1 marks)

While mapping many-to-many relationship ______ table(s) are created A. One B. Two

C. Three Google

D. Five

Q3. Vu-Topper RM (1 marks)

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

Correct answer: Failure Response Service

Q4. Vu-Topper RM (1 marks)

The conceptual database design can be transformed into any_________.

A. Data model Page 125

B. Database design C. E-R model D. Entity set

Q5. Vu-Topper RM (1 marks)

Which is the second stage in the database development process?

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

Correct answer: Requirement Analysis

Q6. Vu-Topper RM (1 marks)

Functional dependencies under interference rule reflexivity are called ________ dependencies. A. Augmentation B. Transitivity C. Projectivity

D. Trivial

Q7. Vu-Topper RM (1 marks)

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

Q8. Vu-Topper RM (1 marks)

Which of the following constraints enforces entity integrity?

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

Correct answer: PRIMARY KEY

Q9. Vu-Topper RM (1 marks)

Unary operations involve

A. Only one relation

B. Only two relations C. More than two relations D. Not more than five relations

Q10. Vu-Topper RM (1 marks)

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

Q11. Vu-Topper RM (1 marks)

In______________ appropriate data model is chosen. A. ERD B. Conceptual Database Design

C. Logical Database Design Page 122

D. DFA

Q12. Vu-Topper RM (1 marks)

Which of the following is drawback of standardization?

1. Difficult to understand
2. Uniformity
3. Lack of uniqueness
4. Easy to develop applications

Correct answer: Lack of uniqueness