Database Software Basics Answers

4 verified answers
1
Free Preview

What best describes a relational database?

A
a database containing tables that do not interconnect
B
a database containing tables that are connected by common fields
C
a database that has only one table
D
a database that does not have tables
2
Free Preview

What are examples of data duplication in flat files? Check all that apply.

A
a Managers table linked to a Stores table
B
a table with three records for student ID # 459100388
C
a multiple-choice question with two identical answers
D
a Customers table linked to a Products table
3

Which statements describe disadvantages of using flat files? Check all that apply.

A
It is easy to make errors when updating data.
B
Updating data can be time-consuming.
C
Flat files do not allow duplicate information.
D
There is a tendency for duplicate information.
4

What are advantages of using a relational database instead of a flat file? Check all that apply.

A
data stored in a tabular format
B
reports generated from specific fields
C
data easier to sort, filter, and summarize
D
data stored in columns and rows
E
easier to draw comparisons from data
F
easier to set up
G
reduced likelihood of storing duplicate data

Did you find these answers helpful?