Question 1

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

Accepted Answer

A RELATION IS A TWO-DIMENSIONAL TABLE IN

Question 2

If you use an aggregate function in a query to determine the average values in a Bonus field, what default field name does Access use for the column with the calculations?

Accepted Answer

A) Bonus 
B) Average Bonus 
C) BonusAvg 
D) AvgOfBonus 
A) Bonus 
B) Average Bonus 
C) BonusAvg 
D) AvgOfBonus

Question 3

Which database term refers to a row in a table?

Accepted Answer

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

Question 4

What type of Access query changes data?

Accepted Answer

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

Question 5

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 
A) foreign key field 
B) composite field 
C) grouping field 
D) computed field

Question 6

For a one-to-many relationship in the Access Relationships window, how can you tell which table is the "many" table?

Accepted Answer

A) The one symbol identifies the "many" table. 
B) The "many" table always appears to the left of the "one" table. 
C) The "many" table always appears below the "one" table. 
D) An infinity symbol identifies the "many" table. 
A) The one symbol identifies the "many" table. 
B) The "many" table always appears to the left of the "one" table. 
C) The "many" table always appears below the "one" table. 
D) An infinity symbol identifies the "many" table.

Question 7

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

Question 8

In Access, if you want to be able to enter different criteria each time you run a query, create a(n) _____ query.

Accepted Answer

A) update 
B) parameter 
C) run-time 
D) aggregate 
A) update 
B) parameter 
C) run-time 
D) aggregate

Question 9

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 
A) MonthlySalary = [Salary / 12] 
B) MonthlySalary: [Salary] / 12 
C) Salary / 12 = [MonthlySalary] 
D) MonthlySalary: "Salary" / 12

Question 10

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

Question 11

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. 
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 12

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. 
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 13

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

Question 14

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 
A) LastName 
B) EmployeeID 
C) Email 
D) BirthDate

Question 15

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) 
A) "UnitPrice" 
B) Unit Price 
C) [UnitPrice] 
D) (UnitPrice)

Question 16

Microsoft Access uses Query Design View as a QBE.

Accepted Answer

A) True 
 B)False

Question 17

In an Access query, how can you list records in A-Z order by last name?

Accepted Answer

A) Set an ascending sort order on the LastName field. 
B) Group the LastName field. 
C) Set a descending sort order in the LastName field. 
D) Remove the checkmark from the Show box in the LastName field. 
A) Set an ascending sort order on the LastName field. 
B) Group the LastName field. 
C) Set a descending sort order in the LastName field. 
D) Remove the checkmark from the Show box in the LastName field.

Question 18

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) parameter 
A) update 
B) delete 
C) make-table 
D) parameter

Question 19

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 query 
A) update query 
B) difference query 
C) delete query 
D) parameter query

Question 20

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

Accepted Answer

A) attribute 
B) column 
C) primary key 
D) field 
A) attribute 
B) column 
C) primary key 
D) field

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

If you use an aggregate function in a query to determine the average values in a Bonus field, what default field name does Access use for the column with the calculations?

Which database term refers to a row in a table?

What type of Access query changes data?

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

For a one-to-many relationship in the Access Relationships window, how can you tell which table is the "many" table?

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

In Access, if you want to be able to enter different criteria each time you run a query, create a(n) _____ query.

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

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

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

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

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?

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

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?

Microsoft Access uses Query Design View as a QBE.

In an Access query, how can you list records in A-Z order by last name?

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

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

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

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

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

If you use an aggregate function in a query to determine the average values in a Bonus field, what default field name does Access use for the column with the calculations?

Which database term refers to a row in a table?

What type of Access query changes data?

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

For a one-to-many relationship in the Access Relationships window, how can you tell which table is the "many" table?

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

In Access, if you want to be able to enter different criteria each time you run a query, create a(n) _____ query.

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

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

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

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

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?

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

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?

Microsoft Access uses Query Design View as a QBE.

In an Access query, how can you list records in A-Z order by last name?

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

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

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

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