Question 1

In Access Table Datasheet View, how can you display the records from a related table?

Accepted Answer

A) Click the Lookup button on the ribbon. 
B) Click the Related Records button on the ribbon. 
C) Right-click a field and then click Relationships on the shortcut menu. 
D) Click the expand button to expand a subdatasheet. 
A) Click the Lookup button on the ribbon. 
B) Click the Related Records button on the ribbon. 
C) Right-click a field and then click Relationships on the shortcut menu. 
D) Click the expand button to expand a subdatasheet. D

Question 2

Which of the following items is not identified in relational database design documentation?

Accepted Answer

A) primary key field for each entity 
B) possible user views for each entity 
C) proper one-to-many relationships between the entities 
D) attributes needed for each normalized entity 
A) primary key field for each entity 
B) possible user views for each entity 
C) proper one-to-many relationships between the entities 
D) attributes needed for each normalized entity B

Question 3

Which of the following tools does not help you document relationships between tables?

Accepted Answer

A) Database Design Language 
B) user views 
C) entity-relationship diagram 
D) entity-relationship model 
A) Database Design Language 
B) user views 
C) entity-relationship diagram 
D) entity-relationship model B

Question 4

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 5

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 6

A _____ serves on the "many" side of a one-to-many relationship with each of two other tables.

Accepted Answer

A) secondary key 
B) junction table 
C) lookup table 
D) connecting table 
A) secondary key 
B) junction table 
C) lookup table 
D) connecting table

Question 7

When two tables in a query share no common fields, each record in one table connects to each record in the other table, creating a(n) _____.

Accepted Answer

A) many-to-many relationship 
B) one-to-one relationship 
C) outer join 
D) Cartesian join 
A) many-to-many relationship 
B) one-to-one relationship 
C) outer join 
D) Cartesian join

Question 8

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 9

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 10

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 11

In an entity-relationship model (ERM), what information appears in ovals?

Accepted Answer

A) entities 
B) attributes 
C) relationships 
D) dependencies 
A) entities 
B) attributes 
C) relationships 
D) dependencies

Question 12

Building the entities, attributes, constraints, and relationships in a particular RDBMS is called the _____.

Accepted Answer

A) information-level design 
B) conceptual design 
C) entity-relationship (E-R) design 
D) physical-level design 
A) information-level design 
B) conceptual design 
C) entity-relationship (E-R) design 
D) physical-level design

Question 13

Define the types of cardinality in a database and explain the cardinality of primary keys and foreign keys.

Accepted Answer

In a database, cardinality refers to the

Question 14

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 15

Which of the following is a type of E-R diagram?

Accepted Answer

A) Access Database Documenter 
B) crow's foot notation 
C) entity tree notation 
D) Database Design Language (DBDL) 
A) Access Database Documenter 
B) crow's foot notation 
C) entity tree notation 
D) Database Design Language (DBDL)

Question 16

How could you determine the relationship between a table of Consultants and a table of Projects at a consulting firm?

Accepted Answer

Work with the consulting firm to determi

Question 17

When you build a relational database for an organization, what is a good starting point for identifying required user views?

Accepted Answer

A) Collect the organization's forms and reports. 
B) Video each user. 
C) Conduct a detailed survey. 
D) Attend staff meetings. 
A) Collect the organization's forms and reports. 
B) Video each user. 
C) Conduct a detailed survey. 
D) Attend staff meetings.

Question 18

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 19

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

Question 20

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

In Access Table Datasheet View, how can you display the records from a related table?

Which of the following items is not identified in relational database design documentation?

Which of the following tools does not help you document relationships between tables?

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

A user view of data is _____.

A _____ serves on the "many" side of a one-to-many relationship with each of two other tables.

When two tables in a query share no common fields, each record in one table connects to each record in the other table, creating a(n) _____.

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

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.

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

In an entity-relationship model (ERM), what information appears in ovals?

Building the entities, attributes, constraints, and relationships in a particular RDBMS is called the _____.

Define the types of cardinality in a database and explain the cardinality of primary keys and foreign keys.

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

Which of the following is a type of E-R diagram?

How could you determine the relationship between a table of Consultants and a table of Projects at a consulting firm?

When you build a relational database for an organization, what is a good starting point for identifying required user views?

How might you resolve an inappropriate Cartesian join?

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

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

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

In Access Table Datasheet View, how can you display the records from a related table?

Which of the following items is not identified in relational database design documentation?

Which of the following tools does not help you document relationships between tables?

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

A user view of data is _____.

A _____ serves on the "many" side of a one-to-many relationship with each of two other tables.

When two tables in a query share no common fields, each record in one table connects to each record in the other table, creating a(n) _____.

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

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.

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

In an entity-relationship model (ERM), what information appears in ovals?

Building the entities, attributes, constraints, and relationships in a particular RDBMS is called the _____.

Define the types of cardinality in a database and explain the cardinality of primary keys and foreign keys.

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

Which of the following is a type of E-R diagram?

How could you determine the relationship between a table of Consultants and a table of Projects at a consulting firm?

When you build a relational database for an organization, what is a good starting point for identifying required user views?

How might you resolve an inappropriate Cartesian join?

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

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

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