FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Database Systems,data Centers,and Business Intelligence

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Query by Example (QBE)
B) user views
C) structured query language (SQL)
D) data manipulation language (DML)

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

Several records can share the same primary key.

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

The role of a data administrator is to plan,design,create,operate,secure,monitor,and maintain databases.

A(n)_____ is designed to store and retrieve data in a manner that does not rigidly enforce the atomic conditions associated with the relational database model in order to provide faster performance and greater scalability.

One of the most effective counterintelligence measures is to define _____ information relevant to a company and control its dissemination.

______ use basic graphical symbols to show an organization of and relationships between data.

A(n) _____ is s field or set of fields in a record that uniquely defines the record.

With _____,the database is stored on a service provider's server and accessed by the client over a network,typically the Internet.

One of the best ways to gain insights into data is through _____ techniques that can help quickly draw conclusions and see relationships among the data.

A database should be designed to store all data relevant to a business and provide quick access and easy modification.

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

One data cleansing solution is to identify and correct the data by cross-checking it against a validated data set.

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

Briefly describe the relational database model.

Differentiate between the traditional and database approach to data management.

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

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

_____ is an approach to data management whereby each distinct operational system uses data files dedicated to that system.

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

When organizing a database,one of the key considerations include determining who will have access to the collected data.