Matching
Match the following SQL keywords with their meanings:
Premises:
FROM
ORDER BY
SELECT
SQL
WHERE
Responses:
instructs Access to return the specific fields from one or more tables
specifies the table or tables that will be searched
specifies the criteria that records must match to be included in the results
defines the purpose and the structure of an SQL statement
sorts the records by a certain field in either ascending or descending order
Correct Answer:
Premises:
Responses:
ORDER BY
sorts the records by a certain field in either ascending or descending order
FROM
specifies the table or tables that will be searched
SQL
defines the purpose and the structure of an SQL statement
SELECT
instructs Access to return the specific fields from one or more tables
WHERE
specifies the criteria that records must match to be included in the results
Premises:
ORDER BY
FROM
SQL
SELECT
WHERE
Responses:
sorts the records by a certain field in either ascending or descending order
specifies the table or tables that will be searched
defines the purpose and the structure of an SQL statement
instructs Access to return the specific fields from one or more tables
specifies the criteria that records must match to be included in the results
Related Questions
Q14: Which of the following inherits the logic
Q38: What character is used to select all
Q45: _ is the industry standard language for
Q46: What are the two methods of programming
Q49: One reason for using a SQL statement
Q52: A(n)_ is a macro that executes when
Q54: What do you use to create a
Q76: Access queries use an Oracle statement behind
Q83: The ORDER BY clause must be added
Q92: What is the difference between a stand-alone