Understanding Database Management

What is a database?

• A database is a collection of random files without structure.

• A database is an organized collection of data that can be easily accessed, managed, and updated.

• A database is a physical storage device for files.

• A database is a type of software used for graphic design.

What does DBMS stand for?

• Data Backup Management System

• Digital Business Management Software

• Database Management System

• Database Backup Service

Name one type of database.

• Object-oriented Database

• Relational Database

• NoSQL Database

• Graph Database

What is the purpose of a primary key?

• To group related records together in a database table.

• To define the structure of a database table.

• The purpose of a primary key is to uniquely identify each record in a database table.

• To store large amounts of data in a single record.

What is SQL used for?

• SQL is used for managing and manipulating relational databases.

• SQL is used for creating mobile applications.

• SQL is used for designing user interfaces.

• SQL is used for managing file systems.

What does a table in a database represent?

• A method for querying data from a database.

• A collection of related data entries organized in rows and columns.

• A single data entry in a database.

• A graphical representation of data.

What is a record in a database?

• A record is a collection of related data items stored together in a database.

• A record is a command used to query a database.

• A record is a single data type in a database.

• A record is a type of database software.

What is the difference between a field and a record?

• A field contains multiple records; a record contains no fields.

• A field is an individual data element; a record is a collection of fields.

• A field is a type of database; a record is a type of table.

• A field is a collection of records; a record is an individual data element.

What is data normalization?

• Data normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

• Data normalization is the process of deleting all data from a database.

• Data normalization is the technique of backing up data to prevent loss.

• Data normalization refers to the method of encrypting data for security purposes.

Why is it important to back up a database?

• Backing up a database only protects against hardware failures.

• It is important to back up a database to prevent data loss and ensure data recovery.

• Database backups can slow down system performance significantly.

• Backing up a database is unnecessary if you have a strong password.