Question 1

The comparison operators are also known as relational operators.

Accepted Answer

A) True 
 B)False

Question 2

You can restrict the output from a join to include only certain columns by using the ____ command.

Accepted Answer

A) DELETE 
B) UNION 
C) PROJECT 
D) INTERSECT

Question 3

When a structure satisfies all the properties of a relation except for the first item-in other words,some entries contain repeating groups and thus are not single-valued-it is referred to as a(n) ____________________.

Accepted Answer

The answer of When a structure satisfies all the properties...

Question 4

When a field name contains spaces or SQL reserved words,you must enclose the field name in curly braces ({}).

Accepted Answer

A) True 
 B)False

Question 5

A relation is essentially just a two-dimensional table.

Accepted Answer

A) True 
 B)False

Question 6

Access automatically adds double quotation marks around values in the design grid that are formatted as Text fields when you run the query or move the insertion point to another cell in the design grid.

Accepted Answer

A) True 
 B)False

Question 7

A relational database handles entities,attributes,and relationships by storing each entity in its own table.

Accepted Answer

A) True 
 B)False

Question 8

Using the product operator,if table A has 4 rows and table B has 4 rows,the number of rows in the product of these two tables is ____.

Accepted Answer

A) 4 
B) 8 
C) 16 
D) 256

Question 9

The secondary key provides an important way of distinguishing one row in a table from another.

Accepted Answer

A) True 
 B)False

Question 10

The product of two tables is also called the ____ product.

Accepted Answer

A) Cartesian 
B) aggregate 
C) Cathode 
D) exponential

Question 11

The ____ operator is used to concatenate every row in the first table with every row in the second table.

Accepted Answer

A) union 
B) difference 
C) product 
D) intersection

Question 12

If you are sorting records by more than one field,the more important field is called the ____.

Accepted Answer

A) maximum sort key 
B) secondary sort key 
C) primary sort key 
D) minor sort key

Question 13

The comparison operators are +,*,%,and /.

Accepted Answer

A) True 
 B)False

Question 14

The relationships between tables are handled through ____________________ columns.

Accepted Answer

The answer of The relationships between tables are handled through...

Question 15

The ____ operator is performed by the SUBTRACT command in relational algebra.

Accepted Answer

A) union 
B) intersection 
C) product 
D) difference

Question 16

QBE is a visual approach to writing queries.

Accepted Answer

A) True 
 B)False

Question 17

To find the total of all customers' balances,use the ____________________ function.

Accepted Answer

The answer of To find the total of all customers'...

Question 18

Columns in a table are often called attributes or ____________________.

Accepted Answer

The answer of Columns in a table are often called...

Question 19

What is the difference between an AND criterion and an OR criterion? How is each criterion created in QBE?

Accepted Answer

The answer of What is the difference between an AND...

Question 20

Count,Sum,Avg,Max,and Min are a few of the built-in statistics or ____ functions that can be used in a query.

Accepted Answer

A) accumulated 
B) aggregate 
C) primary 
D) allowed

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

The comparison operators are also known as relational operators.

You can restrict the output from a join to include only certain columns by using the ____ command.

When a structure satisfies all the properties of a relation except for the first item-in other words,some entries contain repeating groups and thus are not single-valued-it is referred to as a(n) ____________________.

When a field name contains spaces or SQL reserved words,you must enclose the field name in curly braces ({}).

A relation is essentially just a two-dimensional table.

Access automatically adds double quotation marks around values in the design grid that are formatted as Text fields when you run the query or move the insertion point to another cell in the design grid.

A relational database handles entities,attributes,and relationships by storing each entity in its own table.

Using the product operator,if table A has 4 rows and table B has 4 rows,the number of rows in the product of these two tables is ____.

The secondary key provides an important way of distinguishing one row in a table from another.

The product of two tables is also called the ____ product.

The ____ operator is used to concatenate every row in the first table with every row in the second table.

If you are sorting records by more than one field,the more important field is called the ____.

The comparison operators are +,*,%,and /.

The relationships between tables are handled through ____________________ columns.

The ____ operator is performed by the SUBTRACT command in relational algebra.

QBE is a visual approach to writing queries.

To find the total of all customers' balances,use the ____________________ function.

Columns in a table are often called attributes or ____________________.

What is the difference between an AND criterion and an OR criterion? How is each criterion created in QBE?

Count,Sum,Avg,Max,and Min are a few of the built-in statistics or ____ functions that can be used in a query.