FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Data Management

Show Answer

Share

---

All types

Filters

Study Flashcards

Question 1

Short Answer

Review LaterAdd Note

Review Later

In a(n) __________ database, data for a query is fetched from one or more shards of a distributed database, and then it is processed by the DBMS to produce the query result.​

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

__________ refers to a branch of data mining that analyzes current and historical data to predict future trends.​

A) ​Predictive analytics
B) ​OLAP
C) ​Data warehouse
D) ​TPS

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

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

SQL keywords must be entered in all uppercase letters because they are case-sensitive.​

Which database tool is best for simple flat files that involve calculations?​

A record that contains data is referred to as a record ________.​

A(n) _______________  is a field that contains data unique to a record.​

The entire Internet contains about a zettabyte of data.​

Rather than deleting old data, it can be moved to a data __________.​

SQL is banned from the NoSQL technology collection.​

A computed ___________ is a calculation that a DBMS performs, similar to the way a spreadsheet computes a formula.​​

Computer programming languages designed for databases are called _________ languages because one of their main capabilities is to request data from a database​

The simplest structure for storing data in a(n) _________  database is the key-value data model.​

Relational databases are organized according to a(n) _________, which is simply the blueprint for its structure.​

A(n) ____________ is a template that adds the correct formatting as data is entered. If someone attempts to enter data in the wrong format, the database can be set up to reject that entry or correct it.​

Dedicated enterprise database applications may allow cosmetic changes, but they do not encourage modifications of core data structures.​

​An efficiently designed database uses computed fields whenever possible because they do not require manual data entry.

A lookup routine validates an entry by checking data in an in-house or third-party database.​

Which database data type is a collection of binary data stored in a single field of a database?​

One of the most common database operations is to query for a particular record or group of records by using the ________ command.​

​In a database, a(n) __________ contains the smallest unit of meaningful information