Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
20 Cards in this Set
- Front
- Back
If you anticipate running a particular query often, you can improve overall performance by saving the query in a special file called a ___. |
stored procedure |
|
When a subquery is used, ___ is evaluated first. |
the subquery query |
|
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. |
* |
|
In Access SQL, the ___ is used as a wildcard to represent any individual character. |
question mark |
|
You can save the results of a query as a table by including the ___ clause in the query. |
INTO |
|
In order to make changes to existing data in a table, you would use the ___ command. |
UPDATE |
|
In SQL, you use the CHECK clause to enforce ___ integrity. |
legal-values |
|
Essentially, setting the value in a given field to ___ is similar to not enter a value in it at all. |
null |
|
To use a stored procedure in MySQL, a user enters the word ___ followed by the procedure name. |
CALL |
|
The basic form of an SQL retrieval command is ___. |
SELECT-FROM-WHERE |
|
The CHECK clause can be included in the ___ command. |
CREATE TABLE |
|
Part (PartNum, Description, OnHand, Class, Warehouse, Price) Based on the code above, list the descriptions of all parts that are located in Warehouse 3 for which there are more than 20 units on hand or both.
|
SELECT Description FROM Part WHERE Warehouse= ‘3’ OR OnHand> 20 ; |
|
The ___ command will create an application program’s or individual user’s picture of the database. |
CREATE VIEW |
|
To create an index for the Customer table named RepBal with the keys RepNum and Balance and with the balances listed in descending order, the command is |
CREATE INDEX RepBal ON Customer (RepNum, Balance DESC) ; |
|
A trigger is stored and compiled on the ___. |
server |
|
Many versions of SQL require you to end a command with a ___. |
semicolon |
|
The SQL command for deleting the Warehouse field from the Part table is: |
ALTER TABLE Part DROP COLUMN Warehouse; |
|
A ___ is an action that occurs automatically in response to an associated database operation such as an INSERT, UPDATE, or DELETE command. |
trigger |
|
To add new data to a table use the ___ command. |
INSERT |
|
Customer (CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum) Based on the code above, for each sales rep, list the 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 of the records by rep number.
|
SELECT RepNum, COUNT(*), AVG(Balance) FROM Customer GROUP BY RepNum ORDER BY RepNum ; |