Term
|
Definition
| S.tructured Q.uery L.anguage |
|
|
Term
| SQL is used to communicate with a _____________. |
|
Definition
|
|
Term
| According to ANSI (American National Standards Institute), SQL is the standard language for ______________ database management systems. |
|
Definition
|
|
Term
| Common relational database management systems that use SQL are: ______, _______, _____________ ____, ______, ___, etc. |
|
Definition
Oracle,
Sybase,
Microsoft SQL Server,
Access,
Ingres, |
|
|
Term
| True or False: Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. |
|
Definition
| True. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. |
|
|
Term
| A relational database system contains one or more objects called _______. |
|
Definition
|
|
Term
| Tables are uniquely identified by their names and are comprised of ______s and _______s. |
|
Definition
|
|
Term
| The ______ statement is used to query the database and retrieve selected data that match the criteria that you specify. |
|
Definition
|
|
Term
| The ______ clause (optional) specifies which data values or rows will be returned or displayed, based on the criteria described after the keyword where. |
|
Definition
|
|
Term
Conditional selections used in the where clause:
= Equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
<> Not equal to
One is missing |
|
Definition
| LIKE * The LIKE pattern matching operator can also be used in the conditional selection of the where clause. |
|
|
Term
| The LIKE pattern matching operator can also be used in the conditional selection of the _____ clause. |
|
Definition
|
|
Term
| The percent sign "___" can be used as a wild card to match any possible character that might appear before or after the characters specified. |
|
Definition
|
|
Term
select first, last, city
from empinfo
where first LIKE 'Er%';
In this example of conditional selection, 'Er%';is the last part of the _______ clause. |
|
Definition
|
|
Term
| The table name that follows the keyword ________ specifies the table that will be queried to retrieve the desired results. |
|
Definition
|
|
Term
select first, last
from empinfo
where last LIKE '%s';
Is a statement looking for last names that end with _. |
|
Definition
|
|
Term
select first, last, city
from empinfo
where first LIKE 'Er%';
Is a statement looking for first names that begin with ____. |
|
Definition
|
|
