Database and Logic Gates REVIEW

What is a database?

• A collection of unrelated data

• A collection of data organized for easy storage, retrieval, and manipulation

• A collection of paper files only

• A type of chart

Which of the following is NOT a type of database?

• Relational database

• Single-table database

• Multi-dimensional database

• Paper-based database

In a single-table database, what are rows called?

• Fields

• Records

• Columns

• Attributes

What is an entity in a database?

• A person only

• Anything about which data is collected

• A database table

• A primary key

Which field would likely be the primary key in a 'Books' table?

• Title

• Author

• ISBN

• Publisher

What is a primary key?

• A field that contains duplicate data

• A field that uniquely identifies a record

• A field used to sort data

• A field that stores foreign data

What is a foreign key?

• A key that duplicates the primary key

• A key that establishes a relationship between two tables

• A key used only in single-table databases

• A key to encrypt data

What is a data dictionary?

• A list of records in a database

• A table defining each field, its data type, and other metadata

• A database for storing primary keys

• A software used to create queries

What is the purpose of a query in a database?

• To store records

• To retrieve and manipulate data

• To define primary keys

• To organize fields

What does SQL stand for?

• Simple Query Language

• Structured Query Language

• Standard Query Language

• Sequential Query Language