Filters
Question type

Study Flashcards

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

Correct Answer

verifed

verified

OLAP is a tool for enabling


A) users to obtain online answers to ad-hoc questions in a rapid amount of time.
B) users to view both logical and physical views of data.
C) programmers to quickly diagram data relationships.
D) programmers to normalize data.

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

The most prominent data manipulation language today is


A) Access.
B) DB2.
C) SQL.
D) Crystal Reports.

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

Microsoft SQL Server is a(n)


A) DBMS for small handheld computing devices.
B) Internet DBMS.
C) desktop relational DBMS.
D) DBMS for midrange computers.

E) B) and C)
F) All of the above

Correct Answer

verifed

verified

In terms of data relationships, associations refers to


A) events linked over time.
B) patterns that describe a group to which an item belongs.
C) occurrences linked to a single event.
D) undiscovered groupings.

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

One of the drawbacks to OODBMS are that they cannot work with applets.

A) True
B) False

Correct Answer

verifed

verified

A data warehouse may be updated by a legacy system.

A) True
B) False

Correct Answer

verifed

verified

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends with


A) two short marks.
B) one short mark.
C) a crow's foot.
D) a crow's foot topped by a short mark.

E) B) and D)
F) C) and D)

Correct Answer

verifed

verified

Which of the following is not one of the techniques used in Web mining?


A) content mining
B) structure mining
C) usage mining
D) user mining

E) None of the above
F) A) and C)

Correct Answer

verifed

verified

You are creating a video and animation sharing Web site whose content will be supplied by content, video, and applets stored in a database and you anticipate very high loads on the server. Which of the following DBMSs will most likely serve your needs?


A) object-relational DBMS
B) relational DBMS
C) hierarchical DBMS
D) OODBMS

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

Common Gateway Interface is a specification for processing data on a Web server.

A) True
B) False

Correct Answer

verifed

verified

True

You work for a retail clothing chain whose primary outlets are in shopping malls and are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of


A) identifying associations.
B) identifying clusters.
C) identifying sequences.
D) classification.

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

Predictive analysis is synonymous with data mining.

A) True
B) False

Correct Answer

verifed

verified

False

Databases record information about general categories of information referred to as ________.

Correct Answer

verifed

verified

Each characteristic or quality describing a particular entity is called an attribute.

A) True
B) False

Correct Answer

verifed

verified

A data warehouse is typically comprised of several smaller data marts.

A) True
B) False

Correct Answer

verifed

verified

Which of the following is not one of the main problems with a traditional file environment?


A) data inconsistency
B) program-data independence
C) lack of flexibility in creating ad-hoc reports
D) poor security

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Correct Answer

verifed

verified

Data mining uncovers hidden relationship...

View Answer

The project operation


A) combines relational tables to provide the user with more information than is otherwise available.
B) creates a subset consisting of columns in a table.
C) organizes elements into segments.
D) identifies the table from which the columns will be selected.

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

B

A DBMS separates the logical and physical views of data.

A) True
B) False

Correct Answer

verifed

verified

Showing 1 - 20 of 90

Related Exams

Show Answer