Part 8

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

________ 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

________ 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) Extensible Markup Language

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

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.

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.

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.

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.

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.

________ 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

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

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

B) grid computing

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.

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

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.

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

________ 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) Shredding

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.

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.

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

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

D) Business rules

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.

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.

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 DTD is a language used for defining XML databases.

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

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

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

WXDL is an XML-based grammar.

False

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

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

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

True

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

True

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

True