CS403 Final Term Grand Quiz by MCS

CS403 GRAND QUIZ BY MCS OF VIRTUALLIANS

All are verified except 2 or 3.

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
3. Business
4. Relationship

Q9. In ____________ appropriate data model is chosen.

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

Q10. Which of the following is drawback of standardization?

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

Q11. Recursive relationship is also called _______.

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

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

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

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

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

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

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

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

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

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

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

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

Q19. Core of the Database Architecture is __________

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

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

1. Natural join
2. Semi join
3. Outer join
4. Theta join

Q21. Conceptual database design is implemented using a _______.

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

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

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

Q24. Each _______ of a table contains atomic/single value.

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

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