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 1

Essay

Review LaterAdd Note

Review Later

Define the role of a database administrator and of a data administrator, and explain the difference between the two.

Correct Answer

verified

Based on their understanding of business...

View Answer

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database. In terms of the characteristics of big data, Haley is dealing with ________.

A) ​volume
B) ​variety
C) ​velocity
D) ​veracity

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.

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

Explain entity-relationship (ER) diagrams.

The relational database model is currently the most widely used.

In a relational database model, _____ involves combining two or more tables.

_____ is a method of dealing with a situation in which two or more users or applications need to access the same record at the same time.

Unstructured data comes from sources such as word-processing documents and scientific research.

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

You would use Query by Example, if _____.

Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, MySQL, and Sybas are databases based on the _____ model.

Define the terms data management and data governance, and explain how organizations are using them to address the challenges of big data.

Carlos is working with an existing database, but he wants to eliminate some of the columns in the table to create a new, more streamlined database. He will use projection to create his new database.

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

Briefly describe the relational database model.

The action of including only some columns for output while retrieving data is known as ____.

To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOT one of those four properties?

In the _____ process, all of the data from various sources is converted into a single format suitable for processing.