Database Systems Quiz

What is the definition of data?

• Interpreted facts

• Structured facts

• Raw facts

• Processed facts

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

• Generates ad hoc queries

• Creates data security policies

• Acts as an intermediary between the user and the database

• Directly manages end-user data

What is one advantage of using a DBMS?

• Increased data inconsistency

• Limited data sharing

• Improved data access

• Complex system administration

What is the purpose of a single-user database?

• Supports a specific department within an organization

• Used by the entire organization

• Runs on a personal computer

• Supports multiple users at the same time

What is the importance of database design?

• Ensures quick data redundancy

• Facilitates uncontrolled data sharing

• Focuses on the design of the database structure

• Increases data inconsistency

What is a major issue with the file system method of data processing?

• Quick data retrieval

• Nonprocedural data manipulation language

• Lack of security and limited data sharing

• Simple system administration

What is the transformation process when constructing a physical database?

• Transforming domains into data types and constraints

• Transforming attributes into tables

• Transforming relationships into primary and foreign keys

• Transforming entities into files

What is the difference between structural dependence and structural independence?

• Structural independence does not affect data access

• Structural dependence requires changes in the database schema

• Structural independence affects data access

• Structural dependence affects data access

What is data redundancy?

• Data inconsistency

• Data access unaffected by changes

• Data manipulation language

• Data stored unnecessarily at different places

What is a data anomaly?

• A data abnormality in which inconsistent changes have been made to a database

• A data condition in which data representation is dependent on physical data storage

• A data abnormality in which consistent changes are made to a database

• A data condition in which data access is affected by changes in physical data storage