Question 1

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. This type of system provides centralized control and management of data across multiple departments and functions within an organization. Option A, B, C, and D are not suitable choices as they are not specifically designed to support entire companies.

Question 2

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

Denormalizing the physical model involves combining multiple tables into a single table by duplicating data. This reduces the need for joins and can improve query performance, at the cost of increased storage requirements and potential data consistency issues. Clustering refers to physically grouping related data on disk to improve I/O performance. Indexing involves adding indexes to tables to speed up data access. Normalizing involves breaking down tables into smaller, more specialized tables to eliminate redundancies and improve data consistency. Optimization involves various techniques to improve query performance, such as caching, parallel processing, and query rewriting. Of these options, denormalization is the best choice to reduce the number of joins and improve data access speed.

Question 3

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 involves storing similar records together in primary key order within the same file to optimize access speed. Denormalization involves intentionally introducing redundancy into a database to reduce JOIN statements and improve query performance. Indexing involves creating data structures that allow for faster access to data in a database. Interfile clustering and volumetrics are not related to optimizing access speed in a database.

Question 4

_____ 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 the hardware will need to support, so that the server hardware specifications are sufficient for the project's needs.

Question 5

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 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) requires that all fields in a table have atomic values (i.e. indivisible), and that there are no repeating fields or groups of fields. Thus, if the data model does not have any repeating fields, it meets the requirements of 1NF.

Question 7

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 these

Accepted Answer

There should be one data access and manipulation class for each concrete problem domain class. This facilitates separation of concerns and helps maintain a clear and organized code structure. It also makes it easier to make changes to the data access and manipulation code without affecting the problem domain code. Having two or more data access and manipulation classes for each problem domain class or basing the number of data access and manipulation classes on the number of methods or subclasses of the problem domain class can lead to unnecessary complexity and reduced maintainability.

Question 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 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. Raw data refers to the actual data stored in the tables while overhead requirements refer to the resources needed by the DBMS to manage and maintain the database, including indexes, transaction logs, and backup files. The number of instances in the tables may affect performance and access times but is not a direct factor in determining the size of the database.

Question 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) 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 10

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 refers to the process of ensuring that values linked together through primary and foreign keys are valid and correctly synchronized. Therefore, the best choice is E. Hierarchical integrity, primary integrity, table integrity, and referential unity are not correct terms for this definition.

Question 11

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 12

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 these

Accepted Answer

A update anomaly occurs when there is redundancy in the data stored in a database, and some instances are updated while others are not. This can lead to inconsistencies in the data and affect data integrity. Therefore, B is the correct answer. A, C, and D are incorrect because they do not specifically describe the phenomenon of redundant data causing inconsistencies in updates.

Question 13

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 may be optimized for both storage efficiency and speed of access. It is important to minimize the space required to store data while also ensuring that the data can be accessed quickly and efficiently. Therefore, the correct choice is E, which includes both storage efficiency and speed of access.

Question 14

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 these are characteristics of object-relational databases

Accepted Answer

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

Question 15

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 16

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

Object-oriented DBMS is designed to handle complex data types, such as multimedia, and supports objects, classes, and inheritance, making it well-suited for complex data structures.

Question 17

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 18

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 may be stored in files and databases. While entities may exist within databases, the question is specifically asking about formats for storing data. Therefore, the most accurate choice is E.

Question 19

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. It can also perform operations on specific columns or rows within those tables, but it primarily deals with the structure and data within a table. It does not operate on the entire database at once.

Question 20

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

An end-user database management system (end-user DBMS) is designed for novice users who do not have technical knowledge about databases. It is less expensive and easier to use, but it does not have the features necessary to support mission-critical or large scale systems. An enterprise database management system (enterprise DBMS) is designed for large-scale, mission-critical applications and is more expensive and complex than an end-user DBMS. Therefore, the best choice for this question is D) end-user database management system.

Quiz 9: Data Management Layer Design

A(n) _____ can support large volumes of data and support applications that run an entire company.

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.

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

_____ 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) _____ is basically an electronic list of information that is stored on a disk.

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

A simple rule to follow when creating problem domain classes and data access and manipulation classes is that there should be ______________.

The size of a database is determined by the _____.

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) _____.

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

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

A relational database may be optimized for _____.

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

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

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

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.

Data may be stored in the following formats _____.

SQL operates on _____.

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.