Shared Flashcard Set

Details

SQL LVL1
Structured Query Language
16
Computer Science
Professional
03/28/2013

Additional Computer Science Flashcards

 


 

Cards

Term
The acronym SQL means?
Definition
S.tructured Q.uery L.anguage
Term
SQL is used to communicate with a _____________.
Definition
Database
Term
According to ANSI (American National Standards Institute), SQL is the standard language for ______________ database management systems.
Definition
relational
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
tables
Term
Tables are uniquely identified by their names and are comprised of ______s and _______s.
Definition
columns and rows
Term
The ______ statement is used to query the database and retrieve selected data that match the criteria that you specify.
Definition
select
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
where
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
where
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
where
Term
The table name that follows the keyword ________ specifies the table that will be queried to retrieve the desired results.
Definition
from
Term
select first, last
from empinfo
where last LIKE '%s';

Is a statement looking for last names that end with _.
Definition
S
Term
select first, last, city
from empinfo
where first LIKE 'Er%';

Is a statement looking for first names that begin with ____.
Definition
Eric
Supporting users have an ad free experience!