Database Management Extra 12

Question 1

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

Answer 1

IS NULL

Question 2

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

Answer 2

LIKE

Question 3

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

Answer 3

MAX (Opposite of MIN)

Question 4

A SQL clause that is useful for ordering the output of a SELECT query (for example, in ascending or descending order).

Answer 4

ORDER BY

Question 5

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

Answer 5

ROLLBACK

Question 6

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

Answer 6

UPDATE

Question 7

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

Answer 7

WHERE

Question 8

A comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making.

Answer 8

Business Intelligence (BI)

Question 9

In multidimensional OLAP, the shared, reserved memory area where data cubes are held. Using the ??? ??? assists in speeding up data access.

Answer 9

Cube Cache

Question 10

In business intelligence, a web-based system that presents key business performance indicators or information in a single, integrated view with clear and concise graphics.

Answer 10

Dashboards