Ch8. Database Application Development

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

4) ________ 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) Application partitioning

24) 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) Document Type Declarations (DTDs).

5) 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) Fat client

32) 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) Web Service Description Language (WSDL).

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

A) XPath

12) 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) are small programs that execute from within another application rather than from the operating system.

19) 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) unlimited bandwidth.

16) 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) Decreases in network traffic are realized.

27) 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) For, LET, Where OrderBy, Return.

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

B) Middleware

28) ________ 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) XSLT

35) 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) a collection of services that communicate with each other in some manner.

21) 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) an XML-based vocabulary.

29) 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) are a set of emerging standards for protocols for automatic communication between software over the Web.

8) 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) open database connectivity standard.

10) 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) processes client requests and returns HTML pages to the client.

11) 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) servlets are stored on the server while applets are stored on the client.

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

B) user acceptability.

17) 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) More technological flexibility

31) 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) UDDI.

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

C) XML.

18) 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) cloud computing.

25) 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) stored in a relational table.

22) The XML shown in the figure below describes some data from the Pine Valley Furniture case study. 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 standard price of products with a cherry finish.

9) 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) thin client.

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

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

D) Business rules

26) 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) Convert to text

15) 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) Performance improves for compiled SQL statements.

34) 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) Simple Object Access Protocol Method.

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

D) fat client.

14) 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) stored procedure

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

false

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

false

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

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

13) 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) Microsoft integration.

20) 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) a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations