Database DOL #2

True or False: A database can have many tables of information.

• True

• False

What does the * symbol represent in the SQL query SELECT * FROM table_name?

• The * symbol represents a single column in the table.

• The * symbol is used to specify a condition in the query.

• The * symbol indicates the primary key of the table.

• The * symbol represents all columns in the table.

Which of these are SQL operators? (Select all that apply)

• =

• >

• +

• <

• !=

Match the following terms with their definitions:

• QUERY

• A programming language used to manage and

  manipulate databases.

• SQL

• A SQL command used to retrieve specific data from a

  database

• WHERE

• A SQL clause used to filter data according to specific

  criteria.

• SELECT

• A request for data or information from a database.

Short Answer: Why do businesses choose databases over spreadsheets for managing

large amounts of data?