Chapter 8 quiz

A(n) ________ is a module of code written in SQL or some proprietary language to run business rules on a server. A) SQL program B) select module C) select procedure D) stored procedure

D

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

False

Lack of secure standards and lack of user acceptance are the major issues that must be resolved with Web services.

False

XML uses bcode, long commands embedded in quotes, to characterize data.

False

Application Programming Interfaces are more efficient than CGI scripts and are implemented as shared code or dynamic link libraries.

True

A computer that provides database storage and access in a client/server environment is called a: A) database server. B) file server. C) cloud data store. D) none of the above.

A

A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system. A) API B) MOM C) RPC D) LAN

A

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

All of the following are newer XML schema languages EXCEPT: A) Document Type Declarations (DTDs). B) XML Schema Definition (XSD). C) RELAX NG. D) Document Structure Description (DSD).

A

Which of the following is not a common distribution logic for two-tiered server environments? A) Fat client B) Tall client C) Thin client D) Distributed

A

________ facilitates the ability of applications to query relational data along with associated structured data. A) XPath B) XQuery C) XSLT D) SOAP

A

________ is a rapidly developing scripting language that allows for the creation of customized tags that can be used across applications. A) Extensible Markup Language B) HTML C) SGL D) CGI

A

________ is the process of assigning pieces of application code to clients or servers. A) Application partitioning B) Modularizing programs C) Code distribution D) Program breakup

A

A PC configured to handle user interfaces with limited local storage is called a: A) fat client. B) thin client. C) light client. D) overweight client.

B

________ is a language used to transform complex XML documents and also to create HTML pages from XML documents. A) HTML B) XSLT C) SGI D) WSL

B

________ 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. A) User interface enhancers B) Middleware C) Interface managers D) MPP

B

A PC configured to handle user interface with little or no local storage is called a: A) server. B) fat client. C) thin client. D) workstation.

C

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

False

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

False

SOAP is an insignificant Web standard.

False

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

False

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

False

UDDI stands for Underwritten Data Dictionary Inquiry.

False

WXDL is an XML-based grammar.

False

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

True

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

True

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.

True

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

True

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.

True

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.

True

PHP is a platform for Web development.

True

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

True

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

True

XML addresses the structuring and manipulation of information in a Web browser.

True

XQuery is an XML transformation language for querying relational data as well as XML databases.

True

An XML-based grammar used to describe a Web service is called: A) Web Service Description Language (WSDL). B) WIDL. C) WISL. D) Business-to-Business (B2B).

A

Extensible Markup Language (XML) is: A) a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations. B) a database language. C) a product used for database middleware. D) none of the above.

A

Java servlets: A) are small programs that execute from within another application rather than from the operating system. B) must be executed each time a user makes a request. C) are stored on the client. D) are implemented as dynamic link libraries (DLLs).

A

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

Sets of routines that an application program uses to direct the performance of procedures by the computer's operating system is called a(n): A) application program interface. B) xpi. C) application device interface. D) CMOS.

A

A Web server: A) is used only to host Web pages. B) processes client requests and returns HTML pages to the client. C) always contains a database. D) is considered to be part of the firewall.

B

All of the following are concerns about developing a Web services approach EXCEPT: A) transaction speed. B) user acceptability. C) security. D) reliability

B

An application programming interface that enables an application program to process RDBMS databases meets the: A) object linking and embedding standard. B) open database connectivity standard. C) multi-platform connectivity standard. D) open source standard.

B

Extensible Business Reporting Language (XBRL) is an example of: A) a 3GL language. B) an XML-based vocabulary. C) a legacy database application. D) none of the above.

B

FLWOR is an acronym for: A) flowers. B) For, LET, Where OrderBy, Return. C) For, Locate, Work, Order, Results. D) none of the above.

B

Service-oriented architectures (SOA) are: A) a set of tiers designed to serve each other. B) a collection of services that communicate with each other in some manner. C) architecture designed for the military. D) none of the above.

B

The ________ specification allows drivers to conform to various levels of the specification, and that affects the level of functionality of the drivers. A) JDBC B) ODBC C) CORBA D) Cobra

B

The main difference between Java applets and Java servlets is: A) applets are stored on the client but executed on the server. B) servlets are stored on the server while applets are stored on the client. C) both applets and servlets are executed and stored on the server. D) none of the above.

B

Web services: A) are a set of services available to all on the Web. B) are a set of emerging standards for protocols for automatic communication between software over the Web. C) are a set of standards based upon HTML. D) none of the above.

B

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

A technical specification for creating a distributed registry of Web services and businesses that are open to communicating through Web services is called: A) HTML. B) B2B. C) UDDI. D) XML.

C

An emerging trend likely to have an effect on the development of three-tier applications is called: A) corporate computing. B) local area networks. C) cloud computing. D) wide-area storage.

C

The XML shown in the figure below describes some data from the Pine Valley Furniture case study. (INSERT PHOTO HERE) The following XPath expression returns for results: /furniturecompany/product/[finish = "Cherry"]/standardprice A) all products with a cherry finish. B) a description of all products with a cherry finish. C) the standard price of products with a cherry finish. D) nothing.

C

The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers. A) memory B) files C) application logic components D) query logic components

C

The promise of Web services is the development of a standardized communication system using: A) HTML. B) XST. C) XML. D) XPath.

C

When an XML document is shredded, each element is: A) thrown away. B) split up. C) stored in a relational table. D) added to other XML documents.

C

Which of the following is true about three-tier architectures? A) Less scalable than two-tier B) Increased risk C) More technological flexibility D) All of the above

C

________ is a method to store XML documents by storing each element independently in a relational table. A) Writing B) Sledding C) Shredding D) Shedding

C

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): A) file server. B) file processor. C) database server. D) fat client.

D

A module of code that may be written in a proprietary language such as Oracle's PL/SQL that implements business rules on a database server is called a: A) persistent module. B) function. C) application component. D) stored procedure.

D

SOAP stands for: A) what you wash your hands with. B) Simple ODBC Access Protocol. C) Strategic Operational Advanced Planning. D) Simple Object Access Protocol Method.

D

The phrase ________ refers to a model for providing ubiquitous, convenient and on-demand network access. A) software services B) grid computing C) network computing D) cloud computing

D

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 D) All of the above

D

Which of the following is NOT a method for storing XML documents? A) Shredding B) Use a BLOB or CLOB to store the entire XML file C) Use an XML native database D) Convert to text

D

Which of the following is a component of processing logic? A) Input B) Output C) Retrieval D) Business rules

D

Which of the following is an advantage of stored procedures? A) Data integrity improves when fewer applications access the procedure. B) The layers get cleaner. C) Stored procedures result in fatter clients. D) Performance improves for compiled SQL statements.

D

A DTD is a language used for defining XML databases.

False

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

False

A language used to transform complex XML documents and also used to create HTML pages from XML documents is called Extensible Stylesheet Transformation.

False

A(n) HTTP Schema Definition is a language used for defining XML databases.

False

An XML Schema is a language used to define HTML.

False

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

False

Customer-oriented architectures are a collection of services that communicate with each other in some manner.

False

Even with XML, different types of devices will require a different page.

False

Infrastructure-as-a-Service refers to the use of technologies such as servers, storage and networks from external service providers.

False

Java programs similar to applets that execute on the server are called hamlets.

False

Stripping an XML document means storing each element of an XML schema in a relational table and using other tables to store the elements.

False

The process of assigning parts of an application to a client or server is called application partitioning.

False

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

False

XML-based vocabularies, such as XBRL, do not allow meaningful comparisons to be made of data across many organizations.

False

XQuery is an HTML transformation language used to query HTML pages.

False

Document Type Declarations (DTDs) are unable to specify data types.

True

Extensible Markup Language (XML) is a scripting language based upon SGML that allows the creation of customized tags.

True

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

True

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

True

Simple Object Access Protocol (SOAP) is an XML-Based communication protocol.

True

Software as a service (SAAS) refers to an entire application or suite of applications running on the cloud.

True

Storing XML data is becoming a big question as XML data becomes more prevalent.

True

Web Services Description Language is an XML-based grammar.

True

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

True

Web services allow for communication between programs over the Internet.

True