Question 1

First normal form refers to ____.
A) redundant data in an original table that is extracted, placed in a new table, and related to the first table
B) derived fields that are removed
C) a 2-dimensional table with rows and columns
D) calculated fields that are removed

Accepted Answer

First normal form (1NF) requires the elimination of repeating groups of data and the creation of a 2-dimensional table structure with rows and columns. Redundant data, derived fields, and calculated fields are not necessarily in violation of 1NF.

Question 2

A ____ relationship cannot be created directly between two tables in Access.
A) one-to-one
B) one-to-many
C) many-to-many
D) all three types can be directly created with two tables in Access

Accepted Answer

A many-to-many relationship requires a junction table to connect the two tables, so it cannot be created directly between two tables in Access. One-to-one and one-to-many relationships can be directly created between two tables in Access.

Question 3

You should strive to create databases that use ____ rules for normalization.
A) zero normal form
B) first normal form
C) second normal form
D) third normal form

Accepted Answer

Third normal form is the best choice for database normalization as it eliminates all functional dependencies between non-key attributes and ensures that every attribute in a table is functionally dependent on the primary key. This results in a more efficient and consistent database with less redundancy and potential for data anomalies.

Question 4

Use Variable Text fields when you need to store more than 256 characters in a field. ____________________

Accepted Answer

The answer of Use Variable Text fields when you need...

Question 5

A switchback form is a special form used to help users navigate throughout the rest of the database.

Accepted Answer

switchboard

Question 6

A normalized database decreases ____.
A) the ability to create reports
B) database performance (speed)
C) the ability to create queries
D) inaccurate data

Accepted Answer

The answer of A normalized database decreases ____.
A) the ability...

Question 7

Normalizing data means ____.
A) analyzing database performance
B) structuring it for a relational database
C) creating clear and logical data entry forms
D) repeating data between two tables

Accepted Answer

Normalizing data means structuring it for a relational database in a way that reduces redundancy and inconsistencies. This involves breaking down tables into smaller, more specialized ones and establishing relationships between them. Analyzing database performance and creating clear data entry forms are important, but they are not the main objectives of data normalization. Repeating data between two tables goes against the principles of normalization, as it can lead to data inconsistencies and inefficiencies.

Question 8

A right join is the default join between two tables in an Access query. _________________________

Accepted Answer

In Access, the default join between two tables is an inner join, not a right join.

Question 9

When you use the LookupWizard, you create both a one-to-many relationship and entity integrity. ____________________

Accepted Answer

The Lookup Wizard in databases like Microsoft Access helps create a lookup field, which allows users to select a value from another table, but it does not automatically establish a one-to-many relationship or ensure entity integrity.

Question 10

The Allow Multiple Values property is found on the _____tab in Table Design View.
A) Lookup
B) Field Properties
C) Data Type
D) List Box

Accepted Answer

The Allow Multiple Values property is found on the Lookup tab in Table Design View in Microsoft Access.

Question 11

Checking the Cascade Delete Related Fields check box means that if you delete a record in the table on the "one" side of a one-to-many relationship, all related records in the "many" table automatically delete as well. ____________________

Accepted Answer

Cascade Delete ensures that when a record in the "one" side of a one-to-many relationship is deleted, all corresponding records in the "many" side are also deleted to maintain referential integrity.

Question 12

Use the Rich Text field data type when you need to store more than 256 characters in a field. _________________________

Accepted Answer

Long

Question 13

Press and hold the [ Ctrl ] key while opening a database to bypass the startup options. ____________________

Accepted Answer

The answer of Press and hold the [ Ctrl ]...

Question 14

Northwind is provided by Microsoft as a(n) ____.
A) Help screen
B) attachment field
C) sample database template
D) online tutorial

Accepted Answer

Northwind is a sample database template provided by Microsoft to demonstrate database features and functionalities.

Question 15

Use Is Empty criteria in a query to select records where there is no entry in a field. _________________________

Accepted Answer

Null

Question 16

Two tables have a ____ relationship when they are both related to the same intermediate table with one-to-many relationships.
A) one-to-one
B) one-to-many
C) many-to-one
D) many-to-many

Accepted Answer

When two tables are related to the same intermediate table via one-to-many relationships, they have a many-to-many relationship with each other. The intermediate table acts as a connector between the two tables, allowing for many instances of one table to be related to many instances of the other table.

Question 17

With join operations " right " always refers to the "one" table of a one-to-many relationship. ____________________

Accepted Answer

In SQL, "right" in a join operation refers to the table on the right side of the join clause, not specifically to the "one" table in a one-to-many relationship.

Question 18

Checking the Automatically Update Related Fields check box means that if you change the primary key field value in the table on the "one" side of a one-to-many relationship, all foreign key values in the "many" table automatically update as well. ____________________

Accepted Answer

The answer of Checking the Automatically Update Related Fields check...

Question 19

Second normal form means ____.
A) calculated fields are removed
B) redundant data is extracted into a new table
C) totals are removed
D) a single table with rows and columns

Accepted Answer

Second normal form (2NF) requires that all non-key attributes of a table depend only on the primary key, and not on any other attributes. To meet this requirement, if a table has attributes that depend on only part of the primary key, those attributes must be extracted into a new table, along with the subset of the primary key on which they depend, to create a new table with a distinct primary key. This eliminates redundancy and ensures data integrity. Calculated fields and totals are not directly related to normal forms, and a single table with rows and columns is a general characteristic of a database table, but not specific to 2NF.

Question 20

The default join type for a query with two tables in a one-to-many relationship is the outer join. _________________________

Accepted Answer

inner

Quiz 16: Completing a Database Application

First normal form refers to ____.

A ____ relationship cannot be created directly between two tables in Access.

You should strive to create databases that use ____ rules for normalization.

Use Variable Text fields when you need to store more than 256 characters in a field. ____________________

A switchback form is a special form used to help users navigate throughout the rest of the database.

A normalized database decreases ____.

Normalizing data means ____.

A right join is the default join between two tables in an Access query. _________________________

When you use the LookupWizard, you create both a one-to-many relationship and entity integrity. ____________________

The Allow Multiple Values property is found on the _____tab in Table Design View.