Database Concepts Quiz

Which of the following is a disadvantage of file processing systems?

• Minimal data redundancy

• Easy data sharing

• Program-data dependence

• High data integrity

A DBMS is primarily used to:

• Program operating systems

• Manage data files only

• Store multimedia content

• Define, create, maintain, and control access to databases

The primary goal of database systems is to:

• Increase programming effort

• Reduce data consistency

• Minimize data redundancy

• Support manual data entry

Which is NOT a component of the database environment?

• Database

• Users

• Application programs

• Operating system

A logical description of the entire database is known as the:

• Physical schema

• Conceptual schema

• External schema

• Object schema

What is the role of a data administrator?

• Backup and recovery

• Application programming

• Defining data access policies

• Writing operating systems

Which type of user interacts with the system by querying the database?

• Database administrator

• Casual user

• System analyst

• Application developer

The three-schema architecture includes all EXCEPT:

• Internal level

• Conceptual level

• External level

• Virtual level

Which is an advantage of using a DBMS?

• Increased redundancy

• Complex backups

• Better data sharing

• No access control

Data independence refers to:

• Separate data files for each user

• Ability to modify schema without affecting applications

• Automatic encryption

• Decentralized databases