FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Databases

Show Answer

Share

---

All types

Filters

Study Flashcards

Question 31

Short Answer

Review LaterAdd Note

Review Later

The process of dividing a database into distributed subsets is called ________.​

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

The goal of normalization is to minimize data redundancy.

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

Modifications to the contents of a database field are made by using the SQL _________ command.​

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

A hierarchical database allows one-to-many relationships but not one-to-one relationships.

From a database user perspective, a data type determines the way data can be manipulated.

A database ____________ contains a list of keys, and each key provides a pointer to the record that contains the rest of the fields related to that key.​

The relationship between record types can be depicted graphically with a(n) _________.

In SQL terminology, creating a relationship between tables is referred to as _______ tables.​

A primary key is a(n) ____________ that contains data unique to a record.

Unlike a sort order, an index has no bearing on the physical sequence of records on a storage device.​

It is not possible to extract analytical data from operational databases.

In a(n) __________ database, processing logic for the query is performed on the device that holds each database shard and if necessary, results are consolidated by the DBMS.

Decision makers can access analytical databases using an executive __________.

In the context of database security, user ______ management allows access to data on an as-needed basis.

Which database data type is used for fields that contain whole numbers, such as quantities, repetitions, and rankings?

Ten terabytes offer enough storage capacity to hold the printed collection of the Library of Congress.​

Enterprise database applications tend to have some flexibility for customization.

A ____________ 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.

SQL statements contain command words but do not contain data.​