Deck 14: Database and the Internet

Question 1

The availability technique involving several servers and the technique known as load balancing, is called ____.

A) loading
B) database copying
C) boosting
D) clustering
E) duplicating

Answer 1

D

Question 2

HTML is derived from a broader markup language called the _____ Generalized Markup Language.

A) Standard
B) Universal
C) Specialized
D) Original
E) Longitudinal

Answer 2

A

Question 3

A separate computer placed between the Web server and the Internet is called ____.

A) a backend
B) a cluster
C) middleware
D) a firewall
E) a cache

Answer 3

D

Question 4

All of the following are issues about database that are particular to the Internet environment, except ____.

A) database connectivity
B) non-standard data types
C) database control issues such as scalability and availability
D) data normalization
E) data extraction into XML

Question 5

In the Web database environment, middleware is needed between ____.

A) the PCs and the browsers
B) the browsers and the Internet
C) the Internet and the Web server
D) the Web server and the database server
E) the database server and the database

Question 6

The set of standards known as Open Database Connectivity (ODBC) ____.

A) is front-end software to the Web server
B) is front-end software to the database server
C) connects the PCs and their browsers to the Internet
D) connects the database server to the database
E) connects the Internet to the Web server

Question 7

If we consider the World Wide Web to be a client/server system ____.

A) the consumer PCs and their browsers are the clients and the company Web servers are the servers
B) the company Web servers are the clients and the consumer PCs and their browsers are the servers
C) the World Wide Web serves as the clients and the Internet is the server
D) the Internet serves as the clients and the World Wide Web is the server
E) the consumer PCs and their browsers and the company Web servers are interchangeable as the clients and servers

Question 8

All of the following are considered database control issues that are of special importance in the Internet database environment, except ____.

A) performance
B) availability
C) scalability
D) integratability
E) security and privacy

Question 9

If the World Wide Web is considered to be a client/server system, the company Web servers are the clients.

Question 10

The World Wide Web can be considered to be a massive client/server system built on the Internet.

Question 11

The Standard Generalized Markup Language (SGML) is capable of handling the formatting of displayed text and data. It is also capable of indicating the _____ of the data.

A) date of creation
B) security classification
C) rating
D) proxy
E) meaning

Question 12

In the Web database environment, middleware is needed for all of the following reasons, except there can be ____.

A) different kinds of hardware between the Web server and the database server
B) different browsers on the client-side
C) a variety of different kinds of routers and gateways
D) a variety of different kinds of data, not just data in relational databases
E) different kinds of application software languages

Question 13

All of the following can be significant factors in the amount of Internet traffic to a Web site, except____.

A) the season of the year
B) the middleware in use
C) the rapidly growing popularity of a Web site
D) a major new product introduction
E) a major event on the Web site

Question 14

In Oracle, the letters "LOB" in the context of expanded data types stands for ____.

A) letters or blocks
B) literal or blocks
C) the slow transmission of data
D) literal object
E) large object

Question 15

All of the following are considered "expanded" data types for the Web, except ____.

A) graphic images
B) photographs
C) numeric data
D) video clips
E) audio clips

Question 16

In XML, each piece of data, is accompanied by tags that indicate its ____.

A) date of creation
B) security classification
C) rating
D) proxy
E) meaning

Question 17

When a query comes in from a PC on the Web, it is often the case that the retrieved data is going to be used again by the same or by a different end-user fairly soon. Such data can be held temporarily in a ____.

A) Flash disk
B) read-only memory
C) query cache
D) register
E) CGI

Question 18

The interface known as the Common Gateway Interface (CGI) connects ____.

A) the database server to the database
B) the PCs to the Internet
C) the Web server to the Internet
D) the PCs to their browsers
E) the Web server to the database server

Question 19

All of the following are reasons for a Web site being unavailable, except ____.

A) a system or telecommunications failure
B) the failure of a support system, such as an electrical outage
C) a planned down period for system maintenance
D) excessive traffic that clogs the system
E) the failure of an index during an update operation

Question 20

In the object/relational DBMS Informix Universal Server, multimedia and large text data are handled with ____.

A) Data Blades
B) Data Records
C) Data Tables
D) Data Stars
E) Binary Large Objects

Question 21

Firewalls can be placed between the Web server and the rest of the company's information systems.

Question 22

The object/relational DBMS Informix Universal Server handles multimedia and large text data using "Data Blades."

Question 23

In order for the application software running in the Web server to connect with software outside of the Web server, there must be agreed upon interfaces such as the Common Gateway Interface (CGI).

Question 24

Extensible Markup Language (XML) is derived from HyperText Markup Language (HTML).

Question 25

Spikes in Internet traffic are automatically smoothed out by the Internet and so are not a performance issue for individual Web sites.

Question 26

In the WWW environment, "middleware" is software that connects the PCs and their browsers to the Internet.

Question 27

Scalability refers to the capability of the information system that supports a Web site growing in size without adversely affecting the operations of the site.

Question 28

Application Program Interface (API) serves a similar purpose as but has more advanced functionality than Common Gateway Interface (CGI).

Question 29

Oracle has a category of data types known as the large object (LOB) category that can handle certain advanced data types.

Question 30

Among the advanced kinds of data found on the Web today are video clips, audio clips, and graphic images.

Question 31

The concept of database persistence, which can be accomplished with a query cache, is designed to improve availability in the Web environment.

Question 32

Open Database Connectivity (ODBC) is a level of standards created to aid Web server access to relational databases.

Question 33

Due to their fundamental design, relational DBMSs cannot be modified to handle advanced data types such as video clips, audio clips, and graphic images.

Question 34

The firewall technique of "proxy computers" is used only in Web server to client direction.

Question 35

The concept of clustering and the associated concept of load balancing are designed to improve security and privacy in the Web environment.

Question 36

Basic numeric and character data types are often insufficient for today's Web data.

Question 37

Oracle's Binary LOB (BLOB) data type is suitable for graphic images, photographs, video clips, and audio clips.

Question 38

Availability in the Web environment can be adversely affected by telecommunications failures or electrical outages.

Question 39

Common Gateway Interface (CGI) and Open Database Connectivity (ODBC) serve the same purpose and are interchangeable.

Question 40

Application Program Interface (API) serves a similar purpose as but has more advanced functionality than Java Database Connectivity (JDBC).

Question 41

Central Zoo.
a. Consider Central Zoo's Web site, which contains its database. Describe, in detail, the steps that would be taken with both hardware and software to reach the database when a zoo member or potential sponsor is considering animals to sponsor.
b. Describe three different uses for non-traditional data types in the Central Zoo Web site.

Question 42

Grand Travel Airlines.
a. Consider Grand Travel Airlines' Web site, which contains its database. Describe, in detail, the steps that would be taken with both hardware and software to reach the database when a customer or passenger wants to make a reservation for a flight.
b. Describe three different uses for non-traditional data types in the Grand Travel Airlines Web site.

Question 43

Standard Generalized Markup Language (SGML) is derived from Extensible Markup Language (XML).

Question 44

XML provides an independent layer of data definition that is helpful in the electronic data interchange (EDI) environment.

Question 45

XML is capable of indicating the meaning of data.