What is the term used to ask the database a question?

What is the term used to ask the database a question?

• A. Query
• B. Table
• C. Form
• D. Report

Answer: (A)

Asking a database for information is done with a query. A query is a request that tells the database what data you want, potentially filtering which rows to include, how to join data from multiple tables, and how to compute or organize the results. In practice, you write a query using a language like SQL, for example requesting specific columns from a table where certain conditions are met, and the database returns a set of matching rows. This concept sits apart from the other terms: a table stores the actual data, a form provides a user interface for entering or editing data, and a report formats data for viewing or printing. So the query is the action of asking the database a question, while the table, form, and report describe storage, data entry, and presentation, respectively.

Asking a database for information is done with a query. A query is a request that tells the database what data you want, potentially filtering which rows to include, how to join data from multiple tables, and how to compute or organize the results. In practice, you write a query using a language like SQL, for example requesting specific columns from a table where certain conditions are met, and the database returns a set of matching rows.

This concept sits apart from the other terms: a table stores the actual data, a form provides a user interface for entering or editing data, and a report formats data for viewing or printing. So the query is the action of asking the database a question, while the table, form, and report describe storage, data entry, and presentation, respectively.