25 Multiple-Choice Questions: Unit 9 SQL Data Query

What is the standard query language used for writing scripts to obtain useful information from a database?

• Python

• Structured Query Language (SQL)

• HyperText Mark-up Language (HTML)

• Pseudocode

Which two commands are mandatory components in every SQL script?

• A. SELECT and WHERE

• B. SELECT and ORDER BY

• C. SELECT and FROM

• D. COUNT and SUM

What does the SELECT command specify in an SQL query?

• The condition that limits which records are included

• The table from which the data is retrieved

• The specified fields (columns) to be fetched from a table

• The total number of records that satisfy the query

What is the primary purpose of the FROM command in an SQL query?

• To define the format of the output data

• To identify the specific table to be used

• To specify ascending or descending order for sorting

• To include only records that match a specific condition

How must every SQL command begin and end, respectively?

• Begin with SELECT and end with END

• Begin with SELECT and end with a semicolon (;)

• Begin with FROM and end with a semicolon (;)

• Begin with QUERY and end with a comma (,)

Which command is used to include only records (rows) in a query that match a given condition?

• SELECT

• FROM

• WHERE

• SUM

If a user needs to display all fields (columns) from a specified table, which syntax is used with the SELECT command?

• SELECT ALL

• SELECT *

• SELECT FIELDS

• SELECT ALL COLUMNS

Which command is used to sort the results from a query by a given column?

• GROUP BY

• SUM

• SORT

• ORDER BY

When sorting results, what must be added to the ORDER BY clause to specify a sort in descending or reverse alphabetical order?

• ASC

• REV

• DESC

• REVERSE

Which command, used with SELECT, returns the quotient (whole number part) of a division operation on a field's values?

• COUNT

• MOD

• DIV

• This calculation function is not listed as a standard SQL query command in the list provided.