Question 1

The field you use to sort records is called the _____.

Accepted Answer

A) sort key 
B) sort argument 
C) parent key 
D) foreign key 
A) sort key 
B) sort argument 
C) parent key 
D) foreign key A

Question 2

To select data from more than one table at the same time, you need to perform a make-table query.

Accepted Answer

A) True 
 B)False  False

Question 3

You can create compound criteria (conditions) in a query by using which of the following two keywords?

Accepted Answer

A) AND, OR 
B) AND, NOR 
C) OR, NOT 
D) NOT, ONLY 
A) AND, OR 
B) AND, NOR 
C) OR, NOT 
D) NOT, ONLY A

Question 4

In relational algebra, which command retrieves rows from a table based on specified criteria?

Accepted Answer

A) SELECT 
B) JOIN 
C) CREATE 
D) UNION 
A) SELECT 
B) JOIN 
C) CREATE 
D) UNION

Question 5

In Access, if you want a query to list the ProductID, Category, and Description field values and sort the records by description within each category, how should you arrange the fields from left to right in the query design grid?

Accepted Answer

A) ProductID, Description, Category 
B) Description, Category, ProductID 
C) Description, ProductID, Category 
D) ProductID, Category, Description 
A) ProductID, Description, Category 
B) Description, Category, ProductID 
C) Description, ProductID, Category 
D) ProductID, Category, Description

Question 6

What do you call the field used to join two tables on the "many" side of a one-to-many relationship?

Accepted Answer

A) foreign key field 
B) primary key field 
C) secondary sort field 
D) calculated field 
A) foreign key field 
B) primary key field 
C) secondary sort field 
D) calculated field

Question 7

In the Access QBE, where do you specify criteria for a query?

Accepted Answer

A) in the upper pane of Query Design View 
B) in the Criteria row of the query design grid 
C) in Datasheet view of the query 
D) in the Navigation Pane 
A) in the upper pane of Query Design View 
B) in the Criteria row of the query design grid 
C) in Datasheet view of the query 
D) in the Navigation Pane

Question 8

Explain what relational algebra is and provide an example showing how it is used.

Accepted Answer

Relational algebra is a query language t

Question 9

How are aggregate functions different from other types of functions?

Accepted Answer

A) Aggregate functions make calculations on groups of records. 
B) Aggregate functions return yes/no or true/false values. 
C) Aggregate functions work only with numeric data. 
D) Aggregate functions do not work with date values. 
A) Aggregate functions make calculations on groups of records. 
B) Aggregate functions return yes/no or true/false values. 
C) Aggregate functions work only with numeric data. 
D) Aggregate functions do not work with date values.

Question 10

Which of the following Access functions can you use to return the number of records in a group of records?

Accepted Answer

A) Group 
B) Count 
C) Total 
D) Number 
A) Group 
B) Count 
C) Total 
D) Number

Question 11

What is the difference between the records that are selected when AND criteria versus OR criteria in a query?

Accepted Answer

In AND criteria, each criterio

Question 12

If you want to select records containing the text Consulting in the ProjectType field, how does Access save the criterion in the query grid of Query Design View?

Accepted Answer

A) "Consulting" 
B) #Consulting# 
C) [Consulting] 
D) (Consulting) 
A) "Consulting" 
B) #Consulting# 
C) [Consulting] 
D) (Consulting)

Question 13

The attributes of an entity become the fields or columns in a table.

Accepted Answer

A) True 
 B)False

Question 14

In relational algebra, what command is used to identify certain columns?

Accepted Answer

A) SELECT 
B) DELETE 
C) PROGRAM 
D) PROJECT 
A) SELECT 
B) DELETE 
C) PROGRAM 
D) PROJECT

Question 15

Discuss the difference between the major sort key and the minor sort key using an example.

Accepted Answer

When you are sorting records by more tha

Question 16

When you can determine the value of a field using information from existing fields in a record in a query, you should create a(n) _____.

Accepted Answer

A) argument 
B) compound condition 
C) grouping field 
D) computed field 
A) argument 
B) compound condition 
C) grouping field 
D) computed field

Question 17

Based on the following table, which relational algebra command creates a new table named CustState containing the fields CustomerNum and State? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

Accepted Answer

A) JOIN Customer WITH (CustomerNum, State) GIVING CustState 
B) PROJECT Customer OVER (CustomerNum, State) GIVING CustState 
C) SELECT Customer OVER (CustomerNum, State) GIVING CustState 
D) MAKE-TABLE CustState FROM Customer WITH (CustomerNum, State) 
A) JOIN Customer WITH (CustomerNum, State) GIVING CustState 
B) PROJECT Customer OVER (CustomerNum, State) GIVING CustState 
C) SELECT Customer OVER (CustomerNum, State) GIVING CustState 
D) MAKE-TABLE CustState FROM Customer WITH (CustomerNum, State)

Question 18

If you are sorting records by more than one field, which field is the first field that is evaluated for sorting purposes?

Accepted Answer

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

Question 19

List five aggregate functions available in Access.

Accepted Answer

The aggregate functions discus

Question 20

What type of functions are Count, Sum, Avg, Max, and Min?

Accepted Answer

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

The field you use to sort records is called the _____.

To select data from more than one table at the same time, you need to perform a make-table query.

You can create compound criteria (conditions) in a query by using which of the following two keywords?

In relational algebra, which command retrieves rows from a table based on specified criteria?

In Access, if you want a query to list the ProductID, Category, and Description field values and sort the records by description within each category, how should you arrange the fields from left to right in the query design grid?

What do you call the field used to join two tables on the "many" side of a one-to-many relationship?

In the Access QBE, where do you specify criteria for a query?

Explain what relational algebra is and provide an example showing how it is used.

How are aggregate functions different from other types of functions?

Which of the following Access functions can you use to return the number of records in a group of records?

What is the difference between the records that are selected when AND criteria versus OR criteria in a query?

If you want to select records containing the text Consulting in the ProjectType field, how does Access save the criterion in the query grid of Query Design View?

The attributes of an entity become the fields or columns in a table.

In relational algebra, what command is used to identify certain columns?

Discuss the difference between the major sort key and the minor sort key using an example.

When you can determine the value of a field using information from existing fields in a record in a query, you should create a(n) _____.

Based on the following table, which relational algebra command creates a new table named CustState containing the fields CustomerNum and State? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

If you are sorting records by more than one field, which field is the first field that is evaluated for sorting purposes?

List five aggregate functions available in Access.

What type of functions are Count, Sum, Avg, Max, and Min?

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Trends

Filters

Exam 8: Database Industry Careers

The field you use to sort records is called the _____.

To select data from more than one table at the same time, you need to perform a make-table query.

You can create compound criteria (conditions) in a query by using which of the following two keywords?

In relational algebra, which command retrieves rows from a table based on specified criteria?

In Access, if you want a query to list the ProductID, Category, and Description field values and sort the records by description within each category, how should you arrange the fields from left to right in the query design grid?

What do you call the field used to join two tables on the "many" side of a one-to-many relationship?

In the Access QBE, where do you specify criteria for a query?

Explain what relational algebra is and provide an example showing how it is used.

How are aggregate functions different from other types of functions?

Which of the following Access functions can you use to return the number of records in a group of records?

What is the difference between the records that are selected when AND criteria versus OR criteria in a query?

If you want to select records containing the text Consulting in the ProjectType field, how does Access save the criterion in the query grid of Query Design View?

The attributes of an entity become the fields or columns in a table.

In relational algebra, what command is used to identify certain columns?

Discuss the difference between the major sort key and the minor sort key using an example.

When you can determine the value of a field using information from existing fields in a record in a query, you should create a(n) _____.

Based on the following table, which relational algebra command creates a new table named CustState containing the fields CustomerNum and State? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

If you are sorting records by more than one field, which field is the first field that is evaluated for sorting purposes?

List five aggregate functions available in Access.

What type of functions are Count, Sum, Avg, Max, and Min?

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Trends

Filters