Question 1

Database administrators are responsible for administering database security.

Accepted Answer

A) True 
 B)False

Question 2

A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked.

Accepted Answer

A)  record controller 
B)  exclusive lock 
C)  authorization rule 
D)  shared lock 
A)  record controller 
B)  exclusive lock 
C)  authorization rule 
D)  shared lock

Question 3

In order for a transaction to be consistent:

Accepted Answer

A)  it must run the same way all the time. 
B)  it must tell the truth. 
C)  it must run using the same amount of memory. 
D)  any database constraints that must be true before the transaction must also be true after the transaction. 
A)  it must run the same way all the time. 
B)  it must tell the truth. 
C)  it must run using the same amount of memory. 
D)  any database constraints that must be true before the transaction must also be true after the transaction.

Question 4

A shared lock prevents another transaction from reading a record.

Accepted Answer

A) True 
 B)False

Question 5

A client PC that is responsible for presentation logic, application logic, and many DBMS functions is called a fat client.

Accepted Answer

A) True 
 B)False

Question 6

Discuss the distribution of application logic components across clients and servers in the client/server environment.

Accepted Answer

The first component is the presentation

Question 7

In some three-tier architectures, most application code is stored on the application server.

Accepted Answer

A) True 
 B)False

Question 8

During multiple simultaneous transactions data integrity is maintained by logging.

Accepted Answer

A) True 
 B)False

Question 9

Database administrators are responsible for developing overall policies and procedures for database security.

Accepted Answer

A) True 
 B)False

Question 10

What is the difference between shared locks and exclusive locks?

Accepted Answer

Shared locks allow other transactions to

Question 11

Storage logic is provided by an application server.

Accepted Answer

A) True 
 B)False

Question 12

Versioning is a pessimistic approach to concurrency control.

Accepted Answer

A) True 
 B)False

Question 13

A sequence of steps that constitute a well-defined business activity is called a:

Accepted Answer

A)  transaction. 
B)  transfixture. 
C)  database. 
D)  table. 
A)  transaction. 
B)  transfixture. 
C)  database. 
D)  table.

Question 14

Discuss some of the advantages to using model and view classes in Python.

Accepted Answer

You can change the type of database by c

Question 15

The extent of the database resource that is included with each lock is called the level of:

Accepted Answer

A)  impact. 
B)  management. 
C)  lock granularity. 
D)  TIO. 
A)  impact. 
B)  management. 
C)  lock granularity. 
D)  TIO.

Question 16

An application server provides basic functionality for receiving and responding to requests from browsers.

Accepted Answer

A) True 
 B)False

Question 17

The presentation logic component of a client/server system is responsible for formatting and presenting data on the user's screen.

Accepted Answer

A) True 
 B)False

Question 18

All .html files can be processed by the web server itself.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is not a basic step to accessing a database from an application:

Accepted Answer

A)  register database driver. 
B)  open a connection. 
C)  define physical storage. 
D)  query the database. 
A)  register database driver. 
B)  open a connection. 
C)  define physical storage. 
D)  query the database.

Question 20

The W3C standard for Web privacy is called:

Accepted Answer

A)  the Web privacy act. 
B)  Platform for Privacy Preferences. 
C)  Freedom of Web Information Act. 
D)  the Magna Carta. 
A)  the Web privacy act. 
B)  Platform for Privacy Preferences. 
C)  Freedom of Web Information Act. 
D)  the Magna Carta.

Database administrators are responsible for administering database security.

A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked.

In order for a transaction to be consistent:

A shared lock prevents another transaction from reading a record.

A client PC that is responsible for presentation logic, application logic, and many DBMS functions is called a fat client.

Discuss the distribution of application logic components across clients and servers in the client/server environment.

In some three-tier architectures, most application code is stored on the application server.

During multiple simultaneous transactions data integrity is maintained by logging.

Database administrators are responsible for developing overall policies and procedures for database security.

What is the difference between shared locks and exclusive locks?

Storage logic is provided by an application server.

Versioning is a pessimistic approach to concurrency control.

A sequence of steps that constitute a well-defined business activity is called a:

Discuss some of the advantages to using model and view classes in Python.

The extent of the database resource that is included with each lock is called the level of:

An application server provides basic functionality for receiving and responding to requests from browsers.

The presentation logic component of a client/server system is responsible for formatting and presenting data on the user's screen.

All .html files can be processed by the web server itself.

Which of the following is not a basic step to accessing a database from an application:

The W3C standard for Web privacy is called:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 7: Databases in Applications

Database administrators are responsible for administering database security.

A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked.

In order for a transaction to be consistent:

A shared lock prevents another transaction from reading a record.

A client PC that is responsible for presentation logic, application logic, and many DBMS functions is called a fat client.

Discuss the distribution of application logic components across clients and servers in the client/server environment.

In some three-tier architectures, most application code is stored on the application server.

During multiple simultaneous transactions data integrity is maintained by logging.

Database administrators are responsible for developing overall policies and procedures for database security.

What is the difference between shared locks and exclusive locks?

Storage logic is provided by an application server.

Versioning is a pessimistic approach to concurrency control.

A sequence of steps that constitute a well-defined business activity is called a:

Discuss some of the advantages to using model and view classes in Python.

The extent of the database resource that is included with each lock is called the level of:

An application server provides basic functionality for receiving and responding to requests from browsers.

The presentation logic component of a client/server system is responsible for formatting and presenting data on the user's screen.

All .html files can be processed by the web server itself.

Which of the following is not a basic step to accessing a database from an application:

The W3C standard for Web privacy is called:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters