Deck 8: Database Application Development

Question 1

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

Answer 1

A

Question 2

________ is 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

Answer 2

B

Question 3

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.

Answer 3

A

Question 4

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

Question 5

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.

Question 6

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.

Question 7

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.

Question 8

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.

Question 9

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

Question 10

Which of the following is a component of processing logic?

A) Input
B) Output
C) Retrieval
D) Business rules

Question 11

A device that manages file operations and is shared by each client PC on a LAN is called a:

A) file server.
B) file processor.
C) database server.
D) fat client.

Question 12

________ 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

Question 13

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.

Question 14

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.

Question 15

HTML is an acronym for:

A) Hypertext Manipulation Language.
B) Hot Type Markup Language.
C) Hyperbolic Mechanical Language.
D) Hypertext Markup Language.

Question 16

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

Question 17

All of the following are common Web server interfaces EXCEPT:

A) Common Gateway Interface (CGI).
B) Hypertext Markup Language.
C) Application Program Interface (API).
D) Java servlets.

Question 18

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.

Question 19

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

Question 20

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

Question 21

All of the following are concerns about developing a Web services approach EXCEPT:

A) transaction speed.
B) user acceptability.
C) security.
D) reliability.

Question 22

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

Question 23

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.

Question 24

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.

Question 25

Which if 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

Question 26

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.

Question 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

Question 28

________ facilitates the ability of applications to query relational data along with associated structured data.

A) XPath
B) XQuery
C) XSLT
D) SOAP

Question 29

________ 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

Question 30

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.

Question 31

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

Question 32

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.

Question 33

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

Question 34

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

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

Question 36

The promise of Web services is the development of a standardized communication system using ________.

A) HTML
B) XST
C) XML
D) XPath

Question 37

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

Question 38

The XML shown in the figure below,describes some data from the Pinevalley 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

Question 39

Extensible Business Reporting Languge (XBRL)is an example of:

A) a 3GL language.
B) an XML-based vocabulary.
C) a legacy database application.
D) none of the above.

Question 40

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

Question 41

Hypertext Transfer Protocol (HTTP)is a communications protocol used to transfer browser requests to a Web server and to transfer pages from the Web server back to the browser.

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

An XML Schema is a language used to define HTML.

Question 47

VBScript is a scripting language based upon Java that is used to achieve interactivity on Web pages.

Question 48

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

Question 49

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

Question 50

The fundamental authoring language used to create documents for the Web is SGML,an acronym for Standard Generalized Markup Language.

Question 51

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

Question 52

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

Question 53

PHP is a platform for Web development.

Question 54

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

Question 55

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

Question 56

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.

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

UDDI stands for Underwritten Data Dictionary Inquiry.

Question 62

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

Question 63

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

Question 64

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

Question 65

Web services allow for communication between programs over the Internet.

Question 66

Web Services Description Language is an XML-based grammar.

Question 67

A PC configured to handle user interfaces with limited local storage is called a ________.

Question 68

A computer that provides database storage and access in a client/server environment is called a ________.

Question 69

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

Question 70

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

Question 71

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

Question 72

The ________ specification allows drivers to conform to various levels of the specification,and that affects the level of functionality of the drivers.

Question 73

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

Question 74

Sets of routines that an application program uses to direct the performance of procedures by the computer's operating system is called a(n)________.

Question 75

SOAP is an insignificant Web standard.

Question 76

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

Question 77

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

Question 78

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

Question 79

The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers.

Question 80

________ describes a networked computing model that distributes processes between computers that request services and computers that provide services.