FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Database Systems and Applications

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

_____ is a form of data mining that combines historical data with assumptions about future conditions to forecast the outcomes of events.

A) Business intelligence
B) Social graph analysis
C) Online analytical processing
D) Predictive analysis

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

A) Data selecting
B) Enterprise data modeling
C) Data cleansing
D) Social graph analysis
​

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

Online analytical processing and data mining are essentially the same thing.

Describe business intelligence (BI).

Competitive intelligence is espionage.

In the context of a database management system (DBMS), a(n) _____ interacts with other programs or applications and only indirectly interacts with people or users.

In the context of relational database model, selecting involves combining two or more tables.

Two sets of fields can have a common primary key.

A(n) _____ is a detailed description of all data used in a database.

A(n) _____ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

In the relational database model, each row of a table represents a(n) _____.

_____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of dealing with them.

Some databases use ______, which is a visual approach to developing queries and requests.

Predictive analysis is a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events.

Basic data manipulations include _____ that involves eliminating rows in a relational database according to certain criteria.

Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, MySQL, and Sybas are databases based on the _____ model.

Together, bits, characters, fields, records, files, and databases form the ______.

_____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.

The _____ is a specific language, provided with a database management system (DBMS) that allows users to access and modify the data, to make queries, and to generate reports.

Briefly describe the relational database model.