Quiz 3 - Databases

Comparing Microsoft Excel with Microsoft Access, which one of the following statements is NOT correct? Excel is more functional on calculation. Excel is the more popular data analysis tools used by today's managers. Excel has a better protection for the data. Access is designed specifically for data management. Access is a type of relational database. Thus, it is easy for Access to retrieve and analyze data from different data files and produce useful reports.

Excel has a better protection for the data.

One of the goals of the database approach to data management is to increase data redundancy.

False

Which of the following technologies would you use to store, manage, and analyze the social media data (some are unstructured data), collected by a major online retailer? DBMS data mart OLAP Hadoop data warehouse

Hadoop

The tool that enables users to view the same data in different ways using multiple dimensions is: predictive analysis. SQL. data mining. OLAP.

OLAP.

The most prominent data manipulation language today is: Access DB2 SQL C++ Crystal Reports

SQL

In a relational database, complex groupings of data must be streamlined to minimize awkward many-to-many relationships.

True

OLAP software allows users to explore data from a number of different perspectives, and obtain answers to ad-hoc questions in a fairly rapid amount of time.

True

The coupling of data with the software programs that manipulate the data, such that changes in programs requires changes to the data, is called program-data dependence.

True

The database approach to data management requires ____. at least one flat file data redundancy a DBMS program-data dependence

a DBMS

The data dictionary serves as an important data management tool by: assigning attributes to the data. creating an inventory of data contained in the database. presenting data as end users or business specialists would perceive them. maintaining data in updated form.

creating an inventory of data contained in the database.

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the: data dictionary. data definition diagram. entity-relationship diagram. relationship dictionary.

data dictionary.

A traditional approach to data management means that ____. data files are created individually by each application data files are placed into objects data files are managed by the DBMS no data files are used

data files are created individually by each application

The special organizational function whose responsibilities include the technical and operational aspects of managing data, including physical database design and maintenance, is called: data administration. database administration. information policy administration. data auditing.

database administration.

Data mining is a tool for allowing users to access the vast amounts of data in a data warehouse. find hidden relationships in data. quickly compare transaction data gathered over many years. obtain online answers to ad-hoc questions in a rapid amount of time. summarize massive amounts of data into much smaller, traditional reports.

find hidden relationships in data.

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called: normalization. data scrubbing. data cleansing. data defining.

normalization.

The logical view: shows how data are organized and structured on the storage media. presents an entry screen to the user. allows the creation of supplementary reports. presents data as perceived by end users.

presents data as perceived by end users.

A field identified in a table as holding the unique identifier of the table's records is called the: primary key. foreign key. primary field. unique ID.

primary key.

In a relational database, the three basic operations used to develop useful sets of data are: select, project, and where. select, join, and where. select, project, and join. select, from, and join.

select, project, and join.

A household appliances manufacturer has hired you to help analyze their social media datasets to determine whether their refrigerators are liked by customers. Which of the following tools would you use to analyze this data? data mining software for identifying associations data mining software for forecasting text mining tools Web usage mining technologies sentiment analysis software

sentiment analysis software

As long as tables in a relational database ____, they can be linked to provide useful information. share at least one common data attribute share two or more common data attributes are projected have been normalized

share at least one common data attribute