Question 1

Once processing rights have been defined,they may be implemented at any of these levels except:

Accepted Answer

A) network. 
B) operating system. 
C) data. 
D) DBMS. 
E) application. 
A) network. 
B) operating system. 
C) data. 
D) DBMS. 
E) application.

Question 2

Which of the following is not true about locks?

Accepted Answer

A) Locks with large granularity are easier for the DBMS to administer. 
B) Locks with small granularity cause more conflicts. 
C) Locks with large granularity produce fewer details for the DBMS to track. 
D) Locks may have a table-level granularity. 
E) Locks may have a database-level granularity. 
A) Locks with large granularity are easier for the DBMS to administer. 
B) Locks with small granularity cause more conflicts. 
C) Locks with large granularity produce fewer details for the DBMS to track. 
D) Locks may have a table-level granularity. 
E) Locks may have a database-level granularity.

Question 3

Which type of lock prevents all types of access to the locked resource?

Accepted Answer

A) Exclusive lock 
B) Shared lock 
C) Two-phased lock 
D) Explicit lock 
E) Implicit lock 
A) Exclusive lock 
B) Shared lock 
C) Two-phased lock 
D) Explicit lock 
E) Implicit lock

Question 4

With pessimistic locking,the assumption is made that a conflict will occur.

Accepted Answer

A) True 
 B)False

Question 5

Resources are locked for a shorter amount of time with pessimistic locking because the transaction is pre-processed.

Accepted Answer

A) True 
 B)False

Question 6

Requiring all application programs to lock resources in the same order is a technique for preventing what problem?

Accepted Answer

A) Concurrent update 
B) Lost update 
C) Deadlock 
D) Exclusive locks 
E) Growing phase locking 
A) Concurrent update 
B) Lost update 
C) Deadlock 
D) Exclusive locks 
E) Growing phase locking

Question 7

Which of the following is allowed by "Repeatable Read Isolation"?

Accepted Answer

A) Nonrepeatable reads 
B) Dirty reads 
C) Phantom reads 
D) A and B 
E) A,B,and C 
A) Nonrepeatable reads 
B) Dirty reads 
C) Phantom reads 
D) A and B 
E) A,B,and C

Question 8

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

Accepted Answer

Statement-level consistency requires tha

Question 9

Concurrency control measures are taken to ensure that one user's work has absolutely no influence on another user's work.

Accepted Answer

A) True 
 B)False

Question 10

Repeatable Read isolation is the most restrictive level of isolation.

Accepted Answer

A) True 
 B)False

Question 11

A transaction is a series of actions to be taken on the database such that either all of them are performed successfully or none of them is performed at all.

Accepted Answer

A) True 
 B)False

Question 12

To support rollforward and rollback recovery,transactions must be written to a script before they are applied to the database.

Accepted Answer

A) True 
 B)False

Question 13

An exclusive lock locks the item from access of any type.

Accepted Answer

A) True 
 B)False

Question 14

Briefly define the four isolation levels and the problems they prevent.

Accepted Answer

The four isolation levels are read uncom

Question 15

One remedy for the inconsistencies caused by concurrent processing is ________.

Accepted Answer

A) lost updates 
B) checkpointing 
C) rollback 
D) resource locking 
E) concurrency 
A) lost updates 
B) checkpointing 
C) rollback 
D) resource locking 
E) concurrency

Question 16

Which of the following is true about making changes to the database structure?

Accepted Answer

A) The DBA need not get input from users on the issue because it is a technical decision. 
B) Formal policies and procedures for requesting a change are not used because they are too limiting. 
C) Documentation of when the change was made,how it was made,and why it was made must be created. 
D) Changes do not produce unexpected results because the DBA will have investigated the change thoroughly before implementing it. 
E) If the database is properly designed,changes should not be necessary throughout the system's lifetime. 
A) The DBA need not get input from users on the issue because it is a technical decision. 
B) Formal policies and procedures for requesting a change are not used because they are too limiting. 
C) Documentation of when the change was made,how it was made,and why it was made must be created. 
D) Changes do not produce unexpected results because the DBA will have investigated the change thoroughly before implementing it. 
E) If the database is properly designed,changes should not be necessary throughout the system's lifetime.

Question 17

The security provided by the DBMS often has to be augmented by additional security features within the application program.

Accepted Answer

A) True 
 B)False

Question 18

Which are more commonly used: implicit or explicit locks? Why?

Accepted Answer

Implicit locks are more commonly used th

Question 19

A dirty read happens when one transaction reads a changed record that has not been committed to the database.

Accepted Answer

A) True 
 B)False

Question 20

The transaction boundaries are the essential information that the DBMS needs from the application programs to enforce different locking strategies.

Accepted Answer

A) True 
 B)False

Exam 9: Managing Multiuser Databases

Once processing rights have been defined,they may be implemented at any of these levels except:

Which of the following is not true about locks?

Which type of lock prevents all types of access to the locked resource?

With pessimistic locking,the assumption is made that a conflict will occur.

Resources are locked for a shorter amount of time with pessimistic locking because the transaction is pre-processed.

Requiring all application programs to lock resources in the same order is a technique for preventing what problem?

Which of the following is allowed by "Repeatable Read Isolation"?

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

Concurrency control measures are taken to ensure that one user's work has absolutely no influence on another user's work.

Repeatable Read isolation is the most restrictive level of isolation.

A transaction is a series of actions to be taken on the database such that either all of them are performed successfully or none of them is performed at all.

To support rollforward and rollback recovery,transactions must be written to a script before they are applied to the database.

An exclusive lock locks the item from access of any type.

Briefly define the four isolation levels and the problems they prevent.

One remedy for the inconsistencies caused by concurrent processing is ________.

Which of the following is true about making changes to the database structure?

The security provided by the DBMS often has to be augmented by additional security features within the application program.

Which are more commonly used: implicit or explicit locks? Why?

A dirty read happens when one transaction reads a changed record that has not been committed to the database.

The transaction boundaries are the essential information that the DBMS needs from the application programs to enforce different locking strategies.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

Sql for Database Construction and Application Processing

Database Redesign

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters