Database Concepts Quiz

A database is:

• A large collection of operational data, stored according to rules.

• A large collection of operational data.

• A set of operational data files.

• A data warehouse for operational data.

Types of data include:

• A set of data files.

• Sound, speech, writing, text, graphics, still images, moving images, etc.

• Sound, speech, writing, text, graphics, still or moving images...in binary form.

• Sound, speech, writing, text, graphics, still or moving images...stored in memory or files.

A database is a common information resource, meaning:

• Online access.

• Multiple users, independent of geographic location, with access control.

• Multiple users.

• Multiple users, with access control.

A Database Management System (DBMS) is:

• An operating system.

• System software.

• Software that controls database access strategies.

• Application software.

The important functions of database services are:

• Updating, modifying, and adding data.

• Restoring information.

• Searching and querying information.

• Processing, searching, querying, modifying, adding, or removing data...

The advantages of a database are:

• The appearance of data anomalies.

• Attributes are described in multiple data files.

• The potential for data conflicts and inconsistencies.

• Reducing redundancy, ensuring consistency and data integrity.

Data anomalies can:

• Lead to missing or excessive information in storage.

• Ensure data consistency and integrity.

• Reflect the actual data reality accurately.

• Avoid data conflicts.

Inconsistent data in storage means:

• There is no data conflict.

• It causes the data to lose its integrity.

• It is impossible to modify, add, or update data.

• It allows the implementation of search queries.

Data integrity ensures:

• That data is always stored correctly.

• That data accurately reflects the real-world data.

• Reduces redundancy, ensures consistency, and guarantees data integrity.

• Facilitates the updating, modifying, and adding of data.

Data security can be understood as:

• Preventing unauthorized or improper access from within or outside.

• Data consistency and integrity.

• Ease of data maintenance.

• Standardizing procedures, protocols, and protective measures for data security.