FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Database Systems, Data Centres, and Business Intelligence

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

What type of data manipulation involves eliminating rows in a relational database?

A) selecting
B) joining
C) projecting
D) linking

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

In creating a database, a system analyst creates several entities and for each of the entity creates a list of attributes.For each attribute, the system analyst is given certain constraints as to the valid values that can be used.What is the term used to refer to these constraints?

A) restrictions
B) domains
C) exceptions
D) lists

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

Which of the following typically stores three to ten years of historical summary data records from many operational systems and external data sources so that it can be used for business analysis?

Due to their size, databases must be stored on mainframe computers or other large, powerful computers.

Developing a seamless integration of databases with the Internet is sometimes called a(n) ____________________.

Which of the following contains a subset of data for a single aspect of a company's business and is used by smaller groups who want to access detailed data for business analysis?

The reputation and financial stability of the database ____________________ is important in selecting the proper DBMS.

The purpose of ____________________ is to develop data that is accurate, complete, economical, flexible, reliable, relevant, simple, timely, verifiable, accessible, and secure.

A(n) ____________________ is a subset of a data warehouse.

What application of data mining identifies the products and services most commonly purchased at the same time?

One of the first steps in installing and using a large database involves "telling" the DBMS the logical and physical structure of the data and the relationships among the data for each user.

A database design where certain data entities are combined, summary totals are carried in the data records rather than calculated, and some data attributes are repeated in more than one data entity exhibits what is called planned ____________________.

Ali created a report for an instructor that lists all student marks for three tests, a midterm, and a final exam for the Winter term.The instructor asks Ali to modify the report to include only the three tests.What type of data manipulation would that involve?

Which of the following employs multidimensional databases to efficiently store and deliver data warehouse information?

Jane and her two friends plan to take three courses next semester including Accounting.Each of the courses at the university can accommodate a maximum of 40 students.In data modelling, what would be the relationship between course and student?

Data centres are approaching the point of automation, where they can run and manage themselves while being monitored remotely in a "lights out" environment.

____________________ lets programmers learn one powerful query language and use it on systems ranging from PCs to the largest mainframe computers.

A collection of related records is called a(n) ____________________.

During payroll processing, the system crashed and the operator concluded that the payroll system had integrity issues.Who will be called first to fix the problem?

Database management systems cost in excess of $1,000.