Question 1

There are two principal types of authorization tables: one for subjects and one for facts.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is a principal type of authorization table?

Accepted Answer

A)  Subject 
B)  Transaction 
C)  View 
D)  Index 
A)  Subject 
B)  Transaction 
C)  View 
D)  Index

Question 3

What are integrity controls? Describe the different types.

Accepted Answer

Integrity controls protect data from una

Question 4

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

Accepted Answer

A)  elusive query 
B)  performance test 
C)  heartbeat query 
D)  HTML 
A)  elusive query 
B)  performance test 
C)  heartbeat query 
D)  HTML

Question 5

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

Accepted Answer

A)  data warehouse administrator 
B)  database administrator 
C)  data administrator 
D)  data architect 
A)  data warehouse administrator 
B)  database administrator 
C)  data administrator 
D)  data architect

Question 6

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 7

What is the difference between shared locks and exclusive locks?

Accepted Answer

Shared locks allow other transactions to

Question 8

Most data outages in organizations are caused by:

Accepted Answer

A)  hardware failures. 
B)  software failures. 
C)  human error. 
D)  electrical outages. 
A)  hardware failures. 
B)  software failures. 
C)  human error. 
D)  electrical outages.

Question 9

Field-level locks are used quite often.

Accepted Answer

A) True 
 B)False

Question 10

The process of managing simultaneous operations against a database so that data integrity is maintained is called completeness control.

Accepted Answer

A) True 
 B)False

Question 11

The W3C standard for Web privacy is called:

Accepted Answer

A)  the Web privacy act. 
B)  Platform for Privacy Preferences. 
C)  Freedom of Web Information Act. 
D)  the Magna Carta. 
A)  the Web privacy act. 
B)  Platform for Privacy Preferences. 
C)  Freedom of Web Information Act. 
D)  the Magna Carta.

Question 12

Most data outages in organizations are caused by hardware failures.

Accepted Answer

A) True 
 B)False

Question 13

Specifications for transactions do not need to be reviewed quickly.

Accepted Answer

A) True 
 B)False

Question 14

The role of database administration is typically a more hands-on, physical involvement with the management of databases.

Accepted Answer

A) True 
 B)False

Question 15

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)  Random password guessing 
A)  Authentication of the client workstation 
B)  Password naming conventions 
C)  Guidelines for frequency of password changes 
D)  Random password guessing

Question 16

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 17

Two-phase locking results in a growing phase where locks are acquired and a shrinking phase where locks are released.

Accepted Answer

A) True 
 B)False

Question 18

The repository information model defines types, which should be easy to extend.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

An information repository supplies information:

Accepted Answer

A)  to database programmers only. 
B)  to only internal sources. 
C)  to database management systems. 
D)  exclusively to data lakes. 
A)  to database programmers only. 
B)  to only internal sources. 
C)  to database management systems. 
D)  exclusively to data lakes.

There are two principal types of authorization tables: one for subjects and one for facts.

Which of the following is a principal type of authorization table?

What are integrity controls? Describe the different types.

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

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

Which of the following functions model business rules?

What is the difference between shared locks and exclusive locks?

Most data outages in organizations are caused by:

Field-level locks are used quite often.

The process of managing simultaneous operations against a database so that data integrity is maintained is called completeness control.

The W3C standard for Web privacy is called:

Most data outages in organizations are caused by hardware failures.

Specifications for transactions do not need to be reviewed quickly.

The role of database administration is typically a more hands-on, physical involvement with the management of databases.

Which of the following is a type of network security?

Controls designed to restrict access and activities are called:

Two-phase locking results in a growing phase where locks are acquired and a shrinking phase where locks are released.

The repository information model defines types, which should be easy to extend.

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

An information repository supplies information:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

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

Big Data and Analytics

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 12: Data and Database Administration

There are two principal types of authorization tables: one for subjects and one for facts.

Which of the following is a principal type of authorization table?

What are integrity controls? Describe the different types.

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

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

Which of the following functions model business rules?

What is the difference between shared locks and exclusive locks?

Most data outages in organizations are caused by:

Field-level locks are used quite often.

The process of managing simultaneous operations against a database so that data integrity is maintained is called completeness control.

The W3C standard for Web privacy is called:

Most data outages in organizations are caused by hardware failures.

Specifications for transactions do not need to be reviewed quickly.

The role of database administration is typically a more hands-on, physical involvement with the management of databases.

Which of the following is a type of network security?

Controls designed to restrict access and activities are called:

Two-phase locking results in a growing phase where locks are acquired and a shrinking phase where locks are released.

The repository information model defines types, which should be easy to extend.

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

An information repository supplies information:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

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

Big Data and Analytics

Distributed Databases

Object-Oriented Data Modeling

Filters