Question 1

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  False

Question 2

Additional DBA responsibilities include:

Accepted Answer

A)  problem and error reporting. 
B)  requests of changes to existing systems. 
C)  controlling database configuration. 
D)  maintaining appropriate documentation. 
E)  All of the above 
A)  problem and error reporting. 
B)  requests of changes to existing systems. 
C)  controlling database configuration. 
D)  maintaining appropriate documentation. 
E)  All of the above E

Question 3

What concurrent processing problem occurs when a transaction reads a changed record that has not been committed to the database?

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 C

Question 4

Discuss Microsoft Access 2013 security administration.

Accepted Answer

Microsoft Access 2013 files can be secur

Question 5

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

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 7

In terms of database security,a user can be assigned many roles,and a role can be assigned to many users.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Generally,the more restrictive the transaction isolation level,the less the throughput of database processing.

Accepted Answer

A) True 
 B)False

Question 10

What is the least restrictive isolation level that will prevent phantom read problems?

Accepted Answer

A)  Read Committed 
B)  Serializable 
C)  Read Uncommitted 
D)  Atomic Read 
E)  Repeatable Read 
A)  Read Committed 
B)  Serializable 
C)  Read Uncommitted 
D)  Atomic Read 
E)  Repeatable Read

Question 11

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 12

Database administrators must make sure that ________ and ________ techniques and procedures are operating to protect the database in case of failure and to recover it as quickly and accurately as possible when necessary.

Accepted Answer

The answer of Database administrators must make sure that ________...

Question 13

The simplest and most feasible means of recovering a database is through reprocessing.

Accepted Answer

A) True 
 B)False

Question 14

Lock granularity refers to whether a lock is placed by the DBMS automatically or is placed by a command from the application program.

Accepted Answer

A) True 
 B)False

Question 15

When Microsoft Access 2013 compiles VBA code in a database,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 16

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

Accepted Answer

A) True 
 B)False

Question 17

What is the least restrictive isolation level that will prevent nonrepeatable reads?

Accepted Answer

A)  Read Committed 
B)  Serializable 
C)  Read Uncommitted 
D)  Atomic Read 
E)  Repeatable Read 
A)  Read Committed 
B)  Serializable 
C)  Read Uncommitted 
D)  Atomic Read 
E)  Repeatable Read

Question 18

An ACID transaction is one that is:

Accepted Answer

A)  atomic. 
B)  consistent. 
C)  isolated. 
D)  durable. 
E)  All of the above 
A)  atomic. 
B)  consistent. 
C)  isolated. 
D)  durable. 
E)  All of the above

Question 19

Explain the process of using optimistic locking.

Accepted Answer

Optimistic locking makes the assumption

Question 20

Microsoft Access 2013 databases can be secured by deploying databases packaged with digital signatures.

Accepted Answer

A) True 
 B)False

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

Additional DBA responsibilities include:

What concurrent processing problem occurs when a transaction reads a changed record that has not been committed to the database?

Discuss Microsoft Access 2013 security administration.

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

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?

In terms of database security,a user can be assigned many roles,and a role can be assigned to many users.

When Microsoft Access 2013 creates a signed package with a digital signature,the database file will be a(n):

Generally,the more restrictive the transaction isolation level,the less the throughput of database processing.

What is the least restrictive isolation level that will prevent phantom read problems?

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

Database administrators must make sure that and techniques and procedures are operating to protect the database in case of failure and to recover it as quickly and accurately as possible when necessary.

The simplest and most feasible means of recovering a database is through reprocessing.

Lock granularity refers to whether a lock is placed by the DBMS automatically or is placed by a command from the application program.

When Microsoft Access 2013 compiles VBA code in a database,the database file will be a(n):

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

What is the least restrictive isolation level that will prevent nonrepeatable reads?

An ACID transaction is one that is:

Explain the process of using optimistic locking.

Microsoft Access 2013 databases can be secured by deploying databases packaged with digital signatures.

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 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 6: Database Administration

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

Additional DBA responsibilities include:

What concurrent processing problem occurs when a transaction reads a changed record that has not been committed to the database?

Discuss Microsoft Access 2013 security administration.

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

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?

In terms of database security,a user can be assigned many roles,and a role can be assigned to many users.

When Microsoft Access 2013 creates a signed package with a digital signature,the database file will be a(n):

Generally,the more restrictive the transaction isolation level,the less the throughput of database processing.

What is the least restrictive isolation level that will prevent phantom read problems?

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

Database administrators must make sure that ________ and ________ techniques and procedures are operating to protect the database in case of failure and to recover it as quickly and accurately as possible when necessary.

The simplest and most feasible means of recovering a database is through reprocessing.

Lock granularity refers to whether a lock is placed by the DBMS automatically or is placed by a command from the application program.

When Microsoft Access 2013 compiles VBA code in a database,the database file will be a(n):

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

What is the least restrictive isolation level that will prevent nonrepeatable reads?

An ACID transaction is one that is:

Explain the process of using optimistic locking.

Microsoft Access 2013 databases can be secured by deploying databases packaged with digital signatures.

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 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Database administrators must make sure that and techniques and procedures are operating to protect the database in case of failure and to recover it as quickly and accurately as possible when necessary.