Question 1

Microsoft Access 2016 uses a user-level security system.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

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 5

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 6

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 7

Microsoft Access 2016 databases cannot be secured by password encryption.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Which is not a typical processing application for a database?

Accepted Answer

A)  Stored Procedures in PHP 
B)  Web forms 
C)  Disk Defragmenter 
D)  User-defined triggers 
E)  SQL/Persistent Stored Modules 
A)  Stored Procedures in PHP 
B)  Web forms 
C)  Disk Defragmenter 
D)  User-defined triggers 
E)  SQL/Persistent Stored Modules

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

A(n)________ cursor takes a snapshot of a relation and processes that snapshot,while changes from others sources are not visible to this type of cursor.

Accepted Answer

The answer of A(n)________ cursor takes a snapshot of a...

Question 17

When Microsoft Access 2016 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 2016 uses user-level security...

Question 18

When Microsoft Access 2016 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 19

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 20

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

Microsoft Access 2016 uses a user-level security system.

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.

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

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.

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

The term DBA refers to the ________.

Microsoft Access 2016 databases cannot be secured by password encryption.

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

Which is not a typical processing application for a database?

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

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

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

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

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

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

A(n)________ cursor takes a snapshot of a relation and processes that snapshot,while changes from others sources are not visible to this type of cursor.

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

When Microsoft Access 2016 compiles VBA code in a database,the database file will be a(n)________.

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

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

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

Microsoft Access 2016 uses a user-level security system.

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.

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

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.

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

The term DBA refers to the ________.

Microsoft Access 2016 databases cannot be secured by password encryption.

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

Which is not a typical processing application for a database?

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

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

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

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

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

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

A(n)________ cursor takes a snapshot of a relation and processes that snapshot,while changes from others sources are not visible to this type of cursor.

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

When Microsoft Access 2016 compiles VBA code in a database,the database file will be a(n)________.

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

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

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

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.