Database Environment Quiz

What is the purpose of the three-level database architecture?

• To allow users to access different data

• To ensure all users can access the same data

• To limit user access to the database

• To enhance physical data storage

What does logical data independence refer to?

• Immunity of external schemas to changes in conceptual schema

• Immunity of conceptual schemas to changes in physical schema

• Immunity of external schemas to changes in internal schema

• Immunity of internal schemas to changes in external schema

Which of the following is a characteristic of the external level in the ANSI-SPARC architecture?

• Describes how data is stored in the database

• Describes the community view of the database

• Describes the users' view of the database

• Describes the physical representation of the database

What is the main function of Data Definition Language (DDL)?

• To describe and name entities and relationships

• To manipulate data in the database

• To provide transaction support

• To ensure data integrity

Which of the following is NOT a category of data models?

• Physical

• Object-based

• Record-based

• Hierarchical

What is the purpose of conceptual modeling?

• To create a physical representation of data

• To develop a model of information use independent of implementation details

• To define data manipulation operations

• To describe the internal structure of the database

Which of the following is a function of a Database Management System (DBMS)?

• Network management

• User interface design

• Data storage, retrieval, and update

• Data encryption services

What does physical data independence refer to?

• Immunity of external schemas to changes in physical schema

• Immunity of internal schemas to changes in external schema

• Immunity of conceptual schema to changes in internal schema

• Immunity of external schemas to changes in conceptual schema

Which data model is considered a record-based data model?

• Object-Oriented Model

• Relational Data Model

• Entity-Relationship Model

• Semantic Model

What is the role of a Database Administrator (DBA) in the three-level architecture?

• To create user views

• To enforce data integrity rules

• To change database storage structures without affecting users' views

• To manage data manipulation languages