Q: What SQL code will list the name of every student whose postal code is 10113.â

âSELECT FirstName, LastName FROM Student WHERE PostalCode=\'10113\' ;

Q: What SQL code will find the name of the student whose ID is 1167.â

âSELECT FirstName, LastName FROM Student WHERE StudentID=\'1167\' ;

Q: What SQL code will list the descriptions of all items that are not in Storehouse 3.

âSELECT Description FROM Item WHERE NOT Storehouse=\'3\' ;

Q: What SQL code will list the number, name, and available credit for all customers with credit limits that exceed their balances.â

âSELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;

Q: What SQL code will list the descriptions of all items that are located in Storehouse 3 or for which there are more than 20 units on hand, or both.â

âSELECT Description FROM Item WHERE Storehouse=\'3\' OR OnHand>20 ;

Q: What SQL code will list the number, name, street, and credit limit of all customers. Order the customers by name within descending credit limit.â

âSELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ;

Q: What SQL code will list the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand.â

âSELECT Description FROM Item WHERE Storehouse=\'3\' AND OnHand>20 ;

Q: What SQL code will list 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.â

âSELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;

Q: What SQL code will change the postal code of the student with ID 11433 to 14455.â

âUPDATE Student SET PostalCode=\'14455\' WHERE StudentID=\'11433\' ;

Question 1

You can save the results of a query as a table by including the ____ clause in the query.â

Accepted Answer

Into

Question 2

What SQL code will list the name of every student whose postal code is 10113.â

Accepted Answer

âSELECT FirstName, LastName FROM Student WHERE PostalCode=\'10113\' ;

Question 3

The ____ function calculates the number of entries in a table.â

Accepted Answer

COUNT

Question 4

What SQL code will find the name of the student whose ID is 1167.â

Accepted Answer

âSELECT FirstName, LastName FROM Student WHERE StudentID=\'1167\' ;

Question 5

What SQL code will list the descriptions of all items that are not in Storehouse 3.

Accepted Answer

âSELECT Description FROM Item WHERE NOT Storehouse=\'3\' ;

Question 6

To add new data to a table, use the ____ command.â

Accepted Answer

âINSERT

Question 7

What SQL code will list the number, name, and available credit for all customers with credit limits that exceed their balances.â

Accepted Answer

âSELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;

Question 8

What SQL code will list the descriptions of all items that are located in Storehouse 3 or for which there are more than 20 units on hand, or both.â

Accepted Answer

âSELECT Description FROM Item WHERE Storehouse=\'3\' OR OnHand>20 ;

Question 9

What SQL code will list the number, name, street, and credit limit of all customers. Order the customers by name within descending credit limit.â

Accepted Answer

âSELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ;

Question 10

What SQL code will list the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand.â

Accepted Answer

âSELECT Description FROM Item WHERE Storehouse=\'3\' AND OnHand>20 ;

Question 11

âMany versions of SQL require you to end a command with a ____.

Accepted Answer

semicolon (;)

Question 12

What SQL code will list the complete student table.â

Accepted Answer

SELECT * FROM Student ;

Question 13

The basic form of an SQL retrieval command is ____.â

Accepted Answer

SELECT-FROM-WHERE

Question 14

In versions of SQL other than Access, the ____ is used as a wildcard to represent any collection of characters.â

Accepted Answer

percent sign (%)

Question 15

What SQL code will list 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.â

Accepted Answer

âSELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;

Question 16

âWhen rows are grouped, ____.

Accepted Answer

one line of output is produced for each group

Question 17

To use a wildcard, include the ____ operator in the WHERE clause.â

Accepted Answer

LIKE

Question 18

What SQL code will change the postal code of the student with ID 11433 to 14455.â

Accepted Answer

âUPDATE Student SET PostalCode=\'14455\' WHERE StudentID=\'11433\' ;

Question 19

What SQL code will find how many items are in category TOY.â

Accepted Answer

SELECT COUNT(*) FROM Item WHERE Category=\'TOY\' ;

Question 20

When used after the word SELECT, the ____ 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.â

Accepted Answer

*

Question 21

When you use a name containing a space in Access SQL, you must ____.â

Accepted Answer

enclose it in square brackets

Question 22

What SQL code will for each sales rep, list the rep number, the number of customers assigned to the rep, and the average balance of the rep\'s customers. Group the records by rep number and order the records by rep number.â

Accepted Answer

SELECT RepNum, COUNT(*), AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ;

Question 23

What SQL code will list the number, name, and complete address of every customer located on a street that contains the letters \"Oxford\".â

Accepted Answer

âSELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE \"%Oxford%\" ;

Question 24

What SQL code will list the number and name of all customers that are either represented by sales rep 30 or that currently have orders on file, or both.â

Accepted Answer

âSELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum=\'30\' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders WHERE Customer.CustomerNum=Orders.CustomerNum ;

Question 25

What SQL code will delete any row in the OrderLine table in which the item number is MT03.â

Accepted Answer

DELETE FROM OrderLine WHERE ItemNum=\'MT03\' ;

Chapter 3 – Space Flashcard

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards