Question 1

Transactions should be written to the log before they are applied to the database itself.

Accepted Answer

A) True 
 B)False  True

Question 2

Microsoft Access 2013 can secure databases by deploying databases packaged with a(n)________.

Accepted Answer

digital signature

Question 3

Rollback requires the use of logs,but rollforward does not.

Accepted Answer

A) True 
 B)False  False

Question 4

The term DBA refers to the:

Accepted Answer

A) database accessor. 
B) database auditor. 
C) data business auditor. 
D) database administrator. 
E) data business administrator. 
A) database accessor. 
B) database auditor. 
C) data business auditor. 
D) database administrator. 
E) data business administrator.

Question 5

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 becaus

Question 6

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 7

Microsoft Access 2013 uses a user-level security system.

Accepted Answer

A) True 
 B)False

Question 8

Microsoft Access 2013 databases cannot be secured by password encryption.

Accepted Answer

A) True 
 B)False

Question 9

A dirty read is a problem with concurrent processing when a transaction rereads data it has already read and finds modifications or deletions caused by another transaction.

Accepted Answer

A) True 
 B)False

Question 10

In comparison to reprocessing,rollforward does not involve the application programs.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

________ is an important business function whose purpose is to manage the database to maximize its value to the organization.

Accepted Answer

Database a

Question 14

Computer systems fail for which of the following reasons?

Accepted Answer

A) Hardware breaks. 
B) Electrical power fails. 
C) Programs have bugs. 
D) People make mistakes. 
E) All of the above 
A) Hardware breaks. 
B) Electrical power fails. 
C) Programs have bugs. 
D) People make mistakes. 
E) All of the above

Question 15

What is the difference between authentication and authorization?

Accepted Answer

Authentication refers to making sure a u

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Distinguish between statement-level consistency and transaction-level consistency.

Accepted Answer

Statement-level consistency requires tha

Question 18

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 19

A point of synchronization between the database and the transaction log is called a(n):

Accepted Answer

A) before-image. 
B) after-image. 
C) recovery. 
D) checkpoint. 
E) None of the above 
A) before-image. 
B) after-image. 
C) recovery. 
D) checkpoint. 
E) None of the above

Question 20

What is the least restrictive isolation level that will prevent dirty 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

Transactions should be written to the log before they are applied to the database itself.

Microsoft Access 2013 can secure databases by deploying databases packaged with a(n)________.

Rollback requires the use of logs,but rollforward does not.

The term DBA refers to the:

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

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.

Microsoft Access 2013 uses a user-level security system.

Microsoft Access 2013 databases cannot be secured by password encryption.

A dirty read is a problem with concurrent processing when a transaction rereads data it has already read and finds modifications or deletions caused by another transaction.

In comparison to reprocessing,rollforward does not involve the application programs.

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

An ACID transaction is one that is:

________ is an important business function whose purpose is to manage the database to maximize its value to the organization.

Computer systems fail for which of the following reasons?

What is the difference between authentication and authorization?

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

Distinguish between statement-level consistency and transaction-level consistency.

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

A point of synchronization between the database and the transaction log is called a(n):

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

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

Transactions should be written to the log before they are applied to the database itself.

Microsoft Access 2013 can secure databases by deploying databases packaged with a(n)________.

Rollback requires the use of logs,but rollforward does not.

The term DBA refers to the:

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

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.

Microsoft Access 2013 uses a user-level security system.

Microsoft Access 2013 databases cannot be secured by password encryption.

A dirty read is a problem with concurrent processing when a transaction rereads data it has already read and finds modifications or deletions caused by another transaction.

In comparison to reprocessing,rollforward does not involve the application programs.

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

An ACID transaction is one that is:

________ is an important business function whose purpose is to manage the database to maximize its value to the organization.

Computer systems fail for which of the following reasons?

What is the difference between authentication and authorization?

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

Distinguish between statement-level consistency and transaction-level consistency.

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

A point of synchronization between the database and the transaction log is called a(n):

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

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

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.