IST 210 Final P2
nested
A subquery is a ____ query- one complete query inside another query.
30
A table alias can have a maximum of ____ characters.
underscore
A table name can contain the number sign and ___ symbols.
inline
An ORDER BY clause can be included in an ____ view to perform "TOP-N" analysis.
alias
An ____ is an alternate name temporarily assigned to a table.
ascending
By default, a column listed in an ORDER BY clause is displayed in ___ order.
all
By default, the AVG function assumes the ____ keyword, which indicates that all values should be included in the calculation.
sequence
A ___ can be used to generate values for a column designated as the primary key for a table.
view
A ___ can be used to restrict a user's access to sensitive data
view
A ____ can bed created to simplify the querying process for novice database users.
subquery
A ____ is a nested query- one complete query inside another query.
function
A ____ is a predefined block of code that accepts one or more arguments and returns a single value as output.
complex
A ____ view can contain group functions.
inline
A ____ view only exists while the SELECT command is being executed.
nonequijoin
A _____ join is used when the related columns between two tables cannot be joined through an equal sign.
multiple-column
A ______ subquery returns more than one column to the outer query.
qualifier
A column ___ indicates the table containing the column being referenced.
data type
A column's ____ identifies the type of data that can be stored in a column.
column
A constraint is created at the ____ level if it is included as part of the column definition.
object
A database ___ is a definer, self-contained structure in oracle 11g.
where
A full outer join cannot be created in the ___ clause.
equality
A join that is based upon data having equivalent data in common columns is known as an ___ join.
on
A self-join can only be specified in the FROM clause w the use of the JOIN... ____ keywords.
query
Choosing specific columns in a SELECT statement is known as ____.
concatenate
Combining the contents of two or more columns is known as _____.
one
The DROP COLUMN clause of the ALTER TABLE command can be used to drop a maximum of ____ columns at a time.
numeric
The SUM function can only be used w ___ columns.
update
The ___ command is used to change data stored in a table.
lock
The ____ TABLE command is used to prevent other users from making changes to a portion of a table.
where
The ____ clause can be used to restrict rows, but not groups.
DESC
The ____ command can be used to display the structure of a table
rollback
The ____ command will reverse all DML operations performed since the last COMMIT was performed.
IS NULL
The ____ comparison operator is used to search for NULL values.
char
The ____ datatype is used to store fixed length data.
to date
The ____ function allows a user to enter a date in a variety of formats, and then changes the value to the default Oracle 11g internal storage format.
count*
The ____ function can be used to count the total records that meet a specific condition, including those that contain NULL values.
count
The ____ function can be used to determine the number of rows that have non-NULL values in a specified column.
to_char
The ____ function is used to convert dates and numbers to a formatted character string.
MAX
The ____ function is used to determine the largest value stored in a specified column.
in
The ____ function takes a specified value and returns results based on a set of values provided in a list.
sys-date
The ____ keyword can be included in the INSERT command to enter the computer's date into the row when it is added to the table.
NULL
The ____ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed last in the results.
number
The ____ value of a sequence cannot be changed if the sequence has already generated a number greater than the value.
increment by
The _____ clause is used to indicate the interval that must exist between two values generated in a sequence.
drop column
The _____ clause of the ALTER TABLE command can be used to delete a column from an existing table.
DROP VIEW
The _____ command can be used to permanently remove a view from a database.
between in
The _____ comparison operator is used to indicate that a data value must fall within a range of values to be included in the query results.
NVL
The _____ function is used to substitute a specified value for a NULL value.
natural join
The _____ keywords create a join automatically between two tables, based on columns w matching names.
WITH CHECK OPTION
The ______ keywords are used to make certain any DML operations do not prevent a row from being accessible to the view after the DML operation is executed.
NVL
The _____function allows different actions to be performed based upon whether a NULL value exists in a specified column.
parenthesis
The column list of the CREATE TABLE command must be enclosed in _____.
transaction
The duration of a _____ is defined by when a COMMIT implicitly or explicitly occurs.
FROM
The name of the table containing the data to be retrieved is specified in the ____ clause.
SELECT
The names of the columns to be retrieved are listed in the ____ clause.
where
The outer join operator can only be used in the ____ clause.
single
When non-numeric data is being added to a table, the data must be enclosed in ___ quotation marks.
SDLC
the steps used to design and develop a database are commonly referred to as the ____
Foreign key
If at least one value in a record does not depend upon the primary key, then a _____ exists.
ORDER BY
If the data returned by the GROUP BY clause needs to be stored in descending order, you must include a ____ clause in the SELECT statement.
inner
Joins are classified as ____ joins if the results can only contain the rows that had matching values in each table, rather than rows being matched w NULL values.
column
Each ____ name within a table must be unique.
having
When a SELECT statement contains WHERE, GROUP BY, and HAVING clauses, the ____ clause is always evaluated last.
subquery
An inline view is created by a SELECT statement that contains a ____ in the FROM clause.
simple
Any DML operation can be performed on a ____ view as long as the view was created w the WITH READ ONLY option and existing constraints are not violated
using
When two tables that share more than one common column being joined, the JOIN.... _____ keywords are normally used in the FROM clause to join the tables.
correlated
With a ____ subquery, the subquery is executed once for each row in the outer query.
SQL
____ is a data sublanguage that processes sets of data.
SELECT
____ statements can be used to retrieve data from database table.
many to many
a ____ relationship means data can have multiple occurences in both entities