Question 1

Which Access feature restricts a field to a special format for entering data?

Accepted Answer

A) Validation Text property 
B) Input Mask 
C) Object Dependencies 
D) Lookup properties 
A) Validation Text property 
B) Input Mask 
C) Object Dependencies 
D) Lookup properties

Question 2

Which of the following is information that Access system catalogs do not maintain?

Accepted Answer

A) tables and fields included in the database 
B) properties of the relationships between tables 
C) indexed fields 
D) users, user groups, and privileges 
A) tables and fields included in the database 
B) properties of the relationships between tables 
C) indexed fields 
D) users, user groups, and privileges

Question 3

Explain how privacy and security are related and give two examples of federal requirements for keeping data private.

Accepted Answer

Privacy refers to the right of individua

Question 4

What type of database replication relies on centralized control that determines when replicas may be created and how they are synchronized with the master copy?

Accepted Answer

A) traditional database replication 
B) distributed database model 
C) local database model 
D) enterprise replication 
A) traditional database replication 
B) distributed database model 
C) local database model 
D) enterprise replication

Question 5

What Access tool can you use to find and fix corrupt data within a database?

Accepted Answer

A) Database Documenter 
B) Validation properties 
C) Compact and Repair 
D) Back Up Database 
A) Database Documenter 
B) Validation properties 
C) Compact and Repair 
D) Back Up Database

Question 6

The acronym CRUD stands for _____.

Accepted Answer

A) commit, recover, undo, and decrypt 
B) catalog, report, user, data 
C) create, read, update, and delete 
D) credentials, read-only, unique, double 
A) commit, recover, undo, and decrypt 
B) catalog, report, user, data 
C) create, read, update, and delete 
D) credentials, read-only, unique, double

Question 7

In an enterprise-level DBMS, each task that a user completes, such as selecting a product for an order, is called a _____.

Accepted Answer

A) snapshot 
B) replica 
C) transaction 
D) branch 
A) snapshot 
B) replica 
C) transaction 
D) branch

Question 8

A(n) _____ contains software components that are well documented and have a proven track record of working well together.

Accepted Answer

A) solution stack 
B) web app 
C) enterprise-level system 
D) HTTP method 
A) solution stack 
B) web app 
C) enterprise-level system 
D) HTTP method

Question 9

Which of the following is not a common service provided by a database management system?

Accepted Answer

A) Update and retrieve data. 
B) Provide catalog services. 
C) Recover data. 
D) Format user views, forms, and reports. 
A) Update and retrieve data. 
B) Provide catalog services. 
C) Recover data. 
D) Format user views, forms, and reports.

Question 10

In Microsoft Access, you can identify all the objects that depend on a particular query, as well as all the objects that the query depends on.

Accepted Answer

A) True 
 B)False

Which Access feature restricts a field to a special format for entering data?

Which of the following is information that Access system catalogs do not maintain?

Explain how privacy and security are related and give two examples of federal requirements for keeping data private.

What type of database replication relies on centralized control that determines when replicas may be created and how they are synchronized with the master copy?

What Access tool can you use to find and fix corrupt data within a database?

The acronym CRUD stands for _____.

In an enterprise-level DBMS, each task that a user completes, such as selecting a product for an order, is called a _____.

A(n) _____ contains software components that are well documented and have a proven track record of working well together.

Which of the following is not a common service provided by a database management system?

In Microsoft Access, you can identify all the objects that depend on a particular query, as well as all the objects that the query depends on.

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters

Exam 3: The Relational Model: SQL

Which Access feature restricts a field to a special format for entering data?

Which of the following is information that Access system catalogs do not maintain?

Explain how privacy and security are related and give two examples of federal requirements for keeping data private.

What type of database replication relies on centralized control that determines when replicas may be created and how they are synchronized with the master copy?

What Access tool can you use to find and fix corrupt data within a database?

The acronym CRUD stands for _____.

In an enterprise-level DBMS, each task that a user completes, such as selecting a product for an order, is called a _____.

A(n) _____ contains software components that are well documented and have a proven track record of working well together.

Which of the following is not a common service provided by a database management system?

In Microsoft Access, you can identify all the objects that depend on a particular query, as well as all the objects that the query depends on.

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters