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

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Entity-rel...

View Answer

Show Answer

Question 32

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

SQL
Structured query...

View Answer

Show Answer

Question 33

True/False

Review LaterAdd Note

Two sets of fields can have a common primary key.

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.

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

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

Briefly describe the hierarchy of data.

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

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

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

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

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

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

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

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

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

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

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.