CS403 Final Term Grand Quiz

1. CS403 Database Management System

Q3. 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. The conceptual database design can be transformed into any

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

Correct answer: Data model

Q5. 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

6. Functional dependencies under interference rule reflexivity are called dependencies.

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

Correct answer: Trivial

Q7. 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

Correct answer: Many to many

Q8. Which of the following constraints enforces entity integrity?

1. PRIMARY KEY
2. FOREIGN KEY

Correct answer: PRIMARY KEY

c. CHECK d. NOT NULL 9. Unary operations involves

a. Only one relation

b. Only two relations c. More than two relations d. Not more than five relations

10. 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

11. In appropriate data model is chosen. a. ERD b. Conceptual Database Design

c. Logical Database Design

d. DFA

Q12. 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

Q13. Recursive relationship is also called

1. Unary
2. Ternary
3. Primary
4. Secondary

Correct answer: Unary

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

1. Binary relation
2. Composite relation
3. Home relation
4. Recursive relation

Correct answer: Home relation

Q15. DFD does not provide us a way to represent

1. Entities
2. Decisions
3. Date stores
4. Processes

Correct answer: Decisions

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

1. Virtual server
2. File server
3. Client server
4. FTP server

Correct answer: File server

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

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

Correct answer: Simplicity

Q18. Which of the following is the input to Analysis Phase?

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

Correct answer: DFD

19. Name and are part of the definitions of an attribute.

1. Domain
2. Symbol
3. Property
4. Entity instance

Correct answer: Domain

Q20. 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

Correct answer: A ternary relationship

Q21. Core of the Database Architecture is

1. Internal level
2. External level
3. Conceptual level
4. ANSI SPARK

Correct answer: Internal level

22. is same as equi-join with a slight difference.

a. Natural join

b. Semi join c. Outer join d. Theta join

Q23. Conceptual database design is implemented using a

1. Hierarchical data model
2. Semantic data model
3. Relational data model
4. Network data model

Correct answer: Semantic data model

Q24. Which constraint is generally used for efficiency purposes in the data entry process?

1. Null value
2. Integer value
3. Default value
4. String value

Correct answer: Default value

Q25. A 3 NF relation is converted to BCNF by

1. Removing composite keys
2. Removing multivalued dependencies
3. Dependent attributes of overlapping composite keys are put in a separate relation
4. Dependent non-key attributes are put in a separate table

Correct answer: Dependent attributes of overlapping composite keys are put in a separate relation

26. Each _ of a table contains atomic/single value.

1. Cell
2. Row
3. Column
4. Record

Correct answer: Cell

Q27. A relation is said to be in BCNF when

1. It has overlapping composite keys
2. It has no composite keys
3. It has no multivalued dependencies
4. It has no overlapping composite keys which have related attributes

Correct answer: It has no overlapping composite keys which have related attributes