CH8

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

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

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

A) Microsoft integration. B) high performance. C) easy to use. D) MySQL connectivity built-in. **A

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

Application partitioning

Which of the following is a component of processing logic?

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

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

Convert to text

All of the following are newer XML schema languages EXCEPT:

DTD - Not a schema language

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

Fat client

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

Fat client

FLWOR is an acronym for:

For, LET, Where OrderBy, Return.

________ 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.

Middleware

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

More technological flexibility **NOT all of the above

Which of the following is an advantage of stored procedures?

Performance improves for compiled SQL statements.

SOAP stands for:

Simple Object Access Protocol Method

When an XML document is shredded, each element is:

Stored in a relational table

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

Stored procedure

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

TRUE

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

Thin client

A technical specification for creating a distributed registry of Web services and businesses that are open to communicating through Web services is called:

UDDI

All of the following are concerns about developing a Web services approach EXCEPT:

User acceptability

An XML-based grammar used to describe a Web service is called:

Web Service Description Language (WSDL).

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

XLST

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

XML

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

XPath

Service-oriented architectures (SOA) are:

a collection of services that communicate with each other in some manner.

Extensible Markup Language (XML) is:

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

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

an XML based vocabulary

Web services:

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

Java servlets:

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

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

cloud computing.

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

open database connectivity standard.

A Web server:

processes client requests and returns HTML pages to the client.

The main difference between Java applets and Java servlets is:

servlets are stored on the server while applets are stored on the client

The following XPath expression returns for results: /furniturecompany/product/[finish = "Cherry"]/standardprice

the standard price of products with a cherry finish.

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

A) Writing stored procedures takes more time than writing an application in Visual Basic or PowerBuilder. B) Decreases in network traffic are realized. C) Stored procedures are proprietary and not easy to move from one RDBMS to another. D) Each client must be loaded with the application to be used at that location. **B

All of the following are characteristics of cloud technologies EXCEPT:

A) unlimited bandwidth. B) on-demand self-service IT capabilities. C) broad network access. D) rapid elasticity. **A is not true

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

API