Question 1

Which of the following Access features provides a drop-down list of values for a field?

Accepted Answer

A)  subdatasheet 
B)  lookup field 
C)  subform 
D)  Relationship report 
A)  subdatasheet 
B)  lookup field 
C)  subform 
D)  Relationship report B

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

During which process do you typically create an entity-relationship (E-R) diagram?

Accepted Answer

A)  physical-level design 
B)  troubleshooting user views 
C)  information-level design 
D)  maintenance 
A)  physical-level design 
B)  troubleshooting user views 
C)  information-level design 
D)  maintenance C

Question 4

How might you resolve an inappropriate Cartesian join?

Accepted Answer

A)  Convert the join type to a RIGHT join. 
B)  Connect the two tables through a third junction table. 
C)  Convert the join type to a LEFT join. 
D)  Change the query to an update query. 
A)  Convert the join type to a RIGHT join. 
B)  Connect the two tables through a third junction table. 
C)  Convert the join type to a LEFT join. 
D)  Change the query to an update query.

Question 5

Explain the difference between information-level design and physical-level design.

Accepted Answer

During information-level design, you lis

Question 6

The E-R model (ERM) represents entities, attributes, and _____.

Accepted Answer

A)  indexes 
B)  views 
C)  properties 
D)  relationships 
A)  indexes 
B)  views 
C)  properties 
D)  relationships

Question 7

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 8

What type of relationship do two tables have when their primary keys match?

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  many-to-one 
A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  many-to-one

Question 9

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 10

When the Unique property for an index is set to Yes in Access, every value in the index must be unique.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Question 13

Describe the different types of keys illustrated in Database Design Language (DBDL) and how they are notated.

Accepted Answer

The primary key field contains unique da

Question 14

A user view of data is _____.

Accepted Answer

A)  a table created by a particular user 
B)  a report requested by users 
C)  the specific data needed by a person or process for a particular task 
D)  a form used for data entry 
A)  a table created by a particular user 
B)  a report requested by users 
C)  the specific data needed by a person or process for a particular task 
D)  a form used for data entry

Question 15

A(n) _____ represents a field or combination of fields that may not be unique, but is commonly used for retrieval and thus should be indexed.

Accepted Answer

A)  alternate key 
B)  combo key 
C)  secondary key 
D)  indexed key 
A)  alternate key 
B)  combo key 
C)  secondary key 
D)  indexed key

Question 16

Information-level design is independent of any particular DBMS that the organization will ultimately use.

Accepted Answer

A) True 
 B)False

Question 17

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 18

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 19

Which of the following is not true about one-to-many relationships?

Accepted Answer

A)  The linking field in the "one" table is always the primary key field for that table. 
B)  A foreign key field cannot also be the primary key field for a particular table. 
C)  The linking field must have the same name in the primary and related tables. 
D)  One record in the "one" table can be linked or related to many records in the "many" table. 
A)  The linking field in the "one" table is always the primary key field for that table. 
B)  A foreign key field cannot also be the primary key field for a particular table. 
C)  The linking field must have the same name in the primary and related tables. 
D)  One record in the "one" table can be linked or related to many records in the "many" table.

Question 20

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

Which of the following Access features provides a drop-down list of values for a field?

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

During which process do you typically create an entity-relationship (E-R) diagram?

How might you resolve an inappropriate Cartesian join?

Explain the difference between information-level design and physical-level design.

The E-R model (ERM) represents entities, attributes, and _____.

What is the purpose of an index?

What type of relationship do two tables have when their primary keys match?

When the Unique property for an index is set to Yes in Access, every value in the index must be unique.

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

Which fields should you index in a table?

Describe the different types of keys illustrated in Database Design Language (DBDL) and how they are notated.

A user view of data is _____.

A(n) _____ represents a field or combination of fields that may not be unique, but is commonly used for retrieval and thus should be indexed.

Information-level design is independent of any particular DBMS that the organization will ultimately use.

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?

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 not true about one-to-many relationships?

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

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 Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters

Exam 6: Database Design: Relationships

Which of the following Access features provides a drop-down list of values for a field?

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

During which process do you typically create an entity-relationship (E-R) diagram?

How might you resolve an inappropriate Cartesian join?

Explain the difference between information-level design and physical-level design.

The E-R model (ERM) represents entities, attributes, and _____.

What is the purpose of an index?

What type of relationship do two tables have when their primary keys match?

When the Unique property for an index is set to Yes in Access, every value in the index must be unique.

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

Which fields should you index in a table?

Describe the different types of keys illustrated in Database Design Language (DBDL) and how they are notated.

A user view of data is _____.

A(n) _____ represents a field or combination of fields that may not be unique, but is commonly used for retrieval and thus should be indexed.

Information-level design is independent of any particular DBMS that the organization will ultimately use.

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?

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 not true about one-to-many relationships?

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

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 Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters