Question 1

Which of the following functions do cost/benefit models?

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 2

A(n)________ is an impasse that results when two or more transactions have locked a common resource,and each waits for the other to unlock that resource.

Accepted Answer

The answer of A(n)________ is an impasse that results when...

Question 3

The extent of the database resource that is included with each lock is called the level of:

Accepted Answer

A)  impact. 
B)  management. 
C)  lock granularity. 
D)  none of the above. 
A)  impact. 
B)  management. 
C)  lock granularity. 
D)  none of the above.

Question 4

Controls designed to restrict access and activities are called:

Accepted Answer

A)  schemas. 
B)  business rules. 
C)  encryption controls. 
D)  authorization rules. 
A)  schemas. 
B)  business rules. 
C)  encryption controls. 
D)  authorization rules.

Question 5

Which of the following is a type of network security:

Accepted Answer

A)  authentication of the client workstation. 
B)  password naming conventions. 
C)  guidelines for frequency of password changes. 
D)  all of the above. 
A)  authentication of the client workstation. 
B)  password naming conventions. 
C)  guidelines for frequency of password changes. 
D)  all of the above.

Question 6

A ________ is a query submitted by a DBA to test the current performance of a database or to predict the response time for queries.

Accepted Answer

The answer of A ________ is a query submitted by...

Question 7

A data warehouse administrator has which of the following responsibilities?

Accepted Answer

A)  Build and administer an environment supportive of decision-support applications 
B)  Build a stable architecture for the data warehouse 
C)  Develop service level agreements with suppliers and consumers of data for the data warehouse 
D)  All of the above 
A)  Build and administer an environment supportive of decision-support applications 
B)  Build a stable architecture for the data warehouse 
C)  Develop service level agreements with suppliers and consumers of data for the data warehouse 
D)  All of the above

Question 8

The logical beginning and end of a transaction is called a ________.

Accepted Answer

transactio

Question 9

Backward recovery starts with an earlier copy of the database.

Accepted Answer

A) True 
 B)False

Question 10

Correct installation of the DBMS product is essential to any environment.

Accepted Answer

A) True 
 B)False

Question 11

A(n)________ stores metadata about an organization's data and data processing resources.

Accepted Answer

A)  DBA 
B)  information repository 
C)  organizational system catalog 
D)  data dictionary 
A)  DBA 
B)  information repository 
C)  organizational system catalog 
D)  data dictionary

Question 12

Allocating 10 percent over suggested installation space is sufficient for a DBMS.

Accepted Answer

A) True 
 B)False

Question 13

A(n)________ prevents another transaction from reading and therefore updating a record until it is unlocked.

Accepted Answer

A)  record controller 
B)  exclusive lock 
C)  authorization rule 
D)  shared lock 
A)  record controller 
B)  exclusive lock 
C)  authorization rule 
D)  shared lock

Question 14

Three-factor authentication is most often implemented with a credit card.

Accepted Answer

A) True 
 B)False

Question 15

Specifying database access policies is done during the ________ phase.

Accepted Answer

database i

Question 16

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

Accepted Answer

data wareh

Question 17

Optimistic concurrency control,or ________,restricts each transaction to a view of the database as of the time that the transaction was started.

Accepted Answer

The answer of Optimistic concurrency control,or ________,restricts each transaction to...

Question 18

An open-source DBMS is:

Accepted Answer

A)  a free source-code RBMS that provides the functionality of an SQL-compliant DBMS. 
B)  a beta release of a commercial RDBMS. 
C)  an object-oriented database management system. 
D)  source code for a commercial RDBMS. 
A)  a free source-code RBMS that provides the functionality of an SQL-compliant DBMS. 
B)  a beta release of a commercial RDBMS. 
C)  an object-oriented database management system. 
D)  source code for a commercial RDBMS.

Question 19

A business transaction is a sequence of steps that constitute some well-defined business activity.

Accepted Answer

A) True 
 B)False

Question 20

The Information Resource Lexicon System (IRLS)is a computer software tool used to manage and control access to the information repository.

Accepted Answer

A) True 
 B)False

Which of the following functions do cost/benefit models?

A(n)________ is an impasse that results when two or more transactions have locked a common resource,and each waits for the other to unlock that resource.

The extent of the database resource that is included with each lock is called the level of:

Controls designed to restrict access and activities are called:

Which of the following is a type of network security:

A ________ is a query submitted by a DBA to test the current performance of a database or to predict the response time for queries.

A data warehouse administrator has which of the following responsibilities?

The logical beginning and end of a transaction is called a ________.

Backward recovery starts with an earlier copy of the database.

Correct installation of the DBMS product is essential to any environment.

A(n)________ stores metadata about an organization's data and data processing resources.

Allocating 10 percent over suggested installation space is sufficient for a DBMS.

A(n)________ prevents another transaction from reading and therefore updating a record until it is unlocked.

Three-factor authentication is most often implemented with a credit card.

Specifying database access policies is done during the ________ phase.

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

Optimistic concurrency control,or ________,restricts each transaction to a view of the database as of the time that the transaction was started.

An open-source DBMS is:

A business transaction is a sequence of steps that constitute some well-defined business activity.

The Information Resource Lexicon System (IRLS)is a computer software tool used to manage and control access to the information repository.

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

Which of the following functions do cost/benefit models?

A(n)________ is an impasse that results when two or more transactions have locked a common resource,and each waits for the other to unlock that resource.

The extent of the database resource that is included with each lock is called the level of:

Controls designed to restrict access and activities are called:

Which of the following is a type of network security:

A ________ is a query submitted by a DBA to test the current performance of a database or to predict the response time for queries.

A data warehouse administrator has which of the following responsibilities?

The logical beginning and end of a transaction is called a ________.

Backward recovery starts with an earlier copy of the database.

Correct installation of the DBMS product is essential to any environment.

A(n)________ stores metadata about an organization's data and data processing resources.

Allocating 10 percent over suggested installation space is sufficient for a DBMS.

A(n)________ prevents another transaction from reading and therefore updating a record until it is unlocked.

Three-factor authentication is most often implemented with a credit card.

Specifying database access policies is done during the ________ phase.

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

Optimistic concurrency control,or ________,restricts each transaction to a view of the database as of the time that the transaction was started.

An open-source DBMS is:

A business transaction is a sequence of steps that constitute some well-defined business activity.

The Information Resource Lexicon System (IRLS)is a computer software tool used to manage and control access to the information repository.

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