DB CH3
A WHERE and a HAVING clause cannot be included in the same query.
False
A valid name for a table might be tbl$Student.
False
Computed fields are existing fields in the database that you can perform computations with.
False
Fields will appear in alphabetical order in the query results of a SELECT clause.
False
In a SELECT statement, the WHERE clause is mandatory.
False
Instead of listing all the field names in the SELECT clause, you can use the @ symbol.
False
Microsoft Access uses the != version of the "not equal to" operator.
False
SQL uses an on-screen form to create tables, update tables, and retrieve data from tables.
False
The BETWEEN operator is exclusive; it includes all numbers between the lower and higher numbers, but excludes the lower and higher numbers themselves.
False
The two tables involved in a join operation must have the same structure.
False
There is no difference between the COUNT function and the SUM function.
False
When you connect simple conditions using the AND operator, only one of the simple conditions must be true for the compound condition to be true.
False
You can use the SQL CREATE TABLE command to insert rows into a table.
False
You use the WHERE clause on groups and the HAVING clause on rows.
False
A compound condition includes either or both of the AND and OR operators.
True
CHAR data types can be used to store numbers that will not be used in calculations.
True
Preceding a condition by the NOT operator reverses the result of the original condition.
True
When rows are grouped, one line of output is produced for each group.
True
You can combine values in character fields using the & operator.
True
You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.
True
When used after the word SELECT, which symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table? a. * b. & c. # d. $
a. *
Which function calculates the number of entries in a table? a. COUNT b. SUM c. MAX d. MIN
a. COUNT
What command do you use to add new data to a table? a. INSERT b. APPEND c. ADDTO d. SELECT
a. INSERT
Which operator do you use in the WHERE clause when you want to include a wildcard? a. LIKE b. AS c. BETWEEN d. UNION
a. LIKE
Based on the code shown, which query lists the number, name, and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000? Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum ) a. SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ; b. SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance > 2000 ; c. SELECT CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ; d. SELECT CustomerNum, CustomerName FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
a. SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
Which query will return the number of rows where the State field is 'AZ' from the table Customers? a. SELECT FROM Customers WHERE State='AZ' COUNT(*); b. SELECT COUNT(*) FROM Customers WHERE State='AZ'; c. SELECT FROM Customers COUNT(*) WHERE State='AZ'; d. SELECT COUNT(*) WHERE State='AZ' FROM Customers;
b. SELECT COUNT(*) FROM Customers WHERE State='AZ';
Based on the code shown, which query lists the number, name, credit limit, and balance for all customers with credit limits that exceed their balances? Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum ) a. SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ; b. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ; c. SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance ; d. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ;
b. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ;
Based on the code shown, which query lists the number, name, and complete address of every customer located on a street that contains the letters "Oxford"? Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum ) a. SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "?Oxford" ; b. SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "%Oxford%" ; c. SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "@Oxford@" ; d. SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "Oxford" ;
b. SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "%Oxford%" ;
When you use a name containing a space in Access SQL, what must you do to specify the table or column name? a. enclose it in quotation marks b. enclose it in square brackets c. enclose it in asterisks d. enclose it in question marks
b. enclose it in square brackets
In versions of SQL other than Access, which character is used as a wildcard to represent any collection of characters? a. asterisks (*) b. percent sign (%) c. underscore (_) d. hash tag (#)
b. percent sign (%)
What clause do you use in a query to save the results of the query as a table? a. UPDATE b. INSERT c. INTO d. DELETE
c. INTO
Based on the code shown, which query lists the number, name, street, and credit limit of all customers? The records are ordered by customer name within descending credit limit. Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum ) a. SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit DESC, CustomerName ; b. SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit ASC, CustomerName ; c. SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ; d. SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit ASC, CustomerName ;
c. SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ;
Based on the code shown, for each sales rep, which query lists the rep number, the number of customers assigned to the rep, and the average balance of the rep's customers? The records are grouped by rep number and ordered by rep number. Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum ) a. SELECT RepNum, AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ; b. SELECT RepNum, COUNT(*), AVG(Balance) FROM Part GROUP BY RepNum ORDER BY RepNum ; c. SELECT RepNum, COUNT(*), AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ; d. SELECT RepNum, COUNT(*) FROM Customer GROUP BY RepNum ORDER BY RepNum ;
c. SELECT RepNum, COUNT(*), AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ;
How many lines of output are produced when rows are grouped? a. one line for each group member b. two lines for each group c. one line for each group d. no output is produced
c. one line for each group
Which part of the SQL query specifies the table or tables that contain the data you wish to display in the query results? a. SELECT clause b. WHERE clause c. WITHIN clause d. FROM clause
d. FROM clause
Which query will return the number of rows where the State field is 'AZ' from the table Customers and provide a total of the Payment field? a. SELECT COUNT(*) WHERE State='AZ' SUM(Payment) FROM Customers; b. SELECT FROM Customers COUNT(Payment) SUM(*) WHERE State='AZ'; c. SELECT FROM Customers SUM(Payment) WHERE State='AZ' COUNT(*); d. SELECT COUNT(*), SUM(Payment) FROM Customers WHERE State='AZ';
d. SELECT COUNT(*), SUM(Payment) FROM Customers WHERE State='AZ';
Based on the code shown, which query lists the number, name, and available credit for all customers with credit limits that exceed their balances? Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum ) a. SELECT CustomerNum, CustomerName AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ; b. SELECT CustomerNum, CustomerName, CreditLimit AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ; c. SELECT CustomerNum, CustomerName, Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ; d. SELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
d. SELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
What command do you use to make changes to existing data in a table? a. MODIFY b. CHANGE c. SELECT d. UPDATE
d. UPDATE
In Access SQL, which character is used as a wildcard to represent any individual character? a. underscore (_) b. hash tag (#) c. asterisks (*) d. question mark (?)
d. question mark (?)
While not always required, how should you end an SQL command? a. with a comma (,) b. with a period (.) c. with a colon (:) d. with a semicolon (;)
d. with a semicolon (;)
