CH. 7 & CH. 8

Question 1

an alternative name for a column or table in a SQL statement.

Answer 1

ALIAS

Question 2

the SQL logical operator used to link multiple conditional expressions in a WHERE or HAVING clause. It requires that all conditional expressions evaluate to true.

Answer 2

AND

Question 3

a SQL aggregate function that outputs the mean average for a specified column or expression.

Answer 3

AVG

Question 4

in SQL, a special comparison operator used to check whether a value is within a range of specified values.

Answer 4

BETWEEN

Question 5

A nested ordering sequence for a set of rows, such as a list in which all last names are alphabetically ordered and, within the last names, all first names are ordered.

Answer 5

Cascading Order Sequence

Question 6

A SQL aggregate function that outputs the number of rows containing noto null values for a given column or expression, sometimes used in conjunction with the DISTINCT clause.

Answer 6

COUNT

Question 7

A relational operation that yields a new table composed of only the rows with common values in their common attribute(s).

Answer 7

NATURAL JOIN

Question 8

A relational algebra join operation that produces a table in which all unmatched pairs are retained; unmatched values in the related table are left null.

Answer 8

OUTER JOIN

Question 9

A SQL clause that produces only a list of values that are different from one another.

Answer 9

DISTINCT

Question 10

In SQL, a comparison operator that checks whether a subquery returns any rows.

Answer 10

EXISTS

Question 11

A SQL clause that specifies the table or tables form which data is to be retrieved.

Answer 11

FROM

Question 12

A SQL clause used to create frequency distributions when combined with any of the aggregate functions in a SELECT statement.

Answer 12

GROUP BY

Question 13

A clause applied to the output of a GROUP BY operation to restrict selected rows.

Answer 13

HAVING

Question 14

In SQL, a comparison operator used to check whether a value is among a list of specified values. .

Answer 14

IN

Question 15

In SQL a comparison operator used to check whether an attribute has a value.

Answer 15

IS NULL

Question 16

In SQL, a comparison operator used to check whether an attribute’s text value matches a specified string pattern.

Answer 16

LIKE

Question 17

A SQL aggregate function that yields the maximum attribute value in a given column.

Answer 17

MAX

Question 18

A SQL aggregate function that yields the minimum attribute value in a given column.

Answer 18

MIN

Question 19

A SQL logical operator that negates a given predicate.

Answer 19

NOT

Question 20

The SQL logical operator used to link multiple conditional expressions in a WHERE or HAVING clause. It requires only one of the conditional expressions to be true.

Answer 20

OR

Question 21

A SQL clause that is useful for ordering the output of a SELECT query.

Answer 21

ORDER BY

Question 22

A query that joins a table to itself.

Answer 22

Recursive Query

Question 23

Basic algebraic rules that specify the order in which operations are performed. EXAMPLE: operations within parentheses are executed first so in 2+(3*5), the multiplication is calculated first.

Answer 23

Rules of Precedence

Question 24

In relational algebra, an operator used to select a subset of rows. AKA RESTRICT. (2) a SQL command that yields the values of all rows or a subset of rows in a table. The ___ statement is used to retrieve data from tables.

Answer 24

SELECT

Question 25

A query that is embedded inside another query. AKA nested query or inner query.

Answer 25

Subquery

Question 26

A SQL aggregate function that yields the sum of all values for a given column or expression.

Answer 26

SUM

Question 27

A SQL clause that adds conditional restrictions to a SELECT statement that limit the rows returned by the query.

Answer 27

WHERE

Question 28

A symbol that can be used as a general substitute for (1) all columns in a table (*) when used in an attribute list of a SELECT statement or (2) zero or more characters in a SQL LIKE clause condition (% and _)

Answer 28

Wildcard Character

Question 29

is used to add, modifiy, or delete columns in an existing table.

Answer 29

ALTER TABLE COMMAND

Question 30

Permanently saves data changes

Answer 30

COMMIT

Question 31

A SQL command that restores the database table contents to the condition that existed after the last COMMIT statement

Answer 31

ROLLBACK

Question 32

Creates a new table in user’s database schema

Answer 32

CREATE TABLE

Question 33

Creates and index for a table

Answer 33

CREATE INDEX

Question 34

Creates a dynamic subset of rows and columns from one or more tables

Answer 34

CREATE VIEW

Question 35

Deletes one or more rows from the table

Answer 35

DELETE

Question 36

A SQL command used to delete database objects such as tables, views, indexes, and users

Answer 36

DROP TABLE

Question 37

A SQL command that allows the insertion of one or more data rows into a table

Answer 37

INSERT

Question 38

A SQL command that allows attribute values to be changed in one or more rows of a table

Answer 38

UPDATE

Question 39

A SQL command used to delete database objects such as tables, views, indexes, and users

Answer 39

DROP TABLE

Question 40

creates a dynamic subset of rows and columns from one or more tables

Answer 40

CREATE VIEW

Question 41

creates a new table based on a query in the user’s database schema

Answer 41

CREATE TABLE AS

Question 42

set of SQL statements stored in the database catalog. Is executed or fired whenever an event associated with a table occurs e.g., insert. Update or delete

Answer 42

TRIGGER

Question 43

Similar to triggers, can be used to encapsulate and represent business transactions.

Answer 43

STORED PROCEDURES

Question 44

the result set of a stored query on the data. It is a virtual table based on a SELECT query.

Answer 44

VIEW

Question 45

is a method of inserting inline SQL statements or queries into the code of a programming language, which is known as a host language(in this case SQL)

Answer 45

Embedded SQL