Question 1

How does the Access Relationships window indicate the "many" field in a one-to-many relationship?

Accepted Answer

A) ring and crow's foot 
B) number 1 
C) filled circle 
D) infinity symbol 
A) ring and crow's foot 
B) number 1 
C) filled circle 
D) infinity symbol

Question 2

Which of the following Access features does not demonstrate the power of one-to-many relationships?

Accepted Answer

A) select queries involving related tables 
B) forms with subforms 
C) subdatasheets 
D) indexes 
A) select queries involving related tables 
B) forms with subforms 
C) subdatasheets 
D) indexes

Question 3

What shape does an E-R diagram use to represent entities?

Accepted Answer

A) rectangle 
B) oval 
C) triangle 
D) diamond 
A) rectangle 
B) oval 
C) triangle 
D) diamond

Question 4

ProductType is a foreign key field in the Orders table and is constrained to a list of valid entries stored in the ProductTypes table. What problem does this design prevent?

Accepted Answer

A) creation anomalies 
B) deletion anomalies 
C) update anomalies 
D) record locking 
A) creation anomalies 
B) deletion anomalies 
C) update anomalies 
D) record locking

Question 5

Which of the following is a valid reason for creating a one-to-one relationship between two tables?

Accepted Answer

A) One table would otherwise not participate in a relationship. 
B) The tables create a Cartesian join. 
C) The tables are rarely updated. 
D) Data needs to be imported from separate sources. 
A) One table would otherwise not participate in a relationship. 
B) The tables create a Cartesian join. 
C) The tables are rarely updated. 
D) Data needs to be imported from separate sources.

Question 6

A query creates a Cartesian join between one table with 5 records and another table with 20 records. How many records are displayed in the results?

Accepted Answer

A) 100 
B) 25 
C) 15 
D) 4 
A) 100 
B) 25 
C) 15 
D) 4

Question 7

An E-R diagram uses diamonds to illustrate relationships between tables.

Accepted Answer

A) True 
 B)False

Question 8

When referential integrity is enforced on a one-to-many relationship in Access, you may not delete a record in the "one" table that has related records in the "many" table.

Accepted Answer

A) True 
 B)False

Question 9

Which properties do you set to display a list of possible values that are helpful when you enter or update data in a foreign key field?

Accepted Answer

A) Indexed properties 
B) Lookup properties 
C) Foreign Key List properties 
D) Subdatasheet properties 
A) Indexed properties 
B) Lookup properties 
C) Foreign Key List properties 
D) Subdatasheet properties

Question 10

In Database Design Language (DBDL), which items do you underline?

Accepted Answer

A) table names 
B) columns that make up the foreign key 
C) data types 
D) columns that make up the primary key 
A) table names 
B) columns that make up the foreign key 
C) data types 
D) columns that make up the primary key

Question 11

Which field in a table does Access index by default?

Accepted Answer

A) primary key field 
B) any numeric field 
C) first field in the table 
D) foreign key field 
A) primary key field 
B) any numeric field 
C) first field in the table 
D) foreign key field

Question 12

A query includes the DeptID and DeptName fields from the Departments table and the EmployeeLast field from the Employees table. Both tables are shown below. What happens when you update the DeptName field value for an employee? Departments (DeptID, DeptName)
Employees (EmpID, EmployeeFirst, EmployeeLast, DeptID)

Accepted Answer

A) Access displays an error message and does not accept the update. 
B) The DeptName field value changes for all employees in that department. 
C) The DeptName field value changes for that one employee only. 
D) Access changes the DeptID field value in the same record. 
A) Access displays an error message and does not accept the update. 
B) The DeptName field value changes for all employees in that department. 
C) The DeptName field value changes for that one employee only. 
D) Access changes the DeptID field value in the same record.

Question 13

A query includes the DeptID and DeptName fields from the Departments table and the EmployeeLast field from the Employees table. Both tables are shown below. What must you change before you can reassign the DeptID field value for a particular employee in the query results? Departments (DeptID, DeptName)
Employees (EmpID, EmployeeFirst, EmployeeLast, DeptID)

Accepted Answer

A) Set DeptID as the primary key field in the Employees table. 
B) Add the DeptName field to the query. 
C) Remove the EmpID field from the query. 
D) Replace the DeptID field from the Departments table with the DeptID field from the Employees table. 
A) Set DeptID as the primary key field in the Employees table. 
B) Add the DeptName field to the query. 
C) Remove the EmpID field from the query. 
D) Replace the DeptID field from the Departments table with the DeptID field from the Employees table.

Question 14

How would you set up a relationship between a table of Books and a table of Authors in a relational database?

Accepted Answer

One book can have many authors and one a

Question 15

Which of the following statements is not true about primary key fields?

Accepted Answer

A) The primary key field must participate in a one-to-many relationship. 
B) The primary key field contains unique data for each record in the table. 
C) The primary key field is automatically indexed. 
D) The primary key field is the linking field in the table on the "one" side of a one-to-many relationship. 
A) The primary key field must participate in a one-to-many relationship. 
B) The primary key field contains unique data for each record in the table. 
C) The primary key field is automatically indexed. 
D) The primary key field is the linking field in the table on the "one" side of a one-to-many relationship.

Question 16

In an entity-relationship model (ERM), what does a diamond represent?

Accepted Answer

A) the "one" part of the relationship 
B) the "many" part of the relationship 
C) the relationship 
D) an entity 
A) the "one" part of the relationship 
B) the "many" part of the relationship 
C) the relationship 
D) an entity

Question 17

What can you create in Access to show data in a single record and all its related records?

Accepted Answer

A) one-to-one relationship 
B) lookup reports 
C) form and subform 
D) related user views 
A) one-to-one relationship 
B) lookup reports 
C) form and subform 
D) related user views

Question 18

What is the purpose of an index?

Accepted Answer

A) to show which database objects depend on each other 
B) to identify primary, secondary, and alternate keys 
C) to improve database performance when queries request a sort order for records 
D) to store unique data for each record in the table 
A) to show which database objects depend on each other 
B) to identify primary, secondary, and alternate keys 
C) to improve database performance when queries request a sort order for records 
D) to store unique data for each record in the table

Question 19

A one-to-many relationship with _____ means that a record in the parent table must be established before a related record in the child table can be entered.

Accepted Answer

A) cardinality 
B) access restrictions 
C) referential integrity 
D) alternate keys 
A) cardinality 
B) access restrictions 
C) referential integrity 
D) alternate keys

Question 20

Which fields should you index in a table?

Accepted Answer

A) every field 
B) fields that are commonly used for sorting 
C) fields that contain sensitive data 
D) fields that are not part of a relationship 
A) every field 
B) fields that are commonly used for sorting 
C) fields that contain sensitive data 
D) fields that are not part of a relationship

How does the Access Relationships window indicate the "many" field in a one-to-many relationship?

Which of the following Access features does not demonstrate the power of one-to-many relationships?

What shape does an E-R diagram use to represent entities?

ProductType is a foreign key field in the Orders table and is constrained to a list of valid entries stored in the ProductTypes table. What problem does this design prevent?

Which of the following is a valid reason for creating a one-to-one relationship between two tables?

A query creates a Cartesian join between one table with 5 records and another table with 20 records. How many records are displayed in the results?

An E-R diagram uses diamonds to illustrate relationships between tables.

When referential integrity is enforced on a one-to-many relationship in Access, you may not delete a record in the "one" table that has related records in the "many" table.

Which properties do you set to display a list of possible values that are helpful when you enter or update data in a foreign key field?

In Database Design Language (DBDL), which items do you underline?

Which field in a table does Access index by default?

How would you set up a relationship between a table of Books and a table of Authors in a relational database?

Which of the following statements is not true about primary key fields?

In an entity-relationship model (ERM), what does a diamond represent?

What can you create in Access to show data in a single record and all its related records?

What is the purpose of an index?

A one-to-many relationship with _____ means that a record in the parent table must be established before a related record in the child table can be entered.

Which fields should you index in a table?

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters

Exam 4: The Relational Model: Advanced Topics

How does the Access Relationships window indicate the "many" field in a one-to-many relationship?

Which of the following Access features does not demonstrate the power of one-to-many relationships?

What shape does an E-R diagram use to represent entities?

ProductType is a foreign key field in the Orders table and is constrained to a list of valid entries stored in the ProductTypes table. What problem does this design prevent?

Which of the following is a valid reason for creating a one-to-one relationship between two tables?

A query creates a Cartesian join between one table with 5 records and another table with 20 records. How many records are displayed in the results?

An E-R diagram uses diamonds to illustrate relationships between tables.

When referential integrity is enforced on a one-to-many relationship in Access, you may not delete a record in the "one" table that has related records in the "many" table.

Which properties do you set to display a list of possible values that are helpful when you enter or update data in a foreign key field?

In Database Design Language (DBDL), which items do you underline?

Which field in a table does Access index by default?

How would you set up a relationship between a table of Books and a table of Authors in a relational database?

Which of the following statements is not true about primary key fields?

In an entity-relationship model (ERM), what does a diamond represent?

What can you create in Access to show data in a single record and all its related records?

What is the purpose of an index?

A one-to-many relationship with _____ means that a record in the parent table must be established before a related record in the child table can be entered.

Which fields should you index in a table?

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters