Question 1

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
E) optimize

Accepted Answer

Denormalization involves combining two or more tables into one to reduce the number of joins required in a query, thereby increasing the speed of data access. Clustering and indexing can also improve performance but do not necessarily reduce the need for joins. Normalizing the data model can actually increase the number of joins. Optimization is a broader term that encompasses various techniques for improving query performance, including denormalization.

Question 2

The type of database that is most capable of supporting complex data types is _____.
A) sequential files
B) relational DBMS
C) object-oriented DBMS
D) object-relational DBMS
E) random access files

Accepted Answer

C

Question 3

A relational database may be optimized for _____.
A) data type and storage efficiency
B) relational type
C) speed of access
D) storage efficiency
E) storage efficiency and speed of access

Accepted Answer

A relational database can be optimized for both storage efficiency and speed of access. The efficient storage ensures that the data is compactly maintained in a structured manner, while fast access contributes to the performance of the database by reducing the time for retrieving specific data from the large database. Therefore, optimizing a relational database for storage efficiency and fast access is the best option.

Question 4

The process of ensuring that values linking tables together through the primary and foreign keys are valid and correctly synchronized is _____.
A) hierarchical integrity
B) primary integrity
C) table integrity
D) referential unity
E) referential integrity

Accepted Answer

Referential integrity involves ensuring that values in a foreign key column match values in the primary key column of another table, and that updates and deletions occur in a synchronized manner. This helps to prevent data inconsistencies and maintain data accuracy.

Question 5

Which of the following is NOT a characteristic of current object-relational databases?
A) storage of objects in the relational table structure
B) good support for typical data management operations
C) SQL support
D) support for inheritance
E) all of the above are characteristics of object-relational databases

Accepted Answer

The answer of Which of the following is NOT a...

Question 6

If the data model does not have any repeating fields it is in _____.
A) base normal form
B) first normal form
C) non-normal form
D) second normal form
E) third normal form

Accepted Answer

First normal form (1NF) is the level of normalization that ensures that each column of a table contains only atomic (indivisible) values, and each row contains only one instance of data for each set of related values. This means that the table does not have any repeating groups, or arrays of values that are stored in a single column.

Question 7

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) interfile cluster
C) intrafile cluster
D) raw data calculation
E) volumetric

Accepted Answer

An index is a mini-table that contains selected columns of a larger table along with the location of the values within the larger table. It is used to improve the speed and efficiency of database searches by allowing the database management system to quickly locate the desired data without having to scan the entire table. The other options are not related to this concept.

Question 8

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
E) none of the above

Accepted Answer

This describes a specific type of database anomaly known as an update anomaly, in which redundant data leads to inconsistencies when only some instances are updated but others are not. A is too general, C is a broad term that encompasses a range of issues, D is irrelevant, and E is not the correct answer.

Question 9

In an object-oriented database, an extent is the equivalent to a(n) _____ in a relational database.
A) attribute
B) row
C) table
D) relationship
E) unique identifier

Accepted Answer

An extent in an object-oriented database is a collection of instances of a particular class, which is analogous to a table in a relational database that holds rows of data records.

Question 10

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) base normal form
B) first normal form
C) non-normal form
D) second normal form
E) third normal form

Accepted Answer

The answer of If the logical data model contains fields...

Question 11

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
E) volumetrics

Accepted Answer

Intrafile clustering refers to the process of storing similar records together in a table based on their primary key order. This method helps to improve the access speed of the database by reducing the need for scanning through the entire table to find related records. Denormalization, indexing, and interfile clustering are also optimization techniques, but they are not as directly related to the organization of records within a table as intrafile clustering is. Volumetrics is not a relevant term in this context.

Question 12

A(n) _____ is less expensive and easier for novice users to use, but it does not have the features that are necessary to support mission-critical or large scale systems.
A) database
B) database management system
C) end-user database administrative system
D) end-user database management system
E) enterprise database management system

Accepted Answer

The end-user database management system is designed for novice users and is less expensive than enterprise systems, but it lacks the features necessary to support mission-critical or large scale systems.

Question 13

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) primary
D) second
E) third

Accepted Answer

A data model in second normal form (2NF) does not contain repeating fields, and all non-key fields are fully functional and dependent on the entire primary key.

Question 14

A simple rule to follow when creating problem domain classes and data access 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
E) None of the above

Accepted Answer

It is best practice to have one data access and manipulation class for each concrete problem domain class to ensure a clear separation of concerns and maintainability in the codebase. Having two or more access and manipulation classes for a single domain class can lead to confusion and duplication of code, while having an arbitrary number of access and manipulation classes based on the methods or subclasses of the domain class can lead to unnecessary complexity.

Question 15

A(n) _____ is basically an electronic list of information that is stored on a disk.
A) sequential access file
B) unordered sequential access file
C) ordered sequential access file
D) random access file
E) transaction file

Accepted Answer

The answer of A(n) _____ is basically an electronic list...

Question 16

_____ 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) Raw data calculating
E) Volumetrics

Accepted Answer

Volumetrics is the process of estimating the amount of data that a hardware system will need to support. This estimation ensures that the hardware specifications are adequate to meet the project's needs. Therefore, option E is the correct choice for this question.

Question 17

A(n) _____ can support large volumes of data and support applications that run an entire company.
A) database
B) database management system
C) end-user database administrative system
D) end-user database management system
E) enterprise database management system

Accepted Answer

An enterprise database management system is designed to support large volumes of data and applications that run an entire company. It is typically used by medium to large organizations that require a centralized data management system to handle their business operations.

Question 18

SQL operates on _____.
A) rows of data at a time
B) columns of data at a time
C) tables of data at a time
D) the entire database
E) any of the above.

Accepted Answer

SQL operates on tables of data at a time, with the ability to join multiple tables together. It can also filter and manipulate the data within those tables, but ultimately it is designed to work with tables.

Question 19

Data may be stored in the following formats _____.
A) databases
B) entities
C) entities and files
D) files
E) files and databases

Accepted Answer

Data can be stored in either files or databases, as both are commonly used methods for storing information. Entities may be part of a database design but are not a standalone format for storage. Therefore, choice E is the best answer as it encompasses both files and databases.

Question 20

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 overhead requirements for the DBMS and number of instances in the tables

Accepted Answer

The size of a database is determined by the amount of raw data in the tables and overhead requirements for the DBMS. The amount of raw data in the tables is a fundamental factor, but the overhead requirements for the DBMS also contribute to the size of the database. The number of instances in the tables is a factor that affects the performance of the database but not necessarily its size. Therefore, B is the best choice.

Quiz 9: Data Management Layer Design

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.

The type of database that is most capable of supporting complex data types is _____.

A relational database may be optimized for _____.

The process of ensuring that values linking tables together through the primary and foreign keys are valid and correctly synchronized is _____.

Which of the following is NOT a characteristic of current object-relational databases?

If the data model does not have any repeating fields it is in _____.

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(n) _____ occurs when data are stored redundantly in a database and only some of the instances are updated when a change is needed.

In an object-oriented database, an extent is the equivalent to a(n) _____ in a relational database.

If the logical data model contains fields that depend on another non-primary key field, then it is in violation of the rules of _____.

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(n) _____ is less expensive and easier for novice users to use, but it does not have the features that are necessary to support mission-critical or large scale systems.

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 simple rule to follow when creating problem domain classes and data access and manipulation classes is that there should be ______________.

A(n) _____ is basically an electronic list of information that is stored on a disk.

_____ 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(n) _____ can support large volumes of data and support applications that run an entire company.

SQL operates on _____.

Data may be stored in the following formats _____.

The size of a database is determined by the _____.