Question 1

A transaction is consistent if it always runs with the same amount of memory.

Accepted Answer

A) True 
 B)False

Question 2

All transactions must have the ACID characteristics.

Accepted Answer

A) True 
 B)False

Question 3

A(n) ________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released.

Accepted Answer

A)  record controller 
B)  exclusive lock 
C)  authorization rule 
D)  two-phase lock 
A)  record controller 
B)  exclusive lock 
C)  authorization rule 
D)  two-phase lock

Question 4

Client/server describes a networked computing model that distributes processes between computers that request services and computers that provide services.

Accepted Answer

A) True 
 B)False

Question 5

Two-tier architectures are much more scalable than three-tier architectures.

Accepted Answer

A) True 
 B)False

Question 6

Open Database Connectivity is an application programming interface that provides a common language for application programs to access and process SQL databases independent of the particular RDBMS that is accessed.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is NOT a common distribution logic for two-tiered server environments?

Accepted Answer

A)  Fat client 
B)  Tall client 
C)  Thin client 
D)  Distributed 
A)  Fat client 
B)  Tall client 
C)  Thin client 
D)  Distributed

Question 8

The LAMP stack consists of Apache, PHP and MySQL.

Accepted Answer

A) True 
 B)False

Question 9

A client/server configuration that has three layers (one client and two servers) has a three-tier architecture.

Accepted Answer

A) True 
 B)False

Question 10

All of the following are key components of a web application EXCEPT:

Accepted Answer

A)  database server. 
B)  web server. 
C)  processing-logic server. 
D)  web browser. 
A)  database server. 
B)  web server. 
C)  processing-logic server. 
D)  web browser.

Question 11

A web server is a key component of web applications.

Accepted Answer

A) True 
 B)False

Question 12

A computer that provides database storage and access in a client/server environment is called a(n):

Accepted Answer

A)  database server. 
B)  file server. 
C)  cloud data store. 
D)  info server. 
A)  database server. 
B)  file server. 
C)  cloud data store. 
D)  info server.

Question 13

Level of lock granularity is the extent of a database resource include with each lock.

Accepted Answer

A) True 
 B)False

Question 14

Geolocation logic is the application logic component responsible for data storage and retrieval.

Accepted Answer

A) True 
 B)False

Question 15

The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.

Accepted Answer

A) True 
 B)False

Question 16

A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system.

Accepted Answer

A)  API 
B)  MOM 
C)  RPC 
D)  LAN 
A)  API 
B)  MOM 
C)  RPC 
D)  LAN

Question 17

Which of the following is a type of network security?

Accepted Answer

A)  Authentication of the client workstation 
B)  Password naming conventions 
C)  Guidelines for frequency of password changes 
D)  Random password guessing 
A)  Authentication of the client workstation 
B)  Password naming conventions 
C)  Guidelines for frequency of password changes 
D)  Random password guessing

Question 18

All of the following are advantages of stored procedures EXCEPT:

Accepted Answer

A)  performance improves for compiled SQL statements. 
B)  network traffic deceases. 
C)  portability. 
D)  thinner client. 
A)  performance improves for compiled SQL statements. 
B)  network traffic deceases. 
C)  portability. 
D)  thinner client.

Question 19

A common encryption method to secure data traveling between a client and a server is called:

Accepted Answer

A)  Secure Sockets Layer (SSL). 
B)  Secure Synchronization Layer (SSL). 
C)  RSA. 
D)  ITT. 
A)  Secure Sockets Layer (SSL). 
B)  Secure Synchronization Layer (SSL). 
C)  RSA. 
D)  ITT.

Question 20

The role responsible for administering database security is:

Accepted Answer

A)  Data Administration. 
B)  Database Administration. 
C)  Security. 
D)  Developers. 
A)  Data Administration. 
B)  Database Administration. 
C)  Security. 
D)  Developers.

A transaction is consistent if it always runs with the same amount of memory.

All transactions must have the ACID characteristics.

A(n) ________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released.

Client/server describes a networked computing model that distributes processes between computers that request services and computers that provide services.

Two-tier architectures are much more scalable than three-tier architectures.

Open Database Connectivity is an application programming interface that provides a common language for application programs to access and process SQL databases independent of the particular RDBMS that is accessed.

Which of the following is NOT a common distribution logic for two-tiered server environments?

The LAMP stack consists of Apache, PHP and MySQL.

A client/server configuration that has three layers (one client and two servers) has a three-tier architecture.

All of the following are key components of a web application EXCEPT:

A web server is a key component of web applications.

A computer that provides database storage and access in a client/server environment is called a(n):

Level of lock granularity is the extent of a database resource include with each lock.

Geolocation logic is the application logic component responsible for data storage and retrieval.

The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.

A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system.

Which of the following is a type of network security?

All of the following are advantages of stored procedures EXCEPT:

A common encryption method to secure data traveling between a client and a server is called:

The role responsible for administering database security is:

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

A transaction is consistent if it always runs with the same amount of memory.

All transactions must have the ACID characteristics.

A(n) ________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released.

Client/server describes a networked computing model that distributes processes between computers that request services and computers that provide services.

Two-tier architectures are much more scalable than three-tier architectures.

Open Database Connectivity is an application programming interface that provides a common language for application programs to access and process SQL databases independent of the particular RDBMS that is accessed.

Which of the following is NOT a common distribution logic for two-tiered server environments?

The LAMP stack consists of Apache, PHP and MySQL.

A client/server configuration that has three layers (one client and two servers) has a three-tier architecture.

All of the following are key components of a web application EXCEPT:

A web server is a key component of web applications.

A computer that provides database storage and access in a client/server environment is called a(n):

Level of lock granularity is the extent of a database resource include with each lock.

Geolocation logic is the application logic component responsible for data storage and retrieval.

The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.

A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system.

Which of the following is a type of network security?

All of the following are advantages of stored procedures EXCEPT:

A common encryption method to secure data traveling between a client and a server is called:

The role responsible for administering database security is:

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