Database Management System Quiz

What is the purpose of the 3-Level Architecture in a Database Management System?

• Support data communication

• Provide data independence

• Enforce standards

• Improve data consistency

What is the main advantage of the Database Approach over File-Based Systems?

• Control of data redundancy

• Data independence

• Improved data sharing

• Enforcement of standards

What is the purpose of ER Modeling in a database system?

• To support data communication

• To improve data security

• To enforce standards

• To gain precise understanding of data use

What is the main function of Relational Algebra in a database system?

• Data manipulation

• Data retrieval

• Data modeling

• Data communication

What is the main goal of Conceptual Database Design?

• Build logical data model

• Build physical data model

• Validate data integrity

• Build conceptual data model

What is the purpose of a Foreign Key in a database system?

• Maintain data consistency

• Provide data independence

• Support data communication

• Enforce standards

What is the main property of a Relation in the Relational Data Model?

• Significant row sequence

• Duplicate tuples

• Distinct attributes

• Atomic cells

What is the main constraint of Entity Integrity in a database system?

• No null primary key attributes

• No duplicate tuples

• No multivalued attributes

• No null foreign key attributes

What is the main operation of Relational Algebra that combines related tuples from two or more relations?

• JOIN

• UNION

• PROJECT

• SELECT

What is the main component in an ER Diagram that represents a distinct subgrouping of occurrences of an entity type?

• Entities

• Attributes

• Subclasses

• Relationships