Database Systems Quiz

What is a drawback of using file systems to store data?

• Data security and encryption

• Real-time data processing

• Data redundancy and inconsistency

• Efficient storage and retrieval

What is a drawback of using file systems to store data?

• Data security and encryption

• Real-time data processing

• Data redundancy and inconsistency

• Efficient storage and retrieval

What is the purpose of a Database Management System (DBMS)?

• To contain information about a particular enterprise

• To manage hardware components of a computer

• To develop mobile applications

• To design graphic user interfaces

What is the logical level in the Levels of Abstraction in database systems?

• Describes the security measures of the database

• Describes data stored in the database and the relationships among the data

• Describes the physical design of the database

• Describes how a record is stored

What is the purpose of the View level in database systems?

• To optimize query performance

• To manage user access control

• To hide details of data types and information for security purposes

• To physically store the database records

What is the purpose of the Data Manipulation Language (DML) in a database system?

• Language for creating backup copies of the database

• Language for accessing and manipulating the data organized by the appropriate data model

• Language for defining the database schema

• Language for managing database security

What is the main feature of the Relational Databases?

• Based on the object-oriented data model and represented by objects

• Based on the network data model and represented by a graph structure

• Based on the hierarchical data model and represented by a tree structure

• Based on the relational data model and represented by a collection of tables

What is the purpose of the Data Definition Language (DDL) in a database system?

• Language for managing user permissions

• Language for querying the database

• Language for accessing and manipulating the data

• Specification notation for defining the database schema

What is the purpose of the Entity-Relationship Model in database systems?

• Models an enterprise as a collection of entities and relationships

• Models an enterprise as a collection of objects

• Models an enterprise as a collection of files

• Models an enterprise as a collection of tables

What is the responsibility of the Storage Manager in a database system?

• Provides the interface between the low-level data stored in the database and the application programs

• Generates reports for database administrators

• Optimizes query performance

• Manages user access control