Database Management Extra 11

Question 1

The SQL command that permanently writes data changes to a database.

Answer 1

COMMIT

Question 2

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

Answer 2

COUNT

Question 3

A SQL command that allows data rows to be deleted from a table.

Answer 3

DELETE

Question 4

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

Answer 4

DISTINCT

Question 5

A SQL command that permanently deletes an index.

DROP TABLE = A SQL command that permanently deletes a table and its data.

Answer 5

DROP INDEX

Question 6

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

Answer 6

EXISTS

Question 7

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

HAVING = clause applied to the output of a ??? ??? operation to restrict selected rows.

Answer 7

GROUP BY

Question 8

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

Answer 8

IN

Question 9

A query that is embedded or nested inside another query. Also known as a nested query or a subquery.

Answer 9

Inner Query

Question 10

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

Answer 10

INSERT