Chapter 8 Quiz

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

API

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

Convert to text

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

Document Type Declarations (DTDs).

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.

For, LET, Where OrderBy, Return.

If you write a database application in a Java program, you are most likely to use the ________ API. A. ADO .NET B. JDBC C. ODBC D. JSP

JDBC

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. integration with MySQL functions.

Microsoft integration

Which language would you expect to see in a stored procedure? A. XML B. Java C. PL/SQL D. VB .NET

PL/SQL

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.

Performance improves for compiled SQL statements

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.

Simple Object Access Protocol Method.

Which of the following is false about three-tier architectures? A.More scalable than two-tier architectures B. Business rules often done in middle tier C.Tends to involve fatter clients than two-tier architectures D.Typically done in a Web environment

Tends to involve fatter clients than two-tier architectures

Which of the following is an INCORRECT statement about stored procedures? A. Writing applications with stored procedures often takes more time than writing an application in Java or C#. B. There can be significant network traffic increases using stored procedures as processing moves from client to server. C. Stored procedures are proprietary and not easy to move from one RDBMS to another. D. Security and data integrity can be enhanced using stored procedures.

There can be significant network traffic increases using stored procedures as processing moves from client to server.

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.

UDDI.

________ is a scripting language that allows for the creation of customized tags, and is often used to facilitate exchange of data between applications over the Web.

XML

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

XML.

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

XQuery

An XML transformation language that allows applications to query both XML data and relational databases is called: A. Xtransform. B. Xstation. C. Xdatabase. D. XQuery.

XQuery.

________ 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

XSLT

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. architecture designed for Schools of Accountancy (SOA).

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

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. a special SQL command to JOIN tables.

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: A. a 3GL language. B. an XML-based vocabulary. C. a legacy database application. D. a special SQL command to JOIN tables.

an XML-based vocabulary.

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

application logic components

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

application partitioning

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.

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

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

business rules

The the main idea behind ________ computing refers to a model for providing ubiquitous, convenient and on-demand access to shared computing resources.

cloud

A(n) _______ client is a PC that is responsible for processing presentation logic, extensive application and business rules logic and even DBMS functions.

fat

All of the following are characteristics of cloud technologies EXCEPT: A. infinite bandwidth. B. on-demand self-service IT capabilities. C. broad network access. D. rapid elasticity.

infinite bandwidth.

________ 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

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.

processes client requests and returns HTML pages to the client.

XPath and XQuery are both technologies used to: A. create XML documents. B. transform XML documents to relational databases. C. retrieve data from XML documents. D. store XML data into relational databases.

retrieve data from XML documents.

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.

stored in a relational table.

A(n) ________ is a module of code written in SQL or some proprietary language to run business rules from within a database server. A. application server B. middleware API C. servlet D. stored procedure

stored procedure

A PC configured to handle user interface with little or no local storage is called a(n) _______ client.

thin

Cloud computing relies most heavily on: A. two-tier architectures. B. local area networks. C. standalone PCs. D. three-tier architectures.

three-tier architectures.