MISY 5300-MID TERM REVIEW QUESTIONS AND ANSWERS

MISY 5300-MID TERM LATEST
REVIEW
PROJECT
The __________________ SQL operation allows users of the relational
model to retrieve column-specific data from a table. This data is then
used to create a new table that is dedicated to the information that the
user would like to see.

Example: if you had a relational model consisting of nine different
columns but you only need the name and the date of birth for each
individual in the table, you would use a this operation to retrieve this
data.
Relation
Entire table of rows for one subject (also called entity).
SELECT
A command that retrieves certain rows from an existing table (based on
some user-specified criteria) and saves them as a new table.
FROM clause
The part of an SQL SELECT command that
indicates the tables in the query.
INSERT
The SQL command to add new data to a table. after the words
_______________ INTO, you list the name of the table, followed by the


END OF
PAGE
1

, MISY 5300-MID TERM LATEST
REVIEW
word VALUES. Then you list the values for each of the columns in
parentheses.
INSERT INTO
The SQL keywords for adding a new record to a table.
SELECT-FROM-WHERE
The basic form of an SQL data-retrieval command.
SQL (Structured Query Language)
A very popular relational data definition and manipulation language that
is used in many relational DBMSs.
WHERE
The part of an SQL SELECT command that indicates the condition rows
must satisfy to be displayed in the query results. limits the specific
records that are selected and link tables together.
*, ?
In MS access, the _____________ is used as a wildcard to represent any
collection of characters, and the _______________ is used to represent
one character.
Like
_________ operator is used for wildcard.
;
END OF
PAGE
2