IST 210 Final P2

Ace your homework & exams now with Quizwiz!

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


Related study sets

Exercise 1-7: Concepts; Terminology; Conceptual Framework

View Set

Lisette's NCLEX MED SURG Study #1

View Set

Peds success ch11 Muscular and neuromuscular disorders EX3

View Set

Chapter 11 - Intro to Organic Molecules and Functional Groups

View Set