Question 1

Concurrent processing of a database only poses problems when two or more processes attempt to use the same data.

Accepted Answer

A) True 
 B)False  True

Question 2

Breaking hardware,power outages,and human mistakes are all reasons that ________.

Accepted Answer

computers fail; computer systems fail

Question 3

Briefly define the three problems that can occur because of concurrent processing that are addressed by resource locking.

Accepted Answer

The three problems that can occur because of concurrent processing are dirty reads,nonrepeatable reads,and phantom reads.A dirty read occurs when a transaction reads a changed record that has not been committed to the database.If the change is cancelled before it is committed,then the read will contain incorrect data.A nonrepeatable read occurs when a transaction rereads data and finds modifications or deletions caused by another transaction.A phantom read occurs when a transaction rereads data and finds new rows that were inserted by another transaction since the prior read.

Question 4

Two-phase locking can be used to ensure that transactions are serializable.

Accepted Answer

A) True 
 B)False

Question 5

What concurrent processing problem occurs when a transaction rereads data and finds new rows that were inserted by a different transaction since the prior read?

Accepted Answer

A)  Nonrepeatable reads 
B)  Phantom reads 
C)  Dirty reads 
D)  Serialized reads 
E)  Unlocked reads 
A)  Nonrepeatable reads 
B)  Phantom reads 
C)  Dirty reads 
D)  Serialized reads 
E)  Unlocked reads

Question 6

When Microsoft Access 2016 creates a signed package with a digital signature,the database file will be a(n)________.

Accepted Answer

A)  *.accdb file 
B)  *.accdc file 
C)  *.accde file 
D)  *.mdb file 
E)  *.mdw file 
A)  *.accdb file 
B)  *.accdc file 
C)  *.accde file 
D)  *.mdb file 
E)  *.mdw file

Question 7

When a transaction functions in such a way that either all of the transaction actions are completed or none of them will be,the transaction is said to be ________.

Accepted Answer

A)  consistent 
B)  isolated 
C)  atomic 
D)  locked 
E)  logical 
A)  consistent 
B)  isolated 
C)  atomic 
D)  locked 
E)  logical

Question 8

With optimistic locking,locks are first issued,then the transaction is processed,and then the locks are released.

Accepted Answer

A) True 
 B)False

Question 9

When Microsoft Access 2016 uses user-level security with an Access 2003 file,the database is stored in a(n)*.accdb file.

Accepted Answer

A) True 
 B)False

Question 10

Computer systems fail for which of the following reasons except?

Accepted Answer

A)  Hardware breaks. 
B)  Electrical power fails. 
C)  Programs have bugs. 
D)  Databases randomly changed field values. 
E)  People make mistakes. 
A)  Hardware breaks. 
B)  Electrical power fails. 
C)  Programs have bugs. 
D)  Databases randomly changed field values. 
E)  People make mistakes.

Question 11

Why do computers fail?

Accepted Answer

Computers fail for a variety o

Question 12

Only large database systems have a need for database administration.

Accepted Answer

A) True 
 B)False

Question 13

Standard SQL defines four ________,which specify which of the concurrency control problems are allowed to occur.

Accepted Answer

The answer of Standard SQL defines four ________,which specify which...

Question 14

Database security is easy to achieve since all security is handled by the DBMS,which is a single point of entry into the database.

Accepted Answer

A) True 
 B)False

Question 15

One way to prevent concurrent processing problems is to lock data that are retrieved for update.

Accepted Answer

A) True 
 B)False

Question 16

Preventing multiple applications from obtaining copies of the same record when the record is about to be changed is called ________.

Accepted Answer

A)  serialized reading 
B)  lost updating 
C)  concurrent processing 
D)  resource locking 
E)  block factoring 
A)  serialized reading 
B)  lost updating 
C)  concurrent processing 
D)  resource locking 
E)  block factoring

Question 17

The purpose of concurrency control is to ensure that one user's work does not inappropriately influence another user's work.

Accepted Answer

A) True 
 B)False

Question 18

Microsoft Access 2016 can secure databases by using ________ to encrypt and decrypt the database files.

Accepted Answer

The answer of Microsoft Access 2016 can secure databases by...

Question 19

When Microsoft Access 2016 uses user-level security with an Access 2003 file,the database is stored in a(n)________.

Accepted Answer

A)  *.accdb file 
B)  *.accdc file 
C)  *.accde file 
D)  *.mdb file 
E)  *.mdw file 
A)  *.accdb file 
B)  *.accdc file 
C)  *.accde file 
D)  *.mdb file 
E)  *.mdw file

Question 20

The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as ________.

Accepted Answer

A)  reprocessing 
B)  rollback 
C)  transaction logging 
D)  rollforward 
E)  checkpointing 
A)  reprocessing 
B)  rollback 
C)  transaction logging 
D)  rollforward 
E)  checkpointing

Concurrent processing of a database only poses problems when two or more processes attempt to use the same data.

Breaking hardware,power outages,and human mistakes are all reasons that ________.

Briefly define the three problems that can occur because of concurrent processing that are addressed by resource locking.

Two-phase locking can be used to ensure that transactions are serializable.

What concurrent processing problem occurs when a transaction rereads data and finds new rows that were inserted by a different transaction since the prior read?

When Microsoft Access 2016 creates a signed package with a digital signature,the database file will be a(n)________.

When a transaction functions in such a way that either all of the transaction actions are completed or none of them will be,the transaction is said to be ________.

With optimistic locking,locks are first issued,then the transaction is processed,and then the locks are released.

When Microsoft Access 2016 uses user-level security with an Access 2003 file,the database is stored in a(n)*.accdb file.

Computer systems fail for which of the following reasons except?

Why do computers fail?

Only large database systems have a need for database administration.

Standard SQL defines four ________,which specify which of the concurrency control problems are allowed to occur.

Database security is easy to achieve since all security is handled by the DBMS,which is a single point of entry into the database.

One way to prevent concurrent processing problems is to lock data that are retrieved for update.

Preventing multiple applications from obtaining copies of the same record when the record is about to be changed is called ________.

The purpose of concurrency control is to ensure that one user's work does not inappropriately influence another user's work.

Microsoft Access 2016 can secure databases by using ________ to encrypt and decrypt the database files.

When Microsoft Access 2016 uses user-level security with an Access 2003 file,the database is stored in a(n)________.

The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as ________.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 6: Database Administration

Concurrent processing of a database only poses problems when two or more processes attempt to use the same data.

Breaking hardware,power outages,and human mistakes are all reasons that ________.

Briefly define the three problems that can occur because of concurrent processing that are addressed by resource locking.

Two-phase locking can be used to ensure that transactions are serializable.

What concurrent processing problem occurs when a transaction rereads data and finds new rows that were inserted by a different transaction since the prior read?

When Microsoft Access 2016 creates a signed package with a digital signature,the database file will be a(n)________.

When a transaction functions in such a way that either all of the transaction actions are completed or none of them will be,the transaction is said to be ________.

With optimistic locking,locks are first issued,then the transaction is processed,and then the locks are released.

When Microsoft Access 2016 uses user-level security with an Access 2003 file,the database is stored in a(n)*.accdb file.

Computer systems fail for which of the following reasons except?

Why do computers fail?

Only large database systems have a need for database administration.

Standard SQL defines four ________,which specify which of the concurrency control problems are allowed to occur.

Database security is easy to achieve since all security is handled by the DBMS,which is a single point of entry into the database.

One way to prevent concurrent processing problems is to lock data that are retrieved for update.

Preventing multiple applications from obtaining copies of the same record when the record is about to be changed is called ________.

The purpose of concurrency control is to ensure that one user's work does not inappropriately influence another user's work.

Microsoft Access 2016 can secure databases by using ________ to encrypt and decrypt the database files.

When Microsoft Access 2016 uses user-level security with an Access 2003 file,the database is stored in a(n)________.

The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as ________.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters