Chapter 13

The information that describes data is referred to as ________. A)metadata B)gammadata C)moredata D)alphadata

A

________ is the transformation of complex user views and data stores to a set of smaller, stable data structures. A)Categorization B)Capitalization C)Alphabetization D)Normalization

D

A ________ is a central source of data meant to be shared by many users for a variety of applications. A)database B)data dictionary C)data warehouse D)data model

A

A ________ represents more than one of the other entity. A)crow's foot B)single line C)double line D)dotted line

A

A process of applying algorithms for extracting patterns from data stored in data warehouses that are typically not apparent to human decision makers is called: A)data mining. B)data warehousing. C)data denormalization. D)databasing.

A

A(n)________ represents additional attributes of an entity that may not be present on every record of the entity. A)entity subtype B)entity type C)primary entity D)secondary entity

A

An attribute is some characteristic of a(n)________. A)entity B)relationship C)reality D)record definition

A

What is a collection of data items that have something in common with the entity? A)a record B)an attribute C)a data item D)an entity

A

Which word is used interchangeably with the term data item? A)attribute B)record C)key D)tuple

A

Within the realm of ________, there are entities and attributes. A)reality B)metadata C)relationships D)databases

A

________ are associations between entities. A)Relationships B)Subtypes C)Types D)Entities

A

The integrity constraint that ensures that every many record in a one-to-many relationship has a matching record in the one file is called: A)entity integrity. B)referential integrity. C)domain integrity. D)ordinal integrity. E)cardinal integrity.

B

Transaction files: A)are large files, containing all main information about an entity. B)are used to update master files and produce reports. C)cannot contain several record types. D)are always stored using indexed-sequential organization.

B

What is defined as any data item in a record that is used to identify the record? A)an attribute B)a key C)a primary key D)an entity

B

Which doesn't DBMS allow? A)creation of database B)classification of database C)modification of database D)updating the database E)retrieval of data

B

Which order is correct in the retrieval and presentation of data? I. Select rows from the relation. II. Derive new attributes. III. Join two relations together. IV. Present data. V. Choose a relation from the database. VI. Project columns from the relation. VII. Calculate totals and performance measures. VIII. Index or sort rows. A)V - III - II - I - VIII - IV - VI - VII B)V - III - VI - I - II - VIII - VII - IV C)III - V - VI - I - II - VIII - VII - IV D)V - III - II - I - VI - IV - VII - VIII E)III - V - II - I - VI - VII - VIII - IV

B

An alternative to building conventional files is building a ________. A)data dictionary B)data warehouse C)database D)data model

C

The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called: A)referential integrity. B)normalization. C)denormalization. D)data warehousing. E)online analytic processing.

C

The symbol used to represent additional attributes of another entity that may not be present on every record of the first entity is called an: A)associative entity. B)attributive entity. C)entity subtype. D)self-join. E)ordinal entity.

C

What type of entity is used to represent repeating groups? A)fundamental entity B)associative entity C)attributive entity D)iterative entity

C

Which file is used when it is necessary to run a program, but no printer is available? A)a master file B)a table file C)a report file D)a work file E)a transaction file

C

Which is not related to conventional files? A)Files will remain a practical way to store data for some applications. B)A file can be designed and built quite rapidly. C)Files are a central source of data meant to be shared by many users for a variety of applications. D)The concerns for data availability and security are minimized.

C

Which of the following is not a difference between a data warehouse and a traditional database? A)Data in a data warehouse are organized around major subjects rather than transactions. B)Data in a data warehouse cover a much longer time frame that transaction data. C)Data in a data warehouse are organized for rapid updating. D)Data in a data warehouse are organized for fast queries. E)Data in a data warehouse usually include data from outside sources.

C

Which of the following is not one of the four anomalies that may occur when creating database tables? A)data redundancy B)update anomaly C)primary anomaly D)insert anomaly E)deletion anomaly

C

Which of the following is true when implementing a one-to-many relationship? A)The file on the one end has a foreign key consisting of the primary key of the many end. B)The file on the one end has a concatenated key of its primary key and the many end key. C)The file on the many end has a foreign key consisting of the primary key on the one end. D)The file on the many end has a concatenated key of its primary key and the one end key.

C

Which type of file contains all the attributes for an entity as well as a primary key and several secondary keys? A)a transaction file B)a relational file C)a master file D)a keyed index file

C

________ is a process to eliminate repeating groups found in variable-length records. A)Alpha row selection B)First row selection C)Normalization D)Denormalization

C

A well-designed ________ can be more flexible than separate files. A)data dictionary B)data warehouse C)data model D)database

D

When an entity has a relationship connecting it to itself, it is called a(n): A)unitary relationship. B)inverse relationship. C)extensible join. D)self-join.

D

Which is an advantage of the database approach? A)All of the data are stored in one place. B)Data are more vulnerable to catastrophes. C)It comes about when attempting to keep the cost of storing the data to a reasonable amount. D)It allows users their own view of the data.

D

Which is incorrect about reality, data, and metadata? A)Within the realm of reality, there are entities and attributes. B)There are record occurrences within the realm of actual data. C)Within the realm of metadata, there are record definitions and data item definitions. D)There are data item occurrences within the realm of files.

D

Each master file should have programs to: A)add new records. B)update master file records. C)delete master file records. D)read and process records from the master file. E)All of the above.

E

What can be constructed by choosing two or more data items and combining them? A)a primary key B)an attribute C)a secondary key D)an entity E)a concatenated key

E

Which is not an effectiveness objective of the database? A)ensuring that data can be shared among users for a variety of applications B)ensuring all data required for current and future applications will be readily available C)allowing the database to evolve and the needs of the users to grow D)allowing users to construct their personal view of the data without concern for the way the data are physically stored E)maintaining data that are both accurate and inconsistent

E

Which order is correct for the analyst to normalize a data structure? I. Remove all repeating groups and identify the primary key. II. Remove any transitive dependencies. III. All partial dependencies are removed and placed in another relation. A)III - II - I B)I - II - III C)III - I - II D)II - I - III E)I - III - II

E