Question 1

If you use ____________________ criteria, each criterion must be true for a record to be selected.

Accepted Answer

A)   OR
B)   aggregate
C)   AND
D)   BOTHE) A) and C)
F) B) and C)

Question 2

What type of query could you run to remove records with a product ID of 702 from the Products table?

Accepted Answer

A)   update query
B)   difference query
C)   delete query
D)   parameter queryE) A) and C)
F) None of the above

Question 3

Which aggregate function do you use to total the values in a numeric field in a group of records?

Accepted Answer

A)   Sum
B)   Total
C)   Count
D)   MaxE) A) and D)
F) None of the above

Question 4

In Access Query Design View, which of the following expressions calculates the number of days between today's date and a field named DueDate?

Accepted Answer

A)   Date - DueDate
B)   Today - [DueDate]
C)   Day()  - [DueDate]
D)   Date()  - [DueDate]E) A) and B)
F) A) and C)

Question 5

Which of the following criteria selects all records containing a value greater than 250?

Accepted Answer

A)   ="250"
B)   250
C)   250
D)   >250E) C) and D)
F) A) and B)

Question 6

In Access, what uniquely identifies a row in a table?

Accepted Answer

A)   attribute
B)   column
C)   primary key
D)   fieldE) A) and C)
F) A) and D)

Question 7

What type of Access query creates a new table using the query results?

Accepted Answer

A)   new-table
B)   make-table
C)   create-table
D)   merge-tableE) A) and B)
F) All of the above

Question 8

A _____ is a question about the data structured in a way that the DBMS can recognize and process.

Accepted Answer

A)   query
B)   product
C)   relationship
D)   tupleE) B) and D)
F) None of the above

Question 9

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

Accepted Answer

Relational algebra is a query language t...

Question 10

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 C)
F) B) and C)

Question 11

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

Accepted Answer

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

Question 12

The Access query design grid contains the ProductID, ProductName, and Rating fields. How can you omit the Rating field from the query results but use it to set a criterion for the query?

Accepted Answer

A)   Delete the Rating field from the query design grid.
B)   Add a second copy of the Rating field to the query design grid.
C)   Clear the checkmark from the Rating field's Show check box.
D)   Change the query to an update query.E) C) and D)
F) None of the above

Question 13

Which of the following is a technique for increasing the speed of Access queries?

Accepted Answer

A)   Use Query Design View to join tables.
B)   Type field names directly into the query design grid.
C)   Include fields considered optional for the query.
D)   Delete field lists that are not needed for the query.E) None of the above
F) All of the above

Question 14

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

Question 15

List six properties that define a relation, a two-dimensional table.

Accepted Answer

A relation is a two-dimensional table in...

Question 16

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

Question 17

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

Question 18

Microsoft Access uses Query Design View as a QBE.

Accepted Answer

A) True 
 B)False

Question 19

Based on the following notation, which relational algebra command would list all information from the table concerning the customer with numeric CustomerNum 260? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

Accepted Answer

A)   SELECT Customer 260 RESULTS Answer
B)   SELECT Customer WHERE CustomerNum=260 GIVING Answer
C)   SELECT Customer GIVING Answer WHERE CustomerNum='260'
D)   SELECT Customer WHERE CustomerNum='260' RESULTS AnswerE) B) and C)
F) B) and D)

Question 20

In Access a(n)  _____ query permanently removes all the records from the selected table(s)  that satisfy the criteria entered in the query.

Accepted Answer

A)   update
B)   delete
C)   make-table
D)   parameterE) None of the above
F) B) and C)

Exam 2: The Relational Model: Introduction, Qbe, and Relational Algebra

Microsoft Access uses Query Design View as a QBE.

Correct AnswerverifiedShow Answer

In Access Query Design View, which of the following expressions calculates the number of days between today's date and a field named DueDate?

Correct AnswerverifiedShow Answer

A _____ is a question about the data structured in a way that the DBMS can recognize and process.

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

The Access query design grid contains the ProductID, ProductName, and Rating fields. How can you omit the Rating field from the query results but use it to set a criterion for the query?

Correct AnswerverifiedShow Answer

What type of Access query creates a new table using the query results?

Correct AnswerverifiedShow Answer

In Access, what uniquely identifies a row in a table?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which aggregate function do you use to total the values in a numeric field in a group of records?

Correct AnswerverifiedShow Answer

Which of the following criteria selects all records containing a value greater than 250?

Correct AnswerverifiedShow Answer

Which of the following is a technique for increasing the speed of Access queries?

Correct AnswerverifiedShow Answer

Based on the following notation, which relational algebra command would list all information from the table concerning the customer with numeric CustomerNum 260? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)

Correct AnswerverifiedShow Answer

What type of query could you run to remove records with a product ID of 702 from the Products table?

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

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

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

List six properties that define a relation, a two-dimensional table.

Correct AnswerverifiedA relation is a two-dimensional table in...View AnswerShow Answer

If you use ____________________ criteria, each criterion must be true for a record to be selected.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In Access a(n) _____ query permanently removes all the records from the selected table(s) that satisfy the criteria entered in the query.

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified
A relation is a two-dimensional table in...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified