INFO 360 chapter 6 quiz

physical database available for different logical views

A DBMS makes the: A) physical database available for different relational views. B) logical database available for different analytical views. C) physical database available for different logical views. D) relational database available for different analytical views. E) relational database available for different physical views.

attribute

A characteristic or quality describing an entity is called a(n): A) attribute. B) tuple. C) table. D) field. E) key field.

warehouse

A data ________ stores current and historical data of potential interest to decision makers throughout the company. A) mart B) archive C) mine D) warehouse E) center

it typically focuses on a single subject area or line of business

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because: A) all the information is historical. B) it typically focuses on a single subject area or line of business. C) all of the information belongs to a single company. D) it uses a web interface. E) it is open-source.

primary key

A field identified in a table as holding the unique identifier of the table's records is called the: A) key field. B) primary field. C) identifying field. D) primary key. E) foreign key

find hidden relationships in data

Data mining is a tool for allowing users to: A) summarize massive amounts of data into much smaller, traditional reports. B) find hidden relationships in data. C) obtain online answers to ad hoc questions in a rapid amount of time. D) perform multidimensional data analysis. E) quickly compare transaction data gathered over many years.

normalization

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called: A) normalization. B) data administration. C) data management. D) data scrubbing. E) data cleansing.

Identify the data needed to run the business

What is the first step you should take in managing data for a firm? A) Remove redundancy. B) Normalize the data before importing to a database. C) Audit your data quality. D) Cleanse the data before importing it to any database. E) Identify the data needed to run the business.

Data dictionary

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security? A) Relationship dictionary B) Entity-relationship diagram C) Data dictionary D) Data definition diagram E) Referential integrity module

Relational DBMS

Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables? A) Open source DBMS B) Two-tiered DBMS C) Relational DBMS D) Pre-digital DBMS E) Hierarchical DBMS