Database Systems Quiz1

What is the purpose of a data model in database systems?

• A. To define the organization, constraints, and integrity of data

• B. To represent real-world entities and their relationships

• C. To manage database system organization

• D. To enable self-interpretation of data structure

Which type of data model focuses on entities, relationships, and semantics?

• A. Conceptual (High-Level)

• B. Physical (Low-Level)

• C. Implementation (Representational)

• D. Self-Describing

What is the purpose of a database schema?

• C. Defines the rules for valid states

• B. Represents the current snapshot of data

• A. Defines organization, constraints, integrity

• D. Represents the overall database structure for all users

What is the benefit of data independence in database systems?

• A. Flexibility

• C. Performance

• B. Maintainability

• D. Security

Which type of DBMS language is used to define the database structure?

• A. Data Definition Language (DDL)

• B. Data Manipulation Language (DML)

• C. High-Level (Non-Procedural) DML

• D. Low-Level (Procedural) DML

What is the purpose of stand-alone query language interfaces in DBMS?

• A. Direct interaction with DBMS through SQL queries

• B. Embedded DML within programming languages

• C. Menu-based for browsing

• D. Natural language (free text queries)

What is the main advantage of client-server DBMS architecture over centralized architecture?

• D. Limited Scalability

• C. Centralized Control

• B. Simple Management

• A. Better Scalability

What is the primary function of the application tier in a three-tier client-server architecture?

• C. Stores and manages the application's data

• D. Processes user requests and interacts with the database server

• A. User interface and web browser

• B. Middle layer housing web connectivity software

What is the main disadvantage of the hierarchical data model?

• D. Potential for data redundancy

• B. Limited data sharing capabilities

• A. Complex queries can be difficult

• C. Inflexible for non-hierarchical data

Which type of data model combines features of relational and object-oriented models?

• A. Network Model

• D. Object-Relational Model

• C. Relational Model

• B. Hierarchical Model