Question 1

A primary key field should never allow full values.

Accepted Answer

A) True 
 B)False

Question 2

Which Access tool provides details about each table, query, report, form, and other object in a database?

Accepted Answer

A) Relationship Report 
B) Database Optimizer 
C) Navigation Pane 
D) Database Documenter 
A) Relationship Report 
B) Database Optimizer 
C) Navigation Pane 
D) Database Documenter

Question 3

ClientID is the primary key field in the Clients table, which is related to the Projects table through its ClientID foreign key field. In Access, what option should you select to update the ClientID field values in the Projects table if the ClientID field values change in the Clients table?

Accepted Answer

A) Entity Integrity 
B) Cascade Update Related Fields 
C) Cascade Delete Related Records 
D) Validation Rule Property 
A) Entity Integrity 
B) Cascade Update Related Fields 
C) Cascade Delete Related Records 
D) Validation Rule Property

Question 4

When would you use the SQL RIGHT JOIN command?

Accepted Answer

A) to find unique field values 
B) to find matching records from three or more tables 
C) to find orphan records 
D) to find null values 
A) to find unique field values 
B) to find matching records from three or more tables 
C) to find orphan records 
D) to find null values

Question 5

Which of the following table events occurs after an existing record has been changed?

Accepted Answer

A) After Record 
B) On Change 
C) Before Update 
D) After Update 
A) After Record 
B) On Change 
C) Before Update 
D) After Update

Question 6

What does the INNER JOIN command select from related tables?

Accepted Answer

A) all records in the parent table even if they do not have matching records in the child table 
B) records that have matching values in both tables 
C) all records in the child table even if they do not have matching records in the parent table 
D) all records in both tables even if they do not have matching records 
A) all records in the parent table even if they do not have matching records in the child table 
B) records that have matching values in both tables 
C) all records in the child table even if they do not have matching records in the parent table 
D) all records in both tables even if they do not have matching records

Question 7

When you display the system tables in Access, where do they appear?

Accepted Answer

A) Navigation Pane 
B) Navigation Options dialog box 
C) System Catalog dialog box 
D) Database Tools tab of the ribbon 
A) Navigation Pane 
B) Navigation Options dialog box 
C) System Catalog dialog box 
D) Database Tools tab of the ribbon

Question 8

List five benefits or uses for views.

Accepted Answer

Benefits and uses of views include the f

Question 9

According to an article referenced by the Bureau of Labor Statistics, which of the following is a fundamental competency for a job in database administration?

Accepted Answer

A) CSS (Cascading Style Sheets) 
B) Oracle 
C) NoSQL 
D) Microsoft Outlook 
A) CSS (Cascading Style Sheets) 
B) Oracle 
C) NoSQL 
D) Microsoft Outlook

Question 10

What happens when you use the DROP TABLE command?

Accepted Answer

A) Access deletes the table structure and makes a backup copy of the data. 
B) Access deletes the table structure and the table data. 
C) Access deletes only the table data, but preserves the structure. 
D) Access requires a password to open the table. 
A) Access deletes the table structure and makes a backup copy of the data. 
B) Access deletes the table structure and the table data. 
C) Access deletes only the table data, but preserves the structure. 
D) Access requires a password to open the table.

A primary key field should never allow full values.

Which Access tool provides details about each table, query, report, form, and other object in a database?

ClientID is the primary key field in the Clients table, which is related to the Projects table through its ClientID foreign key field. In Access, what option should you select to update the ClientID field values in the Projects table if the ClientID field values change in the Clients table?

When would you use the SQL RIGHT JOIN command?

Which of the following table events occurs after an existing record has been changed?

What does the INNER JOIN command select from related tables?

When you display the system tables in Access, where do they appear?

List five benefits or uses for views.

According to an article referenced by the Bureau of Labor Statistics, which of the following is a fundamental competency for a job in database administration?

What happens when you use the DROP TABLE command?

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

A primary key field should never allow full values.

Which Access tool provides details about each table, query, report, form, and other object in a database?

ClientID is the primary key field in the Clients table, which is related to the Projects table through its ClientID foreign key field. In Access, what option should you select to update the ClientID field values in the Projects table if the ClientID field values change in the Clients table?

When would you use the SQL RIGHT JOIN command?

Which of the following table events occurs after an existing record has been changed?

What does the INNER JOIN command select from related tables?

When you display the system tables in Access, where do they appear?

List five benefits or uses for views.

According to an article referenced by the Bureau of Labor Statistics, which of the following is a fundamental competency for a job in database administration?

What happens when you use the DROP TABLE command?

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