Chapter 8

Question 1

Which of the following have affected the way businesses use computing systems to meet the demand of the competitive marketplace?

Answer 1

A) GUI evolutions B) Networking advances C) Communication changes D) All of the above

Question 2

2) Which of the following is a component of processing logic?

Answer 2

D) Business rules

Question 3

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(n):

Answer 3

D) fat client.

Question 4

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

Answer 4

A) Application partitioning

Question 5

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

Answer 5

A) Fat client

Question 6

________ is/are any of several classes of software that allow an application to interoperate with other software without requiring the user to understand all software involved.

Answer 6

B) Middleware

Question 7

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

Answer 7

A) API

Question 8

An application programming interface that enables an application program to process RDBMS databases meets the:

Answer 8

B) open database connectivity standard.

Question 9

A PC configured to handle user interface with little or no local storage is called a:

Answer 9

C) thin client.

Question 10

A Web server:

Answer 10

B) processes client requests and returns HTML pages to the client.

Question 11

The main difference between Java applets and Java servlets is:

Answer 11

B) servlets are stored on the server while applets are stored on the client.

Question 12

Java servlets:

Answer 12

A) are small programs that execute from within another application rather than from the operating system.

Question 13

PHP is a popular API for MySQL because of all of the following EXCEPT:

Answer 13

A) Microsoft integration.

Question 14

A(n) ________ is a module of code written in SQL or some proprietary language to run business rules on a server.

Answer 14

D) stored procedure

Question 15

Which of the following is an advantage of stored procedures?

Answer 15

D) Performance improves for compiled SQL statements.

Question 16

Which of the following is not a disadvantage of stored procedures?

Answer 16

B) Decreases in network traffic are realized.

Question 17

Which of the following is true about three-tier architectures?

Answer 17

C) More technological flexibility

Question 18

An emerging trend likely to have an effect on the development of three-tier applications is called:

Answer 18

C) cloud computing.

Question 19

All of the following are characteristics of cloud technologies EXCEPT:

Answer 19

A) unlimited bandwidth.

Question 20

Extensible Markup Language (XML) is:

Answer 20

A) a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations.

Question 21

Extensible Business Reporting Language (XBRL) is an example of:

Answer 21

B) an XML-based vocabulary.

Question 22

________ facilitates the ability of applications to query relational data along with associated structured data.

Answer 22

A) XPath

Question 23

All of the following are newer XML schema languages EXCEPT:

Answer 23

A) Document Type Declarations (DTDs).

Question 24

When an XML document is shredded, each element is:

Answer 24

C) stored in a relational table.

Question 25

Which of the following is NOT a method for storing XML documents?

Answer 25

D) Convert to text

Question 26

FLWOR is an acronym for:

Answer 26

B) For, LET, Where OrderBy, Return.

Question 27

\_\_\_\_\_\_\_\_ is a language used to transform complex XML documents and also to create HTML pages from XML documents.

Answer 27

B) XSLT

Question 28

Web services:

Answer 28

B) are a set of emerging standards for protocols for automatic communication between software over the Web.

Question 29

The promise of Web services is the development of a standardized communication system using:

Answer 29

C) XML.

Question 30

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

Answer 30

TRUE

Question 31

Business rules logic includes such activities as data validation and identification of processing errors.

Answer 31

FALSE

Question 32

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

Answer 32

TRUE

Question 33

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

Answer 33

FALSE

Question 34

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.

Answer 34

TRUE

Question 35

When developing an application, one must decide where it will be placed when it is developed.

Answer 35

FALSE

Question 36

An API is a set of routines that a database server uses to access database objects.

Answer 36

FALSE

Question 37

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.

Answer 37

TRUE

Question 38

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

Answer 38

TRUE

Question 39

Java servlets execute from within another program and reside on the server.

Answer 39

TRUE

Question 40

PHP is a platform for Web development.

Answer 40

TRUE

Question 41

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

Answer 41

FALSE

Question 42

Three-tier architectures generally result in higher long-term costs.

Answer 42

FALSE

Question 43

Cloud computing will have a limited impact on three-tier applications.

Answer 43

FALSE

Question 44

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

Answer 44

TRUE