Chapter 2 : Structured Query Language

A database extracted from the operational database for BI purposes typically

• is an exact copy of the operational database

• contains only the metadata from the operational database

• combines all the data from the operational database into one large table

• contains just part of the operational database

An ad-hoc query is

• a question about the data that requires a program to be written

• a question that can be answered from the database using SQL

• a question that can be answered only by combining several SQL queries

• never useful in Business Intelligence scenarios

SQL is a _________

• data sublanguage

• data manipulation language

• data definition language

• programming language

When making an SQL query, we are using SQL as a(n)

• DDL

• DML

• embedded language

• SET

In an SQL query, which SQL keyword actually begins the query?

• EXISTS

• FROM

• SELECT

• WHERE

In an SQL query, which SQL keyword is used to specify the table(s) to be used?

• EXISTS

• FROM

• SELECT

• WHERE

In an SQL query, which SQL keyword must be used to remove duplicate rows from the result table?

• DELETE

• DISTINCT

• UNIQUE

• KEY

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

• _ (underscore)

• ? (question mark)

• * (asterisk)

• % (percent)

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

• SET

• FROM

• SELECT

• WHERE

In an SQL query, which SQL keyword is used to link two conditions that both must be true for the rows to be selected?

• AND

• EXISTS

• OR

• IN