QUESTION 1

When using SQL, most information retrieval queries follow which of the following structured language?

A. SELECT attribute name(s), QUERY table name(s), WHEN condition criteria is met;

B. SELECT attribute name(s), JOIN table name(s), WHERE condition criteria is met;

C. SELECT attribute name(s), FROM table name(s), WHERE condition criteria is met;

D.SELECT attribute name(s), FROM table name(s), WHEN condition criteria is met;

QUESTION 2

Which of the following approaches to creating queries requires the least amount of expertise?

A. Query Design Language

B. SQL

C. QBE

D. Relational Algebra

QUESTION 3

The most commonly used data manipulation language is:

A. Structured Query Language (SQL)

B. Visual Basic

C. Query By Example

D. Relational Algebra

QUESTION 4

To create one new query in Microsoft Access using QBE, add the appropriate fields to the:

A. Show Table Window

B. Query Grid

C. Query Window

D. Datasheet View

QUESTION 5

A query's answer in Microsoft Access is called a(n):

A. Answer report

B. Query Window

C. Dynaset

D. Query grid