A(n) _____ occurs when data are stored redundantly in a database and only some of the instances are updated when a change is needed.
A -
Error
B -
Update anomaly
C -
Data integrity concern
D -
Storage efficiency
2-
A data model that does not contain repeating fields and that the data models leads to tables containing fields that are dependent on a whole primary key is in _____ normal form.
A -
Balanced
B -
First
C -
Second
D -
Primary
3-
If the data model does not have any repeating fields it is in _____.
A -
Base normal form (BNF)
B -
First normal form (1NF)
C -
Non-normal form (0NF)
D -
Second normal form
4-
If the logical data model contains fields that depend on another non-primary key field, then it is in violation of the rules of _____.
A -
Non-normal form (0NF)
B -
First normal form (1NF)
C -
Second normal form (2NF)
D -
Third normal form (3NF)
5-
In order to reduce the number of joins that must be performed in a query and to increase the speed of data access, the data analyst will _____ the physical model.
A -
Cluster
B -
Denormalize
C -
Index
D -
Normalize
6-
To improve the access speed of a database, similar records in a table are stored together in primary key order. This optimizing access speed process is called _____.
A -
Denormalization
B -
Indexing
C -
Interfile clustering
D -
Intrafile clustering
7-
_____ is the process of estimating the amount of data that the hardware will need to support, so that the server hardware specifications are sufficient for the project's needs.
A -
Indexing
B -
Interfile clustering
C -
Intrafile clustering
D -
Volumetrics
8-
The size of a database is determined by the _____.
A -
Amount of raw data in the tables
B -
Amount of raw data in the tables and overhead requirements for the DBMS
C -
Number of instances in the tables
D -
Overhead requirements for the DBMS
9-
A mini-table that contains values from one or more columns in a table and the location of the values within the table is called a(n) _____.
A -
Index
B -
Unterfile cluster
C -
Intrafile cluster
D -
Raw data calculation
10-
A simple rule to follow when creating problem domain classes and data acess and manipulation classes is that there should be ______________.
A -
One data access and manipulation class for each concrete problem domain class
B -
Two data access and manipulation classes for each concrete problem domain class
C -
N data access and manipulation classes for each concrete problem domain class, where N is the number of methods in the problem domain class
D -
N data access and manipulation classes for each concrete problem domain class, where N is the number of subclasses of the problem domain class
