Question 1

Which of the following fields would be the best candidate for a primary key field in a table of employee data?

Accepted Answer

A)   LastName
B)   EmployeeID
C)   Email
D)   BirthDate

Question 2

Which of the following is NOT true about a relation, otherwise known as a two-dimensional table?

Accepted Answer

A)   The entries in the table should be single-valued.
B)   All values in a column should be values of the same attribute.
C)   Two or more columns can share the same name.
D)   The order of rows is not important.

Question 3

A ____________________ in a record is the result of a calculation using data from the rest of the record.

Accepted Answer

A)   foreign key field
B)   composite field
C)   grouping field
D)   computed field

Question 4

If you are creating a computed field that adds 10 percent to the UnitPrice field, how do you enter the UnitPrice field name in the expression?

Accepted Answer

A)   "UnitPrice"
B)   Unit Price
C)   [UnitPrice]
D)   (UnitPrice)

Question 5

What happens when you run a select query in Access?

Accepted Answer

A)   Access creates a unique copy of the data.
B)   Access selects current data from underlying tables.
C)   Access creates a table with the specified fields and records.
D)   Access locks the underlying tables so they cannot be changed. B

Question 6

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

Accepted Answer

A) True 
 B)False  False

Question 7

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

Question 8

In general, what should be in place before you select fields from more than one table in Access Query Design View?

Accepted Answer

A)   The tables should not contain fields with the same field name.
B)   The tables should be merged into one table.
C)   The join line between the tables should be deleted.
D)   The tables should be related in a proper one-to-many relationships.

Question 9

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 10

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 11

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

Question 12

In Access, you can display the results of a select query using the Run button or the View button.

Accepted Answer

A) True 
 B)False

Question 13

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)  B

Question 14

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

Accepted Answer

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

Question 15

Which of the following expressions in Access Query Design View creates a computed field named MonthlySalary using a value from the Salary field?

Accepted Answer

A)   MonthlySalary = [Salary / 12]
B)   MonthlySalary: [Salary] / 12
C)   Salary / 12 = [MonthlySalary]
D)   MonthlySalary: "Salary" / 12

Question 16

Which database term refers to a row in a table?

Accepted Answer

A)   tuple
B)   field
C)   group
D)   relation

Question 17

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.

Question 18

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

Accepted Answer

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

Question 19

What type of Access query changes data?

Accepted Answer

A)   addition
B)   projection
C)   update
D)   select

Question 20

In Access Query Design View, how do you add the Total row to the query design grid?

Accepted Answer

A)   Click the Totals button on the Query Tools Design tab.
B)   Click the Group by arrow in the Criteria row, and then click Total.
C)   Click the Grouping button on the Query Tools Design tab.
D)   Drag the Total field to the query design grid.

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

Which of the following fields would be the best candidate for a primary key field in a table of employee data?

Correct AnswerverifiedShow Answer

Which of the following is NOT true about a relation, otherwise known as a two-dimensional table?

Correct AnswerverifiedShow Answer

A ____________________ in a record is the result of a calculation using data from the rest of the record.

Correct AnswerverifiedShow Answer

If you are creating a computed field that adds 10 percent to the UnitPrice field, how do you enter the UnitPrice field name in the expression?

Correct AnswerverifiedShow Answer

What happens when you run a select query in Access?

Correct AnswerverifiedB

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

In general, what should be in place before you select fields from more than one table in Access Query Design View?

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

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

Correct AnswerverifiedShow Answer

In Access, you can display the results of a select query using the Run button or the View button.

Correct AnswerverifiedShow Answer

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 AnswerverifiedB

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

Correct AnswerverifiedShow Answer

Which of the following expressions in Access Query Design View creates a computed field named MonthlySalary using a value from the Salary field?

Correct AnswerverifiedShow Answer

Which database term refers to a row in a table?

Correct AnswerverifiedShow Answer

How are aggregate functions different from other types of functions?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What type of Access query changes data?

Correct AnswerverifiedShow Answer

In Access Query Design View, how do you add the Total row to the query design grid?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified
False

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

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified