Question 1

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

Accepted Answer

With in-memory computing, RAM (primary memory) is used for processing instead of accessing data from disk or other storage devices. This helps in faster data processing and retrieval.

Question 2

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 3

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 4

Legacy systems are used to populate and update data warehouses.

Accepted Answer

Legacy systems are often used as a source of data for data warehouses as they contain historical data that is essential for trend analysis and business intelligence. The data from legacy systems is extracted, transformed and loaded into the data warehouse.

Question 5

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 6

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 7

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 software that connects different software applications or components to facilitate communication and data exchange. In this case, the middleware connects an organization's internal database to a Web server and enables delivery of information as part of a Web page to the user.

Question 8

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

Accepted Answer

Text mining tools are designed to extract meaningful insights from unstructured data, such as text-based documents. They use advanced algorithms and techniques to identify patterns, themes, and trends within the data, and can be applied to a wide range of applications, including sentiment analysis, topic modeling, and entity recognition. By leveraging these tools, organizations can unlock valuable insights from their unstructured data that might otherwise be missed.

Question 9

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

Accepted Answer

CGI (Common Gateway Interface) scripts can be used to manipulate and process data on a Web server. They can take input from users and perform actions such as writing to a file, sending an email, or querying a database.

Question 10

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

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

Accepted Answer

High-speed analytic platforms use a combination of different tools and technologies, including both relational and non-relational databases, to process and analyze large datasets quickly and accurately. This enables organizations to derive valuable insights and make informed decisions based on real-time data.

Question 13

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 14

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

Accepted Answer

OLAP is specifically designed for analyzing large sets of data and is able to handle queries with large amounts of data efficiently.

Question 15

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 16

To perform multidimensional data analysis, you would use OLAP.

Accepted Answer

OLAP (Online Analytical Processing) is a technology used for multidimensional data analysis. It allows users to analyze complex data sets from multiple perspectives and dimensions, making it a powerful tool for business intelligence and decision-making.

Question 17

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 18

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 19

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 may be located on a dedicated computer called a database server, not necessarily on a Web server.

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