Question 1

An audit trail of database changes is kept by a:

Accepted Answer

A)  change control device. 
B)  subschema. 
C)  before image. 
D)  journalizing facility. 
A)  change control device. 
B)  subschema. 
C)  before image. 
D)  journalizing facility.

Question 2

Open-source DBMS are ________ software that provides the core functionality of an SQL compliant DBMS.

Accepted Answer

free DBMS

Question 3

The data administrator takes responsibility for the overall management of data resources.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following functions model business rules?

Accepted Answer

A)  Database planning 
B)  Database analysis 
C)  Database design 
D)  Operations 
A)  Database planning 
B)  Database analysis 
C)  Database design 
D)  Operations

Question 5

Which of the following skills are required of a database administrator?

Accepted Answer

A)  Broad technical background 
B)  Solid understanding of hardware architectures 
C)  Managerial skills 
D)  All of the above 
A)  Broad technical background 
B)  Solid understanding of hardware architectures 
C)  Managerial skills 
D)  All of the above

Question 6

A DBMS may perform checkpoints automatically or in response to commands in user application programs.

Accepted Answer

A) True 
 B)False

Question 7

The role of a data warehouse administrator emphasizes integration and coordination of metadata and data across many data sources.

Accepted Answer

A) True 
 B)False

Question 8

What is backward and forward recovery?

Accepted Answer

Backward recovery,often called rollback,

Question 9

A credit-card sized plastic card with an embedded microprocessor chip with the ability to store,process and output electronic data in a secure manner is called a(n):

Accepted Answer

A)  smart chip. 
B)  smart card. 
C)  e-credit card. 
D)  secure card. 
A)  smart chip. 
B)  smart card. 
C)  e-credit card. 
D)  secure card.

Question 10

A device to measure or detect fingerprints or signatures is called a(n)________ device.

Accepted Answer

A)  biometric 
B)  view 
C)  ink 
D)  laser 
A)  biometric 
B)  view 
C)  ink 
D)  laser

Question 11

Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data.

Accepted Answer

A) True 
 B)False

Question 12

The ________ is a record of the essential data for each transaction that has been processed against the database.

Accepted Answer

The answer of The ________ is a record of the...

Question 13

What is a journalizing facility?

Accepted Answer

A journalizing facility provides an audi

Question 14

Which of the following threats involves outside parties using information to embarrass a company?

Accepted Answer

A)  Accidental loss 
B)  Theft and fraud 
C)  Loss of confidentiality 
D)  Loss of data integrity 
A)  Accidental loss 
B)  Theft and fraud 
C)  Loss of confidentiality 
D)  Loss of data integrity

Question 15

While views promote security by restricting user access to data,they are not adequate security measures because:

Accepted Answer

A)  an unauthorized person may gain access to a view through experimentation. 
B)  all users can read any view. 
C)  a view's data does not change. 
D)  none of the above. 
A)  an unauthorized person may gain access to a view through experimentation. 
B)  all users can read any view. 
C)  a view's data does not change. 
D)  none of the above.

Question 16

Which of the following is not a component of a repository system architecture?

Accepted Answer

A)  An informational model 
B)  The repository engine 
C)  A data transformation process 
D)  The repository database 
A)  An informational model 
B)  The repository engine 
C)  A data transformation process 
D)  The repository database

Question 17

What new trends and technologies have driven the need for changes in the data administration and database administration roles?

Accepted Answer

There have been several recent trends an

Question 18

A view can be built to present only the data to which a user requires access.

Accepted Answer

A) True 
 B)False

Question 19

What are integrity controls? Describe the different types.

Accepted Answer

Integrity controls protect data from una

Question 20

Controls incorporated into a data management system that restrict access to data are called ________.

Accepted Answer

The answer of Controls incorporated into a data management system...

An audit trail of database changes is kept by a:

Open-source DBMS are ________ software that provides the core functionality of an SQL compliant DBMS.

The data administrator takes responsibility for the overall management of data resources.

Which of the following functions model business rules?

Which of the following skills are required of a database administrator?

A DBMS may perform checkpoints automatically or in response to commands in user application programs.

The role of a data warehouse administrator emphasizes integration and coordination of metadata and data across many data sources.

What is backward and forward recovery?

A credit-card sized plastic card with an embedded microprocessor chip with the ability to store,process and output electronic data in a secure manner is called a(n):

A device to measure or detect fingerprints or signatures is called a(n)________ device.

Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data.

The ________ is a record of the essential data for each transaction that has been processed against the database.

What is a journalizing facility?

Which of the following threats involves outside parties using information to embarrass a company?

While views promote security by restricting user access to data,they are not adequate security measures because:

Which of the following is not a component of a repository system architecture?

What new trends and technologies have driven the need for changes in the data administration and database administration roles?

A view can be built to present only the data to which a user requires access.

What are integrity controls? Describe the different types.

Controls incorporated into a data management system that restrict access to data are called ________.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 11: Data and Database Administration

An audit trail of database changes is kept by a:

Open-source DBMS are ________ software that provides the core functionality of an SQL compliant DBMS.

The data administrator takes responsibility for the overall management of data resources.

Which of the following functions model business rules?

Which of the following skills are required of a database administrator?

A DBMS may perform checkpoints automatically or in response to commands in user application programs.

The role of a data warehouse administrator emphasizes integration and coordination of metadata and data across many data sources.

What is backward and forward recovery?

A credit-card sized plastic card with an embedded microprocessor chip with the ability to store,process and output electronic data in a secure manner is called a(n):

A device to measure or detect fingerprints or signatures is called a(n)________ device.

Authorization rules are controls incorporated in the data management system that restrict access to data and also restrict the actions that people may take when they access the data.

The ________ is a record of the essential data for each transaction that has been processed against the database.

What is a journalizing facility?

Which of the following threats involves outside parties using information to embarrass a company?

While views promote security by restricting user access to data,they are not adequate security measures because:

Which of the following is not a component of a repository system architecture?

What new trends and technologies have driven the need for changes in the data administration and database administration roles?

A view can be built to present only the data to which a user requires access.

What are integrity controls? Describe the different types.

Controls incorporated into a data management system that restrict access to data are called ________.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters