Deck 8: Database Application Development

Question 1

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.

Answer 1

C

Question 2

A computer that provides database storage and access in a client/server environment is called a(n):

A) database server.
B) file server.
C) cloud data store.
D) info server.

Answer 2

A

Question 3

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

Answer 3

B

Question 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

Question 5

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.

Question 6

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) only applets will run on Macintosh systems.

Question 7

________ 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

Question 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

Question 9

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) database server.
D) fat client.

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

Question 11

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 12

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 13

Which of the following is a component of processing logic?

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

Question 14

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.

Question 15

Which of the following is true about three-tier architectures?

A) Less scalable than two-tier
B) Increased risk
C) More technological flexibility
D) Requires a Mac

Question 16

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

Question 17

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

Question 18

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 19

A PC configured to handle user interfaces with limited local storage is called a(n):

A) fat client.
B) thin client.
C) light client.
D) overweight client.

Question 20

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) application program interface.
B) xpi.
C) application device interface.
D) CMOS.

Question 21

The XML shown in the figure below describes some data from the Pine Valley Furniture case study.
What does the following 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

Question 22

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 23

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.

Question 24

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

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

Question 25

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.

Question 26

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.

Question 27

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

________ 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

Question 29

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 30

________ is a method to store XML documents by storing each element independently in a relational table.

A) Writing
B) Sledding
C) Shredding
D) Shedding

Question 31

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 32

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

Question 33

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 34

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.

Question 35

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

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

Question 36

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.

Question 37

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) persistent module.
B) function.
C) application component.
D) stored procedure.

Question 38

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 39

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

Question 40

XQuery can be used to transform XML into:

A) XPath.
B) XQuery.
C) XMILL.
D) XHTML.

Question 41

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 42

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

Question 43

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

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

Question 44

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 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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 50

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 51

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

Question 52

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 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

PHP is a platform for Web development.

Question 60

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 61

All .html files can be processed by the web server itself.

Question 62

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.

Question 63

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

Question 64

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

Question 65

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

Question 66

Infrastructure-as-a-Service refers to the use of technologies such as servers, storage and networks from external service providers.

Question 67

Cloud computing will have a limited impact on three-tier applications.

Question 68

An XML Schema is a language used to define HTML.

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

An HTTP Schema Definition is a language used for defining XML databases.

Question 75

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

Question 76

Software as a service (SAAS) refers to an entire application or suite of applications running on the cloud.

Question 77

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

Question 78

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

Question 79

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

Question 80

Data returned on a web server is always in XML.