FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Database Systems and Big Data

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

Sometimes a database can contain "bad data," meaning incomplete, incorrect, inaccurate, or irrelevant records, which can be corrected or deleted through data cleansing.

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

A database administrator (DBA) must have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

_______ is an open-source software framework that includes several software modules that provide a means for storing and processing extremely large data sets.

The smallest piece of data used by a computer is a(n) _____.

A collection of fields all related to a single object, activity, or individual is a(n) _____.

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Two sets of fields can have a common primary key.

In a relational database model, the range of allowable values for a data attribute is called its _____.

A _____ provides a means to store and retrieve data that is modeled using some means other than the simple two-dimensional tabular relations used in relational databases.

The database approach to managing data is superior to the file-based approach.

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

The position of a _____ is a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.

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.

A database, a database management system, and the application programs that use the data, make up a database environment.

A field is typically a name, number, or combination of characters that describes an aspect of a business object.

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

If you wish to develop expertise in database management, you must learn popular language known as ______.

Briefly describe the hierarchy of data.

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

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