Deck 15: Database Connectivity and Web Technologies

Question 1

The only time the client and server computers communicate is when the client requests a page and the server sends the requested page to the client.

Answer 1

True

Question 2

The label "stateless system" indicates that, at any given time, there is an open communication line between the server and each client accessing it.

Answer 2

False

Question 3

Having a web-based database interface eliminates the design and implementation issues of a database system.

Answer 3

False

Question 4

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.

Question 5

A client-side extension is a program that interacts directly with the web server to handle specific types of requests.

Question 6

The browser's interpretation and presentation capabilities are sufficient to develop web-based applications.

Question 7

The benefits of the web as a data access platform arise from its cross-platform functionality and the simplicity of its interface.

Question 8

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

Question 9

HTML is designed to facilitate the extraction and manipulation of data from structured documents over the Internet.

Question 10

A plug-in is an external application that is automatically invoked by a web browser when needed.

Question 11

In the database query scenario, the web server generates the webpage contents before it sends the page to the client web browser.

Question 12

Extending the web server functionality implies that the web server and the web-to-database middleware will properly communicate with each other.

Question 13

An application programming interface (API) uses script files that perform specific functions based on the client's parameters that are passed to the web server.

Question 14

Database connectivity software is also known as database middleware because it interfaces between the application program and the database.

Question 15

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

Question 16

The Common Gateway Interface (CGI) is a newer web server interface standard that is much more efficient and faster than a dynamic link library (DLL).

Question 17

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

Question 18

The use of HTML does not equip a web browser with computational abilities beyond formatting output text and accepting form field inputs.

Question 19

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.

Question 20

Whether you purchase online or by standing in line, the system-level transaction details are essentially the same, and they require the same basic database structures and relationships.

Question 21

The main disadvantage of using CGI scripts is that:

A) they cause a resource bottleneck since they have to execute separately for each user request.
B) they are specific to the web server and to the operating system, thus being platform dependent.
C) an error in one script can damage and bring down the web server completely.
D) they do not have the capability to process forms or prepare outputs based on form data.

Question 22

Each time an end user clicks a hyperlink, the browser generates a(n) _____ page request that is sent to the designated web server using the TCP/IP Internet protocol.

A) HTML
B) XML
C) HTTP GET
D) API

Question 23

_____ is a higher-level, object-oriented application interface used to access remote database servers.

A) UDA
B) ODBC
C) DAO
D) RDO

Question 24

The ODBC API standard defines three levels of compliance: _____, Level-1, and Level-2, which provide increasing levels of functionality.

A) Elementary
B) Basic
C) Core
D) Level-0

Question 25

One of the advantages of _____ over other middleware is that it requires no configuration on the client side.

A) ODBC
B) JDBC
C) OLE-DB
D) ADO.NET

Question 26

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

A) DAO
B) UDA
C) ODBC
D) OLE-DB

Question 27

You must use plug-ins and other client-side extensions to:

A) create an open communication line between a server and its clients.
B) eliminate the need for running external programs for each client request.
C) improve processing capabilities of a browser.
D) create dynamic web search pages.

Question 28

In the ADO.NET framework, the _____ is a disconnected, memory-resident representation of the database.

A) Command
B) DataReader
C) DataAdapter
D) DataSet

Question 29

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

A) Visual Basic
B) Java
C) JavaScript
D) VBScript

Question 30

What is a disadvantage of using an API web-server interface?

A) It is slower than CGI scripts.
B) It is inefficient because it uses DLLs.
C) An external program needs to run for each user request.
D) An API error can bring down the entire web server.

Question 31

Which of the following is a well-defined web-server interface?

A) Common Gateway Interface
B) Tiny Internet Interface
C) Windows NT
D) Command Line Interface

Question 32

In the ADO.NET framework, the _____ object contains the actual SQL code or a stored procedure call to be run by the database.

A) Command
B) DataReader
C) DataAdapter
D) DataSet

Question 33

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

A) ODBC API
B) DLL
C) ODBC driver
D) driver manager

Question 34

Which is a client-side extension?

A) ActiveX
B) ODBC
C) SQL*Net
D) TCP/IP

Question 35

Another name for a database server-side extension program is _____.

A) web server
B) web application middleware
C) web-to-database middleware
D) database application server

Question 36

The _____ is the most specialized object in the ADO.NET framework.

A) Command
B) DataReader
C) DataAdapter
D) DataSet

Question 37

The web browser's job is to interpret the HTML code that it receives from a web server and to:

A) develop web-based applications.
B) display it in a standard formatted way.
C) perform immediate data entry validation.
D) extract details, such as order data, from it.

Question 38

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

A) DLL
B) API
C) web browser
D) HTTP GET request

Question 39

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

A) MS-DB
B) OLE-DB
C) COM-DB
D) ODBC

Question 40

ODBC works on the _____ operating system.

A) Kronos
B) UNIX
C) Windows
D) Mac

Question 41

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

Question 42

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

Question 43

Using _____, you can extract data from an XML document and convert it into a text file.

A) XMLD
B) XSLT
C) DTD
D) XML schema

Question 44

_____ is a web application server that provides the ability to connect web servers to multiple data sources.

A) MS Access
B) ColdFusion/JRun
C) FoxPro
D) dBase

Question 45

_____ is a scripting language that allows web authors to design interactive sites.

A) Visual Basic
B) HTML
C) JavaScript
D) Java

Question 46

Which of the following is true of a web application server?

A) It is Microsoft's implementation of a superset of the SQL Access Group CLI standard for database access.
B) It is automatically invoked by the browser when needed.
C) It runs on the client machine, freeing server resources.
D) It provides security and authentication of users through user IDs and passwords.

Question 47

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

A) XML
B) SQL
C) Visual Basic
D) VBScript

Question 48

Which of the following is a characteristic of the XML metalanguage?

A) It is concerned with the way data are displayed.
B) It allows the definition of new tags.
C) You can use the // symbol for entering a comment in the XML document.
D) It can be used as a replacement of HTML.

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

The _____ is an advanced data definition language that is used to describe the structure of XML data documents.

A) XHTML
B) HTML schema
C) DTD
D) XML schema

Question 54

Every XML document has a _____.

A) root element
B) base tag
C) schema
D) DTD

Question 55

_____ webpages are at the heart of current generation websites.

Question 56

A(n) _____ file provides the composition of the database's logical model and defines the syntax rules for an XML document.

A) XMLD
B) XHTML
C) DTD
D) meta

Question 57

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

Question 58

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

Question 59

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

Question 60

Among client-side extensions, _____ is a Microsoft specification for writing programs that run inside the Internet Explorer browser.

A) COBOL
B) ActiveX
C) JavaScript
D) Visor.Net

Question 61

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

Question 62

What are the main types of objects in the OLE-DB model? Explain.

Question 63

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

Question 64

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.

Question 65

What are the components in the basic ODBC architecture?

Question 66

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

Question 67

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

Question 68

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

Question 69

What is JavaScript? How is JavaScript code activated?

Question 70

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

Question 71

XML is used to create _____, or vocabularies for entire industries.

Question 72

_____ refer to a cloud computing-base data management service that provides relational data storage, access, and management to companies of all sizes without the typical high costs of in house hardware, software, infrastructure, and personnel.

Question 73

What is a server-side extension? Explain.