Chapter 15

Question 1

ODBC, OLE-DB, and ADO.NET form the backbone of the _____ architecture.

Answer 1

UDA

Question 2

Open Database Connectivity (ODBC), a superset of the SQL Access Group Call Level Interface
(CLI), is implemented by _____.

Answer 2

Microsoft

Question 3

A(n) _____ is a unique name by which the data source will be known to ODBC, and therefore, to
applications.

Answer 3

DSN

Question 4

In the context of OLE-DB, a _____ is an object (application or process) that requests and uses
data.

Answer 4

Consumer

Question 5

In the OLE-DB model, the _____ acts like a data consumer of the data provider and as a data
provider for the data consumer (end-user application).

Answer 5

Service Provider

Question 6

A(n) _____ is a program written in a programming language that is not compiled, but is
interpreted and executed at run time.

Answer 6

Script

Question 7

_____ provides a unified interface to access data from any programming language that uses the
underlying OLE-DB objects.

Answer 7

ActiveX Data Objects

Question 8

The Microsoft _____ framework is a component-based platform for developing distributed,
heterogeneous, interoperable applications aimed at manipulating any type of data over any
network under any operating system and any programming language.

Answer 8

.NET

Question 9

_____ is an application programming interface that allows a Java program to interact with a wide
range of data sources (relational databases, tabular data sources, spreadsheets, and text files).

Answer 9

Java Database Connectivity JDBC

Question 10

_____ webpages are at the heart of current generation websites.

Answer 10

Dynamic

Question 11

APIs are faster than _____ scripts because the code resides in memory and there is no need to run
an external program for each request.

Answer 11

CGI (Common Gateway Interface)

Question 12

Regardless of the type of web server interface used, a web-to-database _____ program must be
able to connect with a database.

Answer 12

Middleware

Question 13

A web _____ server is a middleware application that expands the functionality of web servers by
linking them to a wide range of services.

Answer 13

Application

Question 14

To prevent the server from performing all data validation, _____ data input validation is one of
the most basic requirements for web applications.

Answer 14

Client-side

Question 15

_____, or transactions done over the Internet, enables all types of organizations to sell products
and services to a global market.

Answer 15

E-Commerce

Question 16

XML is derived from the _____, an international standard for the publication and distribution of
highly complex technical documents.

Answer 16

SGML (Standard Generalized Markup Language)

Question 17

XML tags must be well formed, that is, each opening tag must have a corresponding _____ tag.

Answer 17

Closing

Question 18

A(n) _____ provides limited additional semantic value to XML, such as data type support or data
validation rules

Answer 18

DTD (Document Type Definition)

Question 19

A DBMS that supports _____ exchanges can integrate with external systems such as the web,
mobile data, and legacy systems, thus enabling the creation of new types of systems.

Answer 19

XML

Question 20

XML is used to create _______ vocabularies for entire industries.

Answer 20

Metadictionaries