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 keyE) None of the above
F) A) and B) A

Question 2

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 keyE) A) and D)
F) A) and C)

Question 3

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

Accepted Answer

A)  SELECT
B)  JOIN
C)  CREATE
D)  UNIONE) B) and C)
F) All of the above

Question 4

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 5

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 6

List five aggregate functions available in Access.

Accepted Answer

The aggregate functions discus...

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 fieldE) B) and D)
F) A) and B)

Question 10

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) E) None of the above
F) All of the above

Question 11

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)  NumberE) A) and D)
F) A) and C)

Question 12

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 PaneE) C) and D)
F) A) and C)

Question 13

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

Accepted Answer

A)  SELECT
B)  DELETE
C)  PROGRAM
D)  PROJECTE) None of the above
F) C) and D)

Question 14

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.E) None of the above
F) B) and C)

Question 15

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, DescriptionE) A) and D)
F) C) and D)

Question 16

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, ONLYE) None of the above
F) All of the above A

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) E) C) and D)
F) All of the above

Question 18

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

Accepted Answer

A)  accumulation
B)  allowed
C)  primary
D)  aggregateE) B) and D)
F) None of the above

Question 19

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 fieldE) A) and D)
F) All of the above

Question 20

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

Accepted Answer

Relational algebra is a query language t...

Exam 8: Database Industry Careers

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

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedWhen you are sorting records by more tha...View AnswerShow Answer

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

Correct AnswerverifiedIn AND criteria, each criterio...View AnswerShow Answer

List five aggregate functions available in Access.

Correct AnswerverifiedThe aggregate functions discus...View AnswerShow Answer

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

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) _____.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How are aggregate functions different from other types of functions?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

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)

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedRelational algebra is a query language t...View AnswerShow Answer

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
When you are sorting records by more tha...
View Answer

Correct Answer
verified
In AND criteria, each criterio...
View Answer

Correct Answer
verified
The aggregate functions discus...
View Answer

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Relational algebra is a query language t...
View Answer