Database Fundamentals Quiz

What is the primary purpose of a database?

• To store raw facts without structure

• To enable efficient data management and support decision-making

• To replace file systems entirely

• To generate metadata automatically

Metadata is best defined as:

• Raw facts collected from end-users

• The result of processing data to reveal meaning

• Data that describes data characteristics and relationships

• Information derived from knowledge

Which component acts as an intermediary between users and the database?

• Data warehouse

• Operating system

• Database Management System (DBMS)

• Application software

What is a key advantage of using a DBMS?

• Increased data inconsistency

• Minimized data security

• Improved data sharing and integration

• Reduced end-user productivity

An enterprise database supports:

• A single user at a time

• A small group of users

• A large number of users concurrently

• Only decentralized data storage

In the database system environment, "procedures" refer to:

• Physical devices like servers

• Rules governing database design and usage

• Application programs

• Raw facts stored in tables

Which DBMS function enforces user security and data privacy?

• Data storage management

• Data dictionary management

• Security management

• Backup and recovery

The data dictionary stores:

• End-user data

• Index definitions

• Metadata (e.g., data characteristics)

• Hardware configurations

A Database Administrator (DBA) is responsible for:

• Writing application code

• Designing user interfaces

• Database implementation, maintenance, and security

• Only data entry tasks

Distributed databases:

• Store all data at a single site

• Distribute data across multiple sites

• Support only day-to-day operations

• Exclude transactional data