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

Accepted Answer

The availability technique involving multiple servers and load balancing is called clustering.

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

Accepted Answer

HTML is derived from a broader markup language called the "Standard" Generalized Markup Language (SGML).

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

Accepted Answer

A firewall is a security device that monitors and filters incoming and outgoing network traffic based on a set of rules. It acts as a barrier between the Web server and the Internet, helping to protect against unauthorized access and attacks. The other choices are not specifically related to this function.

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

Accepted Answer

Data normalization is not a specific issue related to the Internet environment, it is a fundamental concept of database design. The other options (A, B, C, E) all relate specifically to challenges that arise when using databases on the Internet.

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

Accepted Answer

Middleware is required between the Web server and the database server in the Web database environment. It acts as a bridge to facilitate communication between these two layers.

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

Accepted Answer

Open Database Connectivity (ODBC) is a set of standards and APIs for connecting applications to a database management system (DBMS). It serves as front-end software to the DBMS and allows programs to send and receive data from it. Therefore, choice B is the correct answer. The other choices are not accurate descriptions of ODBC's purpose.

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

Accepted Answer

The World Wide Web is a client/server model where the consumer PCs and their browsers act as clients and the company Web servers act as servers. The Web browser on a user's device sends a request to the Web server for a particular Web page, and the Web server responds with the requested page. This is a classic example of the client/server model.

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

Accepted Answer

Performance, availability, scalability, security and privacy are all important database control issues that need special attention in an internet database environment. However, Integratability is not considered one of the key database control issues in this context.

Question 9

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

Accepted Answer

The statement is incorrect. In a client/server system, the clients are typically the end-users or devices requesting resources from the server. In the case of the World Wide Web, the end-users or devices accessing websites are the clients, while the company web servers are the servers that provide the resources.

Question 10

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

Accepted Answer

The World Wide Web, commonly known as the web, is a client/server system that uses the Internet as its communication protocol. The web relies on client software, such as web browsers, to access various services and resources that are hosted on web servers located around the world.

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

Accepted Answer

SGML uses markup tags to indicate the meaning or semantic structure of the data rather than just its appearance or formatting. This allows for easier machine processing and interoperability between different systems.

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

Accepted Answer

The answer of In the Web database environment, middleware is...

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

Accepted Answer

Middleware is software that provides services to other software applications. While it may affect the performance of a website, it is not a significant factor in the amount of internet traffic to a website. Therefore, option B is the correct answer.

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

Accepted Answer

"LOB" stands for "large object" in Oracle when referring to expanded data types.

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

Accepted Answer

Numeric data is not considered an expanded data type for the Web. Graphic images, photographs, video and audio clips are all examples of expanded data types, as they require more advanced technology and bandwidth to display or transmit online. Numeric data, on the other hand, can typically be displayed and transmitted using basic HTML or spreadsheet formats.

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

Accepted Answer

In XML, tags are used to indicate the meaning of each piece of data, helping to define the structure, hierarchy and relationships between elements. The tags are used to identify the type of data being presented and provide context to the content. While metadata such as date of creation, security classification, and rating could be included, these are not typically included as part of the XML markup itself, but rather as separate attributes or elements within the XML document.

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

Accepted Answer

Data that is frequently accessed through queries can be temporarily stored in a query cache to improve the system's performance by reducing the time it takes to retrieve data. Storing data in a cache allows it to be quickly accessed without having to repeatedly fetch it from the original source.

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

Accepted Answer

The Common Gateway Interface (CGI) is a protocol that connects the web server to the database server. It allows for dynamic generation of web pages and the processing of user input. None of the other options describe what CGI does.

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

Accepted Answer

All of the options except for E relate to technical issues or planned maintenance. The failure of an index during an update operation is the only option that specifically relates to a content management system or database issue.

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

Accepted Answer

Informix Universal Server uses Data Blades to handle multimedia and large text data. Data Blades are modules that provide additional functionality for handling specific types of data.

Quiz 14: Database and the Internet

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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