Exam 14: Database Connectivity and Web Technologies

code is embedded inside an HTML page and is activated by triggering events such as clicking on a link.

A document type definition (DTD) can be referenced by many Extensible Markup Language (XML) documents of the same type.

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

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

In the ODBC architecture, a(n) is in charge of managing all database connections.

APIs are implemented as dynamic-link libraries that are dynamically invoked when needed.

When an end user uses a web browser to dynamically query a database, the client browser actually requests a web page from the web server.

A(n) can use a shared connection to the database instead of creating a new one every time.

The effects of bad database design, implementation, and management are magnified in an environment in which the number of transactions is less than one hundred.

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

The first line of an XML document represents the document declaration, and it is mandatory.

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

is a collection of technologies used to access any type of data source and manage the data through a common interface.

Based on Microsoft's Component Object Model (COM), is database middleware that adds object-oriented functionality for access to relational and nonrelational data.

A good API makes it easy to develop a program by providing all of the building blocks.

is an object-oriented programming language developed by Sun Microsystems that runs on top of web browser software.

The initial costs of using cloud services tend to be significantly higher than building on-premise IT infrastructures.

In the ADO.NET framework, the object is the in-memory representation of the data in the database.

Explain the features provided by web application servers.

What are the components in the basic ODBC architecture?