Database Management Essentials I

What is a database?

• A database is a type of software used for web browsing.
• A database is a physical storage device for files.
• A database is an organized collection of data stored electronically.
• A database is a programming language for creating applications.

What do we call the person who designs and takes care of a database?

• Software Engineer
• Database Administrator (DBA)
• Data Analyst
• Network Administrator

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

• To create web applications

• To store and retrieve data efficiently

• To design user interfaces

• To manage network connections

What is a “record” in a database?

• A record is a type of database software.
• A record is a single data type 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.

What is the function of a primary key in a database?

• To store large amounts of data

• To uniquely identify each record in a table

• To create relationships between different tables

• To encrypt sensitive information

What does SQL stand for?

• Sequential Query Language

• Standard Query Language

• Simple Query Language

• Structured Query Language

What is the role of a foreign key in a database?

• To optimize query performance

• To store images and multimedia files

• To link records between different tables

• To define the structure of a database

What is a “field” in a database?

• A field in a database is a specific attribute of a record that holds a single piece of data.
• A field is a collection of records in a database.
• A field is a type of database management system.
• A field is a command used to query a database.

What is a “table” in a database?

• A table is a structured collection of data in rows and columns.
• A table is a graphical representation of data without structure.
• A table is a single row of data in a database.
• A table is a type of software used for data analysis.

What is a “query” in a database?

• A query is a type of database.
• A query is a database management tool.
• A query is a request for data from a database.
• A query is a programming language for databases.