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 21

Short Answer

Review LaterAdd Note

Review Later

The commands that are used to manipulate the database are part of the ____________________ language.

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

Who is responsible for planning, designing, creating, operating, securing, monitoring, and maintaining databases?

A) data owners
B) data analysts
C) database power users
D) database administrators

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

In the relational data model, each column of a table represents a(n) ____________________.

The business user asks the data analyst for a database to capture information about all the customers including personal information.In preparation, the data analysis identifies the list of attributes to be used for the database.What is the name of this list?

A data centre that is fully automated to the extent that it can run and manage itself while being monitored remotely is said to operate in a(n) ____________________ environment.

In many organizations, information is stored in more than one location, which makes it difficult to maintain because there is much duplication.What is the term used to refer to this problem in data?

A(n) ____________________ is a simple database program whose records have no relationship to one another and are often used to store a single table or file.

What is the smallest piece of data used by a computer?

Differentiate between the traditional and database approaches to data management.

Business and technology vendors are working to develop blue data centres that run more efficiently and require less energy for processing and cooling.

What is a database?

Who is responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization?

Online analytical processing and data mining are essentially the same.

What is the name given to a system used to analyze financial and operating data?

A consultant has been hired to help a company identify a specific requirement for a project.The consultant sets out to identify the informational elements including its usage and access.What method is this being used?

The ____________________ data model has become the most popular database model.

What is the primary consideration when selecting a database management system for an organization?

The data ____________________ is a detailed description of all data used in the database.

Identify 10 advantages of the database approach to data management.

____________________ involves combining two or more tables in a relational database.