Quiz 3

Question 1

A database extracted from the operational database for BI purposes typically ________.

a. contains just part of the operational database
b. contains only the metadata from the operational database
c. is an exact copy of the operational database
d. combines all the data from the operational database into one large table

Answer 1

a. contains just part of the operational database

Question 2

An ad-hoc query is ________.

a. never useful in Business Intelligence scenarios
b. a question that can be answered only by combining several SQL queries
c. a question that can be answered from the database using SQL
d. a question about the data that requires a program to be written

Answer 2

c. a question that can be answered from the database using SQL

Question 3

In an SQL query, which SQL keyword is used to state the condition that specifies which rows are to be selected?

a. SELECT
b. WHERE
c. SET
d. FROM

Answer 3

b. WHERE

Question 4

In an SQL query, which of the following symbols is used by ANSI SQL to represent all the columns in a single table?

a. _ (underscore)
b. * (asterisk)
c. ? (question mark)
d. % (percent)

Answer 4

b. * (asterisk)

Question 5

SQL is only a data manipulation language (DML).
True or False

Answer 5

False