Modern Database Management - Self Check 08

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

False

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

ODBC

Web services allow for communication between programs over the Internet

True

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

Application Programming Interfaces

A ________ is a language used for defining XML databases

DTD

________ is a rapidly developing scripting language that allows for the creation of customized tags that can be used across applications

Extensible Markup Language

A language used to transform complex XML documents and also used to create HTML pages from XML documents is called ________.

Extensible Stylesheet Language Transformation

A fat client does most of its processing on the server

F..... ffawuuuck this class

An XML Schema is a language used to define HTML

False

SOAP is an insignificant Web standard.

False

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

False

UDDI stands for Underwritten Data Dictionary Inquiry

False

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

False

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

Open database connectivity

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

Service-oriented architecture (SOA)

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

Shredding

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

Storage Logic

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

True

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

True

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.

True

PHP is a platform for Web development.

True

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

True

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

True

________ is an XML-based grammar.

Web Services Description Language (WSDL)

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

Web services

A(n) ________ is a language used for defining XML databases

XML Schema Definition

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

application logic components

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

application partitioning

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

database server

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

fat client

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

servlets

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

thin client

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

three-tier architecture

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

Application program interface (API)

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

Client/server

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

False

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

False

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

False

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

False

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

False

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

False

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

False

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

False

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

False

XQuery is an HTML transformation language used to query HTML pages

False

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

Stored procedure

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

True

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

True

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.

True

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

True

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

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

Web Services Description Language is an XML-based grammar

True

Simple Object Access Protocol (SOAP) is an ________ communication protocol

XML-Based

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

XQuery