Question 1

One advantage of optimistic locking is that the lock is obtained only after the transaction is processed.

Accepted Answer

A) True 
 B)False

Question 2

Whether a lock applies to data at the record level,page level,table level,or database level is referred to as:

Accepted Answer

A) lock exclusivity. 
B) lock sharing. 
C) lock phasing. 
D) serializable locking. 
E) lock granularity. 
A) lock exclusivity. 
B) lock sharing. 
C) lock phasing. 
D) serializable locking. 
E) lock granularity.

Question 3

Which of the following is not a means of processing databases?

Accepted Answer

A) Internet applications using ASP 
B) Internet applications using JSP 
C) Applications invoking stored procedures 
D) Programs coded in C# 
E) All of the above are means of processing a database. 
A) Internet applications using ASP 
B) Internet applications using JSP 
C) Applications invoking stored procedures 
D) Programs coded in C# 
E) All of the above are means of processing a database.

Question 4

When Microsoft Access 2013 uses user-level security with an Access 2003 database file,it stores the database in a(n)________ file.

Accepted Answer

The answer of When Microsoft Access 2013 uses user-level security...

Question 5

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 6

Microsoft Access 2013 can secure database files by storing them in a(n)________.

Accepted Answer

The answer of Microsoft Access 2013 can secure database files...

Question 7

A transaction in which all steps must be completed successfully or none of them will be completed is called a durable transaction.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is not true of database recovery through reprocessing?

Accepted Answer

A) Reprocessing makes use of a database save. 
B) Reprocessing takes the same amount of time as did processing in the first place. 
C) Reprocessing will always return the database to its exact previous state. 
D) Reprocessing requires a record of all transactions since the last time the database was saved. 
E) All of the above are true of reprocessing. 
A) Reprocessing makes use of a database save. 
B) Reprocessing takes the same amount of time as did processing in the first place. 
C) Reprocessing will always return the database to its exact previous state. 
D) Reprocessing requires a record of all transactions since the last time the database was saved. 
E) All of the above are true of reprocessing.

Question 9

When Microsoft Access 2013 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 10

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 11

All actions in an atomic transaction are completed successfully or none of the actions are completed at all.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

Why do computers fail?

Accepted Answer

Computers fail for a variety o

Question 15

Only large database systems have a need for database administration.

Accepted Answer

A) True 
 B)False

Question 16

What are the four transaction isolation levels?

Accepted Answer

The four levels of isolation are Read Un

Question 17

The recovery method where the database is restored using the saved data,and all transactions since the save are reapplied is called ________ recovery.

Accepted Answer

The answer of The recovery method where the database is...

Question 18

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

Accepted Answer

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

Question 19

Microsoft Access 2013 databases can be secured using trusted locations for database storage.

Accepted Answer

A) True 
 B)False

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.

One advantage of optimistic locking is that the lock is obtained only after the transaction is processed.

Whether a lock applies to data at the record level,page level,table level,or database level is referred to as:

Which of the following is not a means of processing databases?

When Microsoft Access 2013 uses user-level security with an Access 2003 database file,it stores the database in a(n)________ file.

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

Microsoft Access 2013 can secure database files by storing them in a(n)________.

A transaction in which all steps must be completed successfully or none of them will be completed is called a durable transaction.

Which of the following is not true of database recovery through reprocessing?

When Microsoft Access 2013 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:

All actions in an atomic transaction are completed successfully or none of the actions are completed at all.

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:

Why do computers fail?

Only large database systems have a need for database administration.

What are the four transaction isolation levels?

The recovery method where the database is restored using the saved data,and all transactions since the save are reapplied is called ________ recovery.

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

Microsoft Access 2013 databases can be secured using trusted locations for database storage.

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

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 6: Database Administration

One advantage of optimistic locking is that the lock is obtained only after the transaction is processed.

Whether a lock applies to data at the record level,page level,table level,or database level is referred to as:

Which of the following is not a means of processing databases?

When Microsoft Access 2013 uses user-level security with an Access 2003 database file,it stores the database in a(n)________ file.

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

Microsoft Access 2013 can secure database files by storing them in a(n)________.

A transaction in which all steps must be completed successfully or none of them will be completed is called a durable transaction.

Which of the following is not true of database recovery through reprocessing?

When Microsoft Access 2013 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:

All actions in an atomic transaction are completed successfully or none of the actions are completed at all.

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:

Why do computers fail?

Only large database systems have a need for database administration.

What are the four transaction isolation levels?

The recovery method where the database is restored using the saved data,and all transactions since the save are reapplied is called ________ recovery.

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

Microsoft Access 2013 databases can be secured using trusted locations for database storage.

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

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters