SQL
When using mathematical functions in SQL, which of the following comes first in the order of operations? + - ( ) /
( )
What will be returned by the following query? SELECT MAX(season)FROM fcc_cc.passing (Note that you should not have to run this query to answer the question.) The query will run, but no records will be returned An error message 2018 2022
2022
6
6
Which of the following is NOT a relational operator used in SQL? > >= < ==
==
Which of the following statements is true about the WHERE and HAVING clauses? A SQL statement may have any number of WHERE clauses and any number of HAVING clauses A SQL statement may have a single WHERE clause and a single HAVING clause WHERE and HAVING are equivalent and interchangeable A SQL statement may have a WHERE clause or a HAVING clause, but not both
A SQL statement may have a single WHERE clause and a single HAVING clause
What does it mean if a primary key field within a record is null? There is no matching record in the foreign key table There is a syntax error in your query The column is ambiguously defined A primary key can never be null
A primary key can never be null
The _______ operator displays a record if all the conditions separated by ______ are TRUE. NOT, NOT OR, OR ALSO, ALSO AND, AND
AND, AND
What code should be added to the end of the SELECT statement to show "Total Inventory" as the column heading in the output of this query? SELECT SUM(unitsinstock)FROM northwinds.products 'Total Inventory' AS Total Inventory AS "Total Inventory" COLUMN Total Inventory
AS "Total Inventory"
Which SQL aggregate function returns the average of all non NULL values in a field? AVERAGE AVG COUNT SUM
AVG
A table in a FROM clause: Indicates a table that SELECTed fields can come from All of these answers May not be present between the JOIN and ON keywords Indicates a table that fields used in a WHERE clause can come from
All of these answers
The GROUP BY clause: indicates that we want our aggregate function to be calculated for each unique combination of values of the GROUP BY fields. should follow SELECT, FROM and WHERE (if present). All of these choices must contain any non-aggregate field(s) listed in the SELECT statement.
All of these choices
The ORDER BY clause: if present, should be the final clause in a SQL query. sorts in ascending order by default, but can be made to sort in descending order if desired. All of these choices can be used with numeric, character, and date data types
All of these choices
Which aggregate functions in SQL can be used with numeric fields? AVG All of these choices COUNT SUM
All of these choices
Which of the following functions can be used with text fields? SUM All of these choices COUNT AVG
COUNT
Which statement is true of the COUNT () aggregate function in SQL? COUNT can be used with text and numeric fields. COUNT will include null values. COUNT can be used only with numeric fields. COUNT will return the total sum of a numeric field.
COUNT can be used with text and numeric fields.
If a field is used in a WHERE clause, it must also be present in the SELECT field list. True False
False
The aggregate function included in the HAVING clause must also be in the SELECT clause. True False
False
You can have only one aggregate function in a SELECT. True False
False
Select the clause below that is missing from the following query: SELECT categoryname, categoryid, COUNT(productid) FROM northwinds.products JOIN northwinds.categories ON categories.categoryid = products.categoryid ... ORDER BY categoryid ASC GROUP BY categoryid GROUP BY categoryid, categoryname HAVING categoryid = 8 None of these
GROUP BY categoryid, categoryname
Which of the following clauses could be the missing clause from this query? SELECT COUNT(orderid), companyname FROM northwinds.orders JOIN northwinds.customers ON customers.customerid = orders.customerid GROUP BY companyname ...... WHERE companyname = 'Island Trading' HAVING shipperid = 3 HAVING SUM(freight) > 300 WHERE freight > 300
HAVING SUM(freight) > 300
Which of the following statements is true? If a column alias contains spaces, it must be in quotation marks. A column alias is always displayed in upper case. The only use of a column alias is to change the headings in the query output. A column alias must always be in quotation marks.
If a column alias contains spaces, it must be in quotation marks.
The ______ clause is used to combine rows from two or more tables, based on a related column between them. DISTINCT SELECT WHERE JOIN
JOIN
Reading Quiz 7: Computations with SQL
Reading Quiz 7: Computations with SQL
Reading Quiz 8: Grouping and Ordering
Reading Quiz 8: Grouping and Ordering
Reading Quiz 9: Column
Reading Quiz 9: Column
The DISTINCT keyword immediately follows which keyword? SELECT ORDER BY WHERE FROM
SELECT
Choose the correct order of SQL clauses below: SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY SELECT, FROM, JOIN, WHERE, HAVING, GROUP BY, ORDER BY SELECT, JOIN, FROM, WHERE, GROUP BY, HAVING, ORDER BY SELECT, FROM, JOIN, WHERE, ORDER BY, GROUP BY, HAVING
SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY
Which of the following are true regarding case-sensitivity (i.e., whether or not capitalization matters) in SQL? SQL keywords are not case-sensitive, but string comparisons are case-sensitive Neither SQL keywords nor string comparisons are case-sensitive. SQL keywords are case-sensitive, but string comparisons are not case-sensitive Both SQL keywords and string comparisons are case-sensitive
SQL keywords are not case-sensitive, but string comparisons are case-sensitive
Which of the following aggregate functions could you use to get a the total of all the values in a field? SUM AVG COUNT All of these choices
SUM
What will be returned by the following query? SELECT MIN(shippeddate) FROM northwinds.orders The earliest ship date for all orders null An error, because MIN() cannot be used on a date field The latest ship date for all orders
The earliest ship date for all orders
In a weighted average, the denominator is: The number of items averaged times the sum of the weights The scaling factor The number of items averaged The sum of the weights
The sum of the weights
What is the maximum number of JOIN clauses that can be present in a SQL query? 2 There is no practical limit 5 1
There is no practical limit
A column alias may be used in the ORDER BY clause. True False
True
An ORDER BY clause may include fields, aggregate functions, and mathematical expressions involving fields and aggregate functions. True False
True
In SQL, you can do mathematical operations in the SELECT, WHERE, HAVING, and ORDER BY clauses. True False
True
The following query is intended to calculate the number of null values in the field cmp_perc. What should the condition in the WHERE clause be? SELECT COUNT(*)FROM fcc_cc.passingWHERE ??? cmp_perc IS NULL COUNT(cmp_perc) = 0 cmp_perc = NULL() cmp_perc = NULL
cmp_perc IS NULL
The HAVING clause... cannot include any of the fields used in the ORDER BY clause. Two (but not all three) of these choices is constructed the same way as the JOIN clause except that it uses aggregate functions rather than fields. is constructed the same way as the WHERE clause except that it uses aggregate functions rather than fields.
is constructed the same way as the WHERE clause except that it uses aggregate functions rather than fields.
A scaling factor is used to adjust the ____________ of all values of a statistic. magnitude precision mantissa weighted average
magnitude
A quantifiable indicator used to measure the success of a business process is called a: business process milestone weighted average metric
metric
To explicitly specify the order in which comparisons should be performed, we would use ________________. single quotations ' ' parentheses ( ) asterisk * * square brackets [ ]
parentheses ( )
What is the appropriate JOIN condition in the following query? SELECT progressive, xgFROM fcc_cc.passingJOIN fcc_cc.standard_stats ON ??? passing.player_id = standard_stats.player_id passing.id = standard_stats.id passing.id = standard_stats.player_id passing.player_id = standard_stats.id
passing.id = standard_stats.id
Each record in the standard_stats table of the FCC_CC database contains standard statistics for a: player squad and season player and season player, season, and squad
player, season, and squad
The WHERE clause is used to limit the number of _______________ returned by a query. rows columns fields tables
rows
What would the following query display? SELECT COUNT(*)FROM northwinds.ordersWHERE shipcountry = 'USA' the total value of orders shipped to USA an error message nothing, you cannot use COUNT(*) the number of orders shipped to USA
the number of orders shipped to USA