Deck 11: Interacting With Databases Through the Web

Question 1

The CGI is a newer Web-server interface standard that is much more efficient and faster than a dynamic link library (DLL).

Answer 1

False

Question 2

An API (application programming interface) is defined as a set of routines, protocols, and tools for building software applications.

Answer 2

True

Question 3

Java applications are compiled and stored in the Web browser.

Answer 3

False

Question 4

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

Question 5

The Web server is the main hub through which all Internet services are accessed.

Question 6

Many organizations rely on their IT departments to create universal data access architectures based on Internet standards.

Question 7

A database server-side extension is known as Web-to-database middleware.

Question 8

Usually, the native database connectivity interface provided by the vendor is not the only way to connect to a database; most current DBMS products support other database connectivity standards, the most common being ODBC.

Question 9

An API uses script files that perform specific functions on the client's parameters that are passed to the Web server.

Question 10

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 11

The creation and management of user interfaces and database connectivity are not affected by the Web's existence.

Question 12

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

Question 13

The effects of bad database design, implementation, and management are multiplied in an environment in which transactions may be measured in hundreds of thousands per day, rather than in hundreds per day.

Question 14

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

Question 15

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

Question 16

Most database professionals do not consider the DBMS connection to the Internet to be a critical element in IS development.

Question 17

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

Question 18

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

Question 19

The Web has helped create a new information dissemination standard.

Question 20

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

Question 21

The ____ object is a specialized object that creates a read-only session with the database to retrieve data sequentially (forward only) in a very fast manner.

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

Question 22

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

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

Question 23

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

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

Question 24

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

Question 25

The label "stateless system" indicates that, at any given time, a Web server knows the status of the clients communicating with it.

Question 26

To be able to use a DTD file to define elements within an XML document, the DTD must be stored within that XML document.

Question 27

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

Question 28

ColdFusion is a Web application server.

Question 29

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

Question 30

HTML is designed to facilitate the exchange of structured documents, such as orders and invoices, over the Internet.

Question 31

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 32

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

A) API
B) data source name
C) ODBC driver
D) driver manager

Question 33

____ is an OO programming language developed by Sun Microsystems that runs on top of the Web browser software.

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

Question 34

____ 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 35

A Web browser's function is to display a page on the client computer. The browser, through its use of HTML, does not have computational abilities beyond formatting output text and accepting form field inputs.

Question 36

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

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

Question 37

The ____ object is the in-memory representation of the data in the database.

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

Question 38

Cloud services allow any organization to quickly and economically add information technology services such as applications, storage, servers, processing power, databases, and infrastructure to its IT portfolio.

Question 39

ODBC works on the ____ operating system.

A) mainframe
B) UNIX
C) Windows
D) Linux

Question 40

Many companies are already working on the development of a new breed of services based on XML and Web technologies.

Question 41

Client-side extensions are available in various forms, such as ____.

A) COBOL
B) Java and JavaScript
C) Visual Basic .NET
D) Visor.Net

Question 42

What is a feature 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 an integrated development environment with session management and support for persistent application variables.

Question 43

A server-side extension ____.

A) provides its services to the Web server in a way that is totally transparent to the client browser
B) must be downloaded and installed in the client computer
C) is only available for servers running Windows 2000 or greater
D) is not required to access a database over the Internet

Question 44

A ____ is an external application that is automatically invoked by the browser when needed.

A) Web client
B) plug-in
C) Web service
D) Web server

Question 45

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

A) It is slower than CGI.
B) It is very inefficient because it uses DLLs.
C) You need to run an external program for each request.
D) An error can bring down the Web server.

Question 46

____ is a scripting language that allows Web authors to design interactive sites.

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

Question 47

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

A) HTML
B) browser
C) HTTP
D) API

Question 48

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

A) A plug-in
B) A browser
C) Visual Basic
D) VBScript

Question 49

There are currently ____ well-defined Web-server interfaces.

A) one
B) two
C) five
D) ten

Question 50

Of the following, what is one of the benefits of rapid development at manageable costs for Internet technologies?

A) Platform independence and portability
B) Availability of multiple development tools
C) Reduced requirements
D) Reduced training time

Question 51

Microsoft's alternative to Java is ____.

A) Active X
B) JavaScript
C) VBScript
D) Visual C++

Question 52

Of the following, what is one of the benefits of hardware and software independence of Internet technologies?

A) Global access
B) Reduced costs of maintaining private networks
C) Savings in equipment and software acquisition
D) Multiple platform development

Question 53

Another name for a database server-side extension is ____.

A) a Web server
B) a Web application server
C) Web-to-database middleware
D) a database application server

Question 54

Which of the following is a client-side extension?

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

Question 55

The Web browser's job is to ____ the HTML code that it receives from the Web server.

A) analyze
B) interpret
C) transform
D) save

Question 56

What is the first step in the exchange between a Web browser and a database?

A) The HTML output is displayed on the client computer's Web browser.
B) The middleware receives the query result and creates the HTML-formatted page.
C) The client's Web browser requests a page from a Web server.
D) The Web-to-database middleware uses ODBC to connect to the database.

Question 57

What is the last step in the exchange between a Web browser and a database?

A) The HTML output is displayed on the client computer's Web browser.
B) The middleware receives the query result and creates the HTML-formatted page.
C) The Web browser requests a page from a Web server.
D) The Web-to-database middleware uses ODBC to connect to the database.

Question 58

A programming language typically used for CGI scripts is ____.

A) PERL
B) Java
C) SQL
D) JavaScript

Question 59

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

A) Common Gateway Interface
B) Disk Operating System
C) Windows 98
D) AppleTalk

Question 60

When using an Oracle database, your Web-to-database middleware can connect to the database via ____.

A) ODBX
B) CGI
C) SQL*Net
D) SQL*Plus

Question 61

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 62

DBMS vendors can publish ____ to facilitate data exchanges and the creation of data views from multiple applications for multiple industries.

A) metadictionaries
B) database support
C) Web pages
D) XML databases

Question 63

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.

Question 64

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

Question 65

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

Question 66

In 2006, ____ began using the term cloud computing to describe a new set of innovative Web-based services.

A) Google and Amazon
B) Google and Sun
C) Microsoft and Sun
D) XML

Question 67

The ____ is an advanced data definition language that is used to describe the structure (elements, data types, relationship types, ranges, and default values) of XML data documents.

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

Question 68

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

Question 69

The ____ type of cloud infrastructure is built by a third-party organization to sell cloud services to the general public.

A) community
B) public
C) global
D) private

Question 70

The XML metalanguage allows the definition of new ____, such as , to describe the data elements used in an XML document.

A) elements
B) tags
C) schemas
D) DTDs

Question 71

____ is a Web application server that provides the ability to connect Web servers to multiple data sources.

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

Question 72

____________________ are objects that manage the connection with a data source and provide data to the consumers.

Question 73

In the ____ category, the cloud service provider offers the capability to build and deploy consumer-created applications using the provider's cloud infrastructure.

A) API as a Service (AaaS)
B) Infrastructure as a Service (IaaS)
C) Software as a Service (SaaS)
D) Platform as a Service (PaaS)

Question 74

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

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

Question 75

ODBC is ____________________'s implementation of a superset of the SQL Access Group CLI.

Question 76

____________________ are objects (applications or processes) that request and use data.

Question 77

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

Question 78

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

Question 79

Every XML document has a ____.

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

Question 80

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