Chapter 8 Quiz STUDY

d. thin client.

A PC configured to handle user interface with little or no local storage is called a: a. server. b. fat client. c. workstation. d. thin client.

b. thin client.

A PC configured to handle user interfaces with limited local storage is called a(n): a. light client. b. thin client. c. fat client. d. overweight client.

c. processes client requests and returns HTML pages to the client.

A Web server: a. always contains a database. b. is considered to be part of the firewall. c. processes client requests and returns HTML pages to the client. d. is used only to host Web pages.

c. fat client.

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: a. file server. b. file processor. c. fat client. d. database server.

c. database server.

A computer that provides database storage and access in a client/server environment is called a(n): a. cloud data store. b. info server. c. database server. d. file server.

a. stored procedure.

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(n): a. stored procedure. b. application component. c. persistent module. d. function.

b. UDDI.

A technical specification for creating a distributed registry of Web services and businesses that are open to communicating through Web services is called: a. XML. b. UDDI. c. B2B. d. HTML.

b. stored procedure

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

a. API

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. LAN d. RPC

c. unlimited bandwidth.

All of the following are characteristics of cloud technologies EXCEPT: a. rapid elasticity. b. broad network access. c. unlimited bandwidth. d. on-demand self-service IT capabilities.

b. user acceptability.

All of the following are concerns about developing a Web services approach EXCEPT: a. transaction speed. b. user acceptability. c. security. d. reliability.

d. Document Type Declarations (DTDs).

All of the following are newer XML schema languages EXCEPT: a. Document Structure Description (DSD). b. XML Schema Definition (XSD). c. RELAX NG. d. Document Type Declarations (DTDs).

c. XQuery.

An XML transformation language that allows applications to query both XML data and relational databases is called: a. Xstation. b. Xtransform. c. XQuery. d. Xdatabase.

c. Web Service Description Language (WSDL).

An XML-based grammar used to describe a Web service is called: a. WIDL. b. Business-to-Business (B2B). c. Web Service Description Language (WSDL). d. WISL.

c. open database connectivity standard.

An application programming interface that enables an application program to process RDBMS databases meets the: a. multi-platform connectivity standard. b. object linking and embedding standard. c. open database connectivity standard. d. open source standard.

d. cloud computing.

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. wide-area storage. d. cloud computing.

b. an XML-based vocabulary.

Extensible Business Reporting Language (XBRL) is an example of: a. a 3GL language. b. an XML-based vocabulary. c. a legacy database application. d. a special SQL command to JOIN tables.

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

Extensible Markup Language (XML) is: a. a special SQL command to JOIN tables. b. a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations. c. a product used for database middleware. d. a database language.

b. For, LET, Where OrderBy, Return.

FLWOR is an acronym for: a. flowers. b. For, LET, Where OrderBy, Return. c. For, Locate, Work, Order, Results. d. First, Let, Work, Order, Results.

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

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

d. Microsoft integration.

PHP is a popular API for MySQL because of all of the following EXCEPT: a. easy to use. b. MySQL connectivity built-in. c. high performance. d. Microsoft integration.

a. Simple Object Access Protocol Method.

SOAP stands for: a. Simple Object Access Protocol Method. b. Simple ODBC Access Protocol. c. Strategic Operational Advanced Planning. d. what you wash your hands with.

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

Service-oriented architectures (SOA) are: a. a set of tiers designed to serve each other. b. architecture designed for the military. c. architecture designed for Schools of Accountancy (SOA). d. a collection of services that communicate with each other in some manner.

b. application program interface.

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. CMOS. b. application program interface. c. application device interface. d. xpi.

d. ODBC

The ________ specification allows drivers to conform to various levels of the specification, and that affects the level of functionality of the drivers. a. Cobra b. JDBC c. CORBA d. ODBC

b. application logic components

The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers. a. query logic components b. application logic components c. files d. memory

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

The main difference between Java applets and Java servlets is: a. both applets and servlets are executed and stored on the server. b. only applets will run on Macintosh systems. c. applets are stored on the client but executed on the server. d. servlets are stored on the server while applets are stored on the client.

b. cloud computing

The phrase ________ refers to a model for providing ubiquitous, convenient and on-demand network access. a. grid computing b. cloud computing c. network computing d. software services

a. XML.

The promise of Web services is the development of a standardized communication system using: a. XML. b. XPath. c. XST. d. HTML.

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

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. are still conceptual and yet to be created.

c. The standard price of products with a cherry finish

What does the following XPath expression return? /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

d. stored in a relational table.

When an XML document is shredded, each element is: a. thrown away. b. split up. c. added to other XML documents. d. stored in a relational table.

c. Tall client

Which of the following is NOT a common distribution logic for two-tiered server environments? (course hero was wrong, says it's Fat) a. Fat client b. Thin client c. Tall client d. Distributed

a. Decreases in network traffic are realized.

Which of the following is NOT a disadvantage of stored procedures? a. Decreases in network traffic are realized. b. Each client must be loaded with the application to be used at that location. c. Stored procedures are proprietary and not easy to move from one RDBMS to another. d. Writing stored procedures takes more time than writing an application in Visual Basic or PowerBuilder.

b. Convert to text

Which of the following is NOT a method for storing XML documents? a. Shredding b. Convert to text c. Use an XML native database d. Use a BLOB or CLOB to store the entire XML file

b. Business rules

Which of the following is a component of processing logic? a. Output b. Business rules c. Retrieval d. Input

a. Performance improves for compiled SQL statements.

Which of the following is an advantage of stored procedures? a. Performance improves for compiled SQL statements. b. Stored procedures result in fatter clients. c. Data integrity improves when fewer applications access the procedure. d. The layers get cleaner.

d. More technological flexibility

Which of the following is true about three-tier architectures? a. Requires a Mac b. Increased risk c. Less scalable than two-tier d. More technological flexibility

c. XHTML.

XQuery can be used to transform XML into: a. XPath. b. XQuery. c. XHTML. d. XMILL.

d. XPath

________ facilitates the ability of applications to query relational data along with associated structured data. a. SOAP b. XSLT c. XQuery d. XPath

d. XSLT

________ is a language used to transform complex XML documents and also to create HTML pages from XML documents. a. HTML b. WSL c. SGI d. XSLT

a. Shredding

________ is a method to store XML documents by storing each element independently in a relational table. a. Shredding b. Shedding c. Sledding d. Writing

c. Extensible Markup Language

________ is a rapidly developing scripting language that allows for the creation of customized tags that can be used across applications. a. CGI b. SGL c. Extensible Markup Language d. HTML

c. Application partitioning

________ is the process of assigning pieces of application code to clients or servers. a. Modularizing programs b. Code distribution c. Application partitioning d. Program breakup

c. Middleware

________ 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. Interface managers c. Middleware d. MPP