Question 1

A client PC that is responsible for processing presentation logic, extensive application and business rules logic, as well as many DBMS functions is called a:

Accepted Answer

A)  file server. 
B)  file processor. 
C)  database server. 
D)  fat client. 
A)  file server. 
B)  file processor. 
C)  database server. 
D)  fat client. D

Question 2

Loss of confidentiality is a threat that involves outside parties using information to embarrass a company.

Accepted Answer

A) True 
 B)False  True

Question 3

What threats to data security must be addressed in a comprehensive data security plan?

Accepted Answer

A comprehensive data security plan must address the following threats:
1. Accidental losses, which could be caused by human error, software and hardware-caused breaches
2. Theft and fraud
3. Loss or privacy or confidentiality
4. Loss of data integrity
5. Loss of availability

Question 4

________ is the process of assigning pieces of application code to clients or servers.

Accepted Answer

A)  Application partitioning 
B)  Modularizing programs 
C)  Code distribution 
D)  Program breakup 
A)  Application partitioning 
B)  Modularizing programs 
C)  Code distribution 
D)  Program breakup

Question 5

The Magna Carta is the W3C standard for Web privacy.

Accepted Answer

A) True 
 B)False

Question 6

A data-interchange format easily for humans to read and machines to parse and process is called:

Accepted Answer

A)  Java Oriented Notation (JON). 
B)  HTML. 
C)  XML. 
D)  JavaScript Object Notation (JSON). 
A)  Java Oriented Notation (JON). 
B)  HTML. 
C)  XML. 
D)  JavaScript Object Notation (JSON).

Question 7

An application server

Accepted Answer

A)  provides basic functionality for receiving and responding to requests from browsers. 
B)  provides the building blocks for creating dynamic web sites and web-based applications. 
C)  provides storage logic. 
D)  none of the above. 
A)  provides basic functionality for receiving and responding to requests from browsers. 
B)  provides the building blocks for creating dynamic web sites and web-based applications. 
C)  provides storage logic. 
D)  none of the above.

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers.

Accepted Answer

A)  memory 
B)  files 
C)  application logic components 
D)  query logic components 
A)  memory 
B)  files 
C)  application logic components 
D)  query logic components

Question 10

How the database results are read into memory is determined by:

Accepted Answer

A)  the program. 
B)  the database driver. 
C)  the operating system. 
D)  none of the above. 
A)  the program. 
B)  the database driver. 
C)  the operating system. 
D)  none of the above.

Question 11

A fat client does most of its processing on the server.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is a component of processing logic?

Accepted Answer

A)  Input 
B)  Output 
C)  Retrieval 
D)  Business rules 
A)  Input 
B)  Output 
C)  Retrieval 
D)  Business rules

Question 13

Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server, depending upon which location will give the best performance.

Accepted Answer

A) True 
 B)False

Question 14

What are the most important security features for data management software?

Accepted Answer

The most important security features of

Question 15

Security measures for dynamic Web pages are different from static HTML pages because:

Accepted Answer

A)  dynamic Web pages are built "on the fly." 
B)  static Web pages contain more sensitive data. 
C)  the connection requires full access to the database for dynamic pages. 
D)  HTML is more complex than dynamic Web pages. 
A)  dynamic Web pages are built "on the fly." 
B)  static Web pages contain more sensitive data. 
C)  the connection requires full access to the database for dynamic pages. 
D)  HTML is more complex than dynamic Web pages.

Question 16

Durability means that:

Accepted Answer

A)  transactions can't be erased. 
B)  once a transaction is committed, no subsequent failure of the database can reverse the effect of the transaction. 
C)  transactions can withstand failure. 
D)  transactions never finish on time. 
A)  transactions can't be erased. 
B)  once a transaction is committed, no subsequent failure of the database can reverse the effect of the transaction. 
C)  transactions can withstand failure. 
D)  transactions never finish on time.

Question 17

Loss of data integrity means that someone has stolen data from the database server.

Accepted Answer

A) True 
 B)False

Question 18

Since dynamic Web pages require full access to the database, security is different from static HTML pages.

Accepted Answer

A) True 
 B)False

Question 19

Discuss some of the key benefits of three-tier applications.

Accepted Answer

Three-tier applications can lead to seve

Question 20

A client PC that is responsible for processing presentation logic, extensive application and business rules logic, and many DBMS functions is called a(n):

Accepted Answer

A)  server. 
B)  fat client. 
C)  thin client. 
D)  workstation. 
A)  server. 
B)  fat client. 
C)  thin client. 
D)  workstation.

A client PC that is responsible for processing presentation logic, extensive application and business rules logic, as well as many DBMS functions is called a:

Loss of confidentiality is a threat that involves outside parties using information to embarrass a company.

What threats to data security must be addressed in a comprehensive data security plan?

________ is the process of assigning pieces of application code to clients or servers.

The Magna Carta is the W3C standard for Web privacy.

A data-interchange format easily for humans to read and machines to parse and process is called:

An application server

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

The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers.

How the database results are read into memory is determined by:

A fat client does most of its processing on the server.

Which of the following is a component of processing logic?

Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server, depending upon which location will give the best performance.

What are the most important security features for data management software?

Security measures for dynamic Web pages are different from static HTML pages because:

Durability means that:

Loss of data integrity means that someone has stolen data from the database server.

Since dynamic Web pages require full access to the database, security is different from static HTML pages.

Discuss some of the key benefits of three-tier applications.

A client PC that is responsible for processing presentation logic, extensive application and business rules logic, and many DBMS functions is called a(n):

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 client PC that is responsible for processing presentation logic, extensive application and business rules logic, as well as many DBMS functions is called a:

Loss of confidentiality is a threat that involves outside parties using information to embarrass a company.

What threats to data security must be addressed in a comprehensive data security plan?

________ is the process of assigning pieces of application code to clients or servers.

The Magna Carta is the W3C standard for Web privacy.

A data-interchange format easily for humans to read and machines to parse and process is called:

An application server

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

The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers.

How the database results are read into memory is determined by:

A fat client does most of its processing on the server.

Which of the following is a component of processing logic?

Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server, depending upon which location will give the best performance.

What are the most important security features for data management software?

Security measures for dynamic Web pages are different from static HTML pages because:

Durability means that:

Loss of data integrity means that someone has stolen data from the database server.

Since dynamic Web pages require full access to the database, security is different from static HTML pages.

Discuss some of the key benefits of three-tier applications.

A client PC that is responsible for processing presentation logic, extensive application and business rules logic, and many DBMS functions is called a(n):

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