Quiz no 1

Which of the following is responsible for the workers behind the scene in a database design approach?

• DBMS software

• Database administrators

• System analysts

• All of the above

What is an advantage of using the database management system (DBMS. approach?

• Data redundancy

• Data isolation

• Data inconsistency

• Data duplication

Which of the following defines the structure, constraints, and relationships of a database?

• Data models

• Database instances

• Database schemas

• Data independence

Which of the following is not a database language?

• DDL

• DML

• DCL

• DBA

What is an instance in database design?

• A single record in a database

• A visual representation of database tables

• A collection of related database objects

• A query language used to access the database

Which level of the 3-schema architecture is closest to the physical storage of data?

• External schema

• Conceptual schema

• Internal schema

• Logical schema

Which of the following is an example of a high-level conceptual data model used in database design?

• Entity-Relationship (ER) model

• Relational model

• Hierarchical model

• Object-oriented model

In the ER model, what does an entity represent?

• A database table

• A database record

• A relationship between tables

• A real-world object or concept

What is an entity type in the ER model?

• An instance of an entity

• A collection of related entities

• A unique identifier for an entity

• A relationship between entities

In the ER model, what are attributes?

• Properties or characteristics of an entity

• Relationships between entities

• Constraints applied to entity sets

• Keys used to uniquely identify entities