Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
35 Cards in this Set
- Front
- Back
|
Data rot refers to the quality of the data itself. True/False |
False
|
|
|
Data marts are designed for the end-user needs in a strategic business unit or department. True/False |
True |
|
|
Master data are a set of core data that span all of an enterprise's information systems. True/False |
True |
|
|
Data _____ ensures applications cannot access data associated with other applications. a. Inconsistency d. Isolation e. Dependence |
d. Isolation |
|
|
__________ involves the analysis of accumulated data and involves a ___________. a. OLTP, data marts b. OLTP, database c. OLAP, data warehouse d. OLTP, data warehouse e. OLAP, database |
c. OLAP, data warehouse |
|
|
The decisions about hardware or software last longer, and have a broader impact, than decisions about data. True/False |
False |
|
|
The process of moving data from various sources into the data warehouse is called: a. Online transaction processing b. Uploading c. Online analytical processing d. Master data management e. Extracting, transforming, and loading |
e. Extracting, transforming, and loading |
|
|
In a data warehouse, existing data are constantly purged as new data come in. True/False |
False |
|
|
Not including alphabetic characerts in a Social Security Number field is an example of _______. a. Data consistency b. Data redundancy c. Application/data dependence d. Data integrity e. Data isolation |
d. Data integrity |
|
|
In a database, the primary key field is used to _________. a. Create linked lists b. Identify duplicated data c. Uniquely identify an attribute d. Specify an entity e. Uniquely identify an entitiy |
e. Uniquely identify an entity |
|
|
An entity is a person, place, thing, or event about which information is maintained.
|
True |
|
|
________ is a method for analyzing and reducing a relational database to its most streamlined form. a. Query by example b. Structured query c. Normalization d. Relational analysis e. Joining |
c. Normalization |
|
|
It is difficult to manage and maintain organizational data. For example, it is common for customers to move and for companies to go out of business. This is an example of ________. a. Data security b. Scattered data c. Big data d. Data degradation e. Data rot |
d. Data degradation |
|
|
_________ occurs when the same data are stored in many places. a. Data consistency b. Data redundancy c. Data integrity d. Application/Data dependence e. Data isolation |
b. Data redundancy |
|
|
The data in a data warehouse have which of the following characteristics? a. They are coded in different formats b. They are typically retained for a defined, but limited, period of time. c. They are updated in real time. d. They are organized in a hierarchical structure e. They are organized by subject |
e. They are organized by subject |
|
|
A data mart is a low-cost, scaled-down version of a data warehouse True/False |
True |
|
|
A(n) _______ is a logical grouping of related fields. a. File b. Byte c. Record d. Database e. Field |
c. Record |
|
|
Structured query language is a relational database language that enables users to perform complicated searches with relatively simple statements. True/False |
True |
|
|
Place the following members of the data hierarchy in their correct order: a. Bit, byte, field, record, table, database b. Bit, byte, field, record, database, table c. Bit, field, byte, record, table, database d. Byte, bit, record, field, database, table e. Bit, record, field, byte, table, database |
a. Bit, byte, field, record, table, database |
|
|
In a university's relational database, the student record contains information regarding the student's last name. The last name is a(n): a. Entity b. Object c. File d. Attribute e. Primary Key |
d. Attribute |
|
|
The attribute(s) you would NOT expect to see in a Computer entity is/are: a. phone number b. manufacturer c. memory size d. processor e. disk size |
a. phone number |
|
|
You have moved to a different apartment, but your electricity bill continues to be sent to your old address. The Post Office in your town has which problem with its data management? a. Data dependence b. Data isolation c. Data security d. Data inconsistency e. Data redundancy |
d. Data inconsistency |
|
|
At your university, students can take more than none class, and each class can have more than one student. This is an example of what kind of relationship? a. Many-to-many b. Some-to-many c. One-to-many d. One-to-one e. Many-to-one |
a. Many-to-many |
|
|
The data dictionary stores definitions and descriptions of data attributes, including data validation rules, security permissions, and other metadata. True/False |
True |
|
|
Online analytical processing (OLAP) involves the analysis of accumulated data by end users True/False |
True |
|
|
Which of the following has (have) the broadest impact on an organization? a. Decisions about software b. Both decisions about hardware and decisions about software. c. Decisions about hardware d. All of these have an equal impact e. Decisions about data. |
e. Decisions about data. |
|
|
A negative value for a student's grade point average is an example of a data integrity problem. True/False |
True |
|
|
Sarbanes-Oxley legally mandates that public companies evaluate and disclose the effectiveness of their ____________. a. Sales goals b. HR rules c. Financial controls d. IT policies e. Primary vendors |
c. Financial controls |
|
|
Data ______ ensures data meets system constraints. a. Integrity b. Isolation c. Independence d. Consistency e. Security |
a. Integrity |
|
|
Data governance is an approach to managing functional area information systems. True/False |
False |
|
|
Data dictionaries perform all of the following except: a. Providing information on which users can access particular attributes b. Providing information on the name of each attribute c. Providing information on why attributes are needed in the database d. Providing information on each record e. Defining the format necessary to enter data into the database |
d. Providing information on each record |
|
|
Tacit knowledge is the more objective, rational, and technical types of knowledge True/False |
False |
|
|
The relational database model is based on the concept of three-dimensional tables. True/False |
False |
|
|
In the relational database model, related tables can be joined when they contain common ________. a. Files b. Rows c. Records d. Primary keys e. Fields |
e. Fields |
|
|
The information silos are information that is stored and isolated in separate functional areas. True/False |
True |
