Question 1

You can combine values in character fields using the & operator.

Accepted Answer

A) True 
 B)False

Question 2

Which function calculates the number of entries in a table?

Accepted Answer

A)  COUNT 
B)  SUM 
C)  MAX 
D)  MIN 
A)  COUNT 
B)  SUM 
C)  MAX 
D)  MIN

Question 3

Describe five data types that you will often encounter when working with databases.

Accepted Answer

INTEGER: Stores integers, which are numb

Question 4

You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.

Accepted Answer

A) True 
 B)False

Question 5

Based on the code shown, which query lists the number, name, and complete address of every customer located on a street that contains the letters "Oxford"???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

Accepted Answer

A)  SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "?Oxford" ; 
B)  SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "%Oxford%" ; 
C)  SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "@Oxford@" ; 
D)  SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "Oxford" ; 
A)  SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "?Oxford" ; 
B)  SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "%Oxford%" ; 
C)  SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "@Oxford@" ; 
D)  SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "Oxford" ;

Question 6

What command do you use to add new data to a table?

Accepted Answer

A)  INSERT 
B)  APPEND 
C)  ADDTO 
D)  SELECT 
A)  INSERT 
B)  APPEND 
C)  ADDTO 
D)  SELECT

Question 7

Use the word ____________ in the query to specify that data should be sorted in high to low order.

Accepted Answer

The answer of Use the word ____________ in the query...

Question 8

While not always required, how should you end an SQL command?

Accepted Answer

A)  with a comma (,) 
B)  with a period (.) 
C)  with a colon (:) 
D)  with a semicolon (;) 
A)  with a comma (,) 
B)  with a period (.) 
C)  with a colon (:) 
D)  with a semicolon (;)

Question 9

When you connect simple conditions using the ____________________ operator, the compound condition will be true whenever any of the simple conditions are true.

Accepted Answer

The answer of When you connect simple conditions using the...

Question 10

What clause do you use in a query to save the results of the query as a table?

Accepted Answer

A)  UPDATE 
B)  INSERT 
C)  INTO 
D)  DELETE 
A)  UPDATE 
B)  INSERT 
C)  INTO 
D)  DELETE

Question 11

When you use a name containing a space in Access SQL, what must you do to specify the table or column name?

Accepted Answer

A)  enclose it in quotation marks 
B)  enclose it in square brackets 
C)  enclose it in asterisks 
D)  enclose it in question marks 
A)  enclose it in quotation marks 
B)  enclose it in square brackets 
C)  enclose it in asterisks 
D)  enclose it in question marks

Question 12

The ____________________ of two tables is a table containing all rows that are in either the first table, the second table, or both.

Accepted Answer

The answer of The ____________________ of two tables is a...

Question 13

You use the SQL ____________________ command to create a table by describing its layout.

Accepted Answer

The answer of You use the SQL ____________________ command to...

Question 14

Describe how to construct a complex join query in a systematic fashion.

Accepted Answer

To construct a detailed query in a syste

Question 15

The two tables involved in a join operation must have the same structure.

Accepted Answer

A) True 
 B)False

Question 16

How many lines of output are produced when rows are grouped?

Accepted Answer

A)  one line for each group member 
B)  two lines for each group 
C)  one line for each group 
D)  no output is produced 
A)  one line for each group member 
B)  two lines for each group 
C)  one line for each group 
D)  no output is produced

Question 17

The ____________ clause is to groups as the WHERE clause is to rows.

Accepted Answer

The answer of The ____________ clause is to groups as...

Question 18

Discuss the restriction about the structure of two tables involved in a union.

Accepted Answer

The two tables involved in a union must

Question 19

When rows are grouped, one line of output is produced for each group.

Accepted Answer

A) True 
 B)False

Question 20

Use the ____________________ clause to sort data.

Accepted Answer

The answer of Use the ____________________ clause to sort data....

You can combine values in character fields using the & operator.

Which function calculates the number of entries in a table?

Describe five data types that you will often encounter when working with databases.

You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.

Based on the code shown, which query lists the number, name, and complete address of every customer located on a street that contains the letters "Oxford"???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

What command do you use to add new data to a table?

Use the word ____________ in the query to specify that data should be sorted in high to low order.

While not always required, how should you end an SQL command?

When you connect simple conditions using the ____________________ operator, the compound condition will be true whenever any of the simple conditions are true.

What clause do you use in a query to save the results of the query as a table?

When you use a name containing a space in Access SQL, what must you do to specify the table or column name?

The ____________________ of two tables is a table containing all rows that are in either the first table, the second table, or both.

You use the SQL ____________________ command to create a table by describing its layout.

Describe how to construct a complex join query in a systematic fashion.

The two tables involved in a join operation must have the same structure.

How many lines of output are produced when rows are grouped?

The ____________ clause is to groups as the WHERE clause is to rows.

Discuss the restriction about the structure of two tables involved in a union.

When rows are grouped, one line of output is produced for each group.

Use the ____________________ clause to sort data.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 3: The Relational Model 2: SQL

You can combine values in character fields using the & operator.

Which function calculates the number of entries in a table?

Describe five data types that you will often encounter when working with databases.

You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.

Based on the code shown, which query lists the number, name, and complete address of every customer located on a street that contains the letters "Oxford"???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

What command do you use to add new data to a table?

Use the word ____________ in the query to specify that data should be sorted in high to low order.

While not always required, how should you end an SQL command?

When you connect simple conditions using the ____________________ operator, the compound condition will be true whenever any of the simple conditions are true.

What clause do you use in a query to save the results of the query as a table?

When you use a name containing a space in Access SQL, what must you do to specify the table or column name?

The ____________________ of two tables is a table containing all rows that are in either the first table, the second table, or both.

You use the SQL ____________________ command to create a table by describing its layout.

Describe how to construct a complex join query in a systematic fashion.

The two tables involved in a join operation must have the same structure.

How many lines of output are produced when rows are grouped?

The ____________ clause is to groups as the WHERE clause is to rows.

Discuss the restriction about the structure of two tables involved in a union.

When rows are grouped, one line of output is produced for each group.

Use the ____________________ clause to sort data.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters