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

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

Correct Answer

verified

schema​

Question 2

True/False

Review LaterAdd Note

Review Later

SQL is banned from the NoSQL technology collection.​

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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

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

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

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

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

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

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

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

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

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

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

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

The entire Internet contains about a zettabyte of data.​

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

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

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

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