Question 1

Implementing a Web interface for an organization's internal database usually requires substantial changes to be made to the database.

Accepted Answer

The answer of Implementing a Web interface for an organization's...

Question 2

You can manipulate data on a Web server by using a CGI script.

Accepted Answer

CGI (Common Gateway Interface) scripts can be used to process data and perform actions on a Web server, such as retrieving data from a database and displaying it on a webpage or accepting user input and submitting it to another application for processing.

Question 3

In data mining, the technique of predicting uses a series of existing values to determine what other future values will be.

Accepted Answer

The answer of In data mining, the technique of predicting...

Question 4

To perform multidimensional data analysis, you would use OLAP.

Accepted Answer

OLAP (Online Analytical Processing) is a technology used for multidimensional data analysis, which allows users to analyze data from multiple perspectives and dimensions. OLAP provides fast and flexible data access and allows for complex calculations and data aggregations. So, to perform multidimensional data analysis, OLAP is the preferred technology.

Question 5

In place of application server software to allow a Web server to communicate with a back-end database, you can use
A) CGI.
B) HTML.
C) Java.
D) SQL.
E) NoSQL.

Accepted Answer

The answer of In place of application server software to...

Question 6

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

Accepted Answer

The answer of A database server is software that handles...

Question 7

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

Accepted Answer

The answer of Describe the ways in which database technologies...

Question 8

To analyze unstructured data, such as memos and legal cases, you would use text mining tools.

Accepted Answer

Text mining tools can analyze unstructured data, such as memos and legal cases, by identifying patterns, trends, and relationships within the text. These tools use techniques such as natural language processing, machine learning, and data visualization to make sense of the unstructured data.

Question 9

Legacy systems are used to populate and update data warehouses.

Accepted Answer

Legacy systems are used to provide data to data warehouses, as they are often the source of historical data that needs to be stored and analyzed.

Question 10

What makes data mining an important business tool?
 What types of information does data mining produce?
 In what type of circumstance would you advise a company to use data mining?

Accepted Answer

The answer of What makes data mining an important business...

Question 11

You have been hired by a national furniture leasing company to implement its first business intelligence systems and infrastructure. To prepare for your initial report, describe the types of data in their firm they can use to support business intelligence and the systems that you will implement to support both their power users and casual users, and explain how these systems or tools work together.

Accepted Answer

The answer of You have been hired by a national...

Question 12

An application that transfers information from an organization's internal database to a Web server for delivery as part of a Web page to the user is called middleware.

Accepted Answer

Middleware is a software layer that connects an organization's internal database with a web server, allowing data to be transferred and delivered to users as part of a web page.

Question 13

HTML has become the preferred method of communicating with back-end databases because it is a cross-platform language.

Accepted Answer

HTML is not a programming language, but a markup language used for creating web pages. It is not used for communicating with back-end databases. Instead, languages like PHP, Python, Ruby, and JavaScript are commonly used for this purpose.

Question 14

With in-memory computing, a computer's primary memory (RAM) is used for processing.

Accepted Answer

In-memory computing uses a computer's primary memory (RAM) for processing data instead of relying on slower secondary storage devices such as hard disks.

Question 15

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Accepted Answer

High-speed analytic platforms often use a combination of both relational and non-relational databases or tools to analyze large datasets efficiently. Relational databases can provide structured, highly organized data for analysis, while non-relational tools can handle unstructured or semi-structured data such as social media data or sensor data.

Question 16

In a client/server environment, a DBMS is located on a dedicated computer called a Web server.

Accepted Answer

In a client/server environment, a DBMS can be located on a separate dedicated server or on the same server as the Web server. The term "Web server" typically refers to a server that hosts and delivers Web pages and applications, but does not necessarily host the DBMS.

Question 17

OLAP is unable to manage and handle queries with very large sets of data.

Accepted Answer

The answer of OLAP is unable to manage and handle...

Question 18

In associations, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

Accepted Answer

The answer of In associations, a data mining tool discovers...

Question 19

Multiple data marts are combined and streamlined to create a data warehouse.

Accepted Answer

The answer of Multiple data marts are combined and streamlined...

Question 20

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

Accepted Answer