First Quarterly Exam in Computer 10

What is the primary purpose of a database management system (DBMS)?

• To store files only

• To manage and organize data efficiently

• To create spreadsheets

• To send emails

Which of the following is a key benefit of using a database approach?

• Data redundancy

• Data isolation

• Data integrity

• Data deletion

What does data independence mean in database systems?

• Data cannot be modified

• Data can be accessed without knowledge of physical storage

• Data must be stored in multiple locations

• Data must be manually entered

Which feature helps maintain data accuracy in a database?

• Data redundancy

• Data inconsistency

• Data validation rules

• Data fragmentation

What is a primary advantage of centralized data management?

• Increased data redundancy

• Better data security and control

• Slower data access

• Higher storage costs

Which of the following is a characteristic of good database design?

• Maximum data redundancy

• Minimal data redundancy

• No data relationships

• Isolated data storage

What is the role of a database administrator?

• Only entering data

• Only creating reports

• Managing and maintaining the database system

• Writing programming code only

How does a database help in data sharing?

• By restricting access to all users

• By allowing multiple users to access data simultaneously

• By limiting data to one user at a time

• By preventing data updates

What is meant by data consistency in a database?

• All copies of data show the same information

• Data is always changing

• Data is always static

• Data is stored in multiple formats

Which database benefit addresses data security?

• Increased data exposure

• Centralized access control

• Unrestricted data access

• Multiple data copies