Question 1

When Microsoft Access 2013 secures a database just by storing the database in a trusted location,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 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

Question 3

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 4

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

Question 5

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

Accepted Answer

The answer of Breaking hardware,power outages,and human mistakes are all...

Question 6

Explain the process of using optimistic locking.

Accepted Answer

Optimistic locking makes the assumption

Question 7

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 8

Discuss Microsoft Access 2013 security administration.

Accepted Answer

Microsoft Access 2013 files can be secur

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

Briefly explain the strategy of two-phased locking.

Accepted Answer

Two-phased locking is a strategy to ensu

Question 12

When Microsoft Access 2013 secures a database with just a password,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 13

Distinguish between reprocessing and rollforward as database recovery techniques.

Accepted Answer

Reprocessing and rollforward both requir

Question 14

Ensuring that each SQL statement independently processes consistent rows is known as:

Accepted Answer

A) transaction level consistency. 
B) independent consistency. 
C) statement level consistency. 
D) process level consistency. 
E) serializable consistency. 
A) transaction level consistency. 
B) independent consistency. 
C) statement level consistency. 
D) process level consistency. 
E) serializable consistency.

Question 15

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 16

The recovery method in which we undo the changes that erroneous or partially processed transactions have made in the database is called ________ recovery.

Accepted Answer

The answer of The recovery method in which we undo...

Question 17

What database administration functions help bring order to the potential chaos of the database processing environment?

Accepted Answer

First,the actions of concurrent users mu

Question 18

The acronym DBA refers to either the office or the manager.

Accepted Answer

A) True 
 B)False

Question 19

When Microsoft Access 2013 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 purpose of concurrency control is to:

Accepted Answer

A) ensure that each form has a corresponding report. 
B) ensure that ASPs do not duplicate JSPs. 
C) ensure that one user's work does not interfere with another's. 
D) ensure that stored procedures do not invoke triggers. 
E) ensure that triggers do not invoke stored procedures. 
A) ensure that each form has a corresponding report. 
B) ensure that ASPs do not duplicate JSPs. 
C) ensure that one user's work does not interfere with another's. 
D) ensure that stored procedures do not invoke triggers. 
E) ensure that triggers do not invoke stored procedures.

When Microsoft Access 2013 secures a database just by storing the database in a trusted location,the database file will be a(n):

Additional DBA responsibilities include:

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

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

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

Explain the process of using optimistic locking.

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?

Discuss Microsoft Access 2013 security administration.

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

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

Briefly explain the strategy of two-phased locking.

When Microsoft Access 2013 secures a database with just a password,the database file will be a(n):

Distinguish between reprocessing and rollforward as database recovery techniques.

Ensuring that each SQL statement independently processes consistent rows is known as:

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

The recovery method in which we undo the changes that erroneous or partially processed transactions have made in the database is called ________ recovery.

What database administration functions help bring order to the potential chaos of the database processing environment?

The acronym DBA refers to either the office or the manager.

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

The purpose of concurrency control is to:

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

When Microsoft Access 2013 secures a database just by storing the database in a trusted location,the database file will be a(n):

Additional DBA responsibilities include:

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

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

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

Explain the process of using optimistic locking.

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?

Discuss Microsoft Access 2013 security administration.

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

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

Briefly explain the strategy of two-phased locking.

When Microsoft Access 2013 secures a database with just a password,the database file will be a(n):

Distinguish between reprocessing and rollforward as database recovery techniques.

Ensuring that each SQL statement independently processes consistent rows is known as:

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

The recovery method in which we undo the changes that erroneous or partially processed transactions have made in the database is called ________ recovery.

What database administration functions help bring order to the potential chaos of the database processing environment?

The acronym DBA refers to either the office or the manager.

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

The purpose of concurrency control is to:

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