Computer Science Questions

OLAP is a tool for enablingA) users to obtain online answers to ad-hoc questions in a rapid amount of time.B) users to view both logical and physical views of data.C) programmers to quickly diagram data relationships.D) programmers to normalize data.

Which common database challenge is illustrated by a person multiple copies of an LL Bean catalog, each addressed to a slightly different variation of his or her full name?A) data normalizationB) data accuracyC) data redundancyD) data inconsistency

You work for a retail clothing chain whose primary outlets are in shopping malls and are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable ofA) identifying associations.B) identifying clusters.C) identifying sequences.D) classification.

A data warehouse is composed ofA) historical data from legacy systems.B) current data.C) internal and external data sources.D) historic and current internal data.

All of the following are technologies used to analyze and manage big data except A) Cloud computing B) NoSQLC) in memory computingD) Analytic platforms

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable ofA) identifying associations.B) identifying clusters.C) identifying sequences.D) classification.

The tool that enables users to view the same data in different ways using multiple dimensions isA) predictive analysis.B) SQL.C) OLAP.D) data mining.

In a table for customers, the information about a single customer would reside in a singleA) field.B) row.C) column.D) table.

The specialized language programmers use to add and change data in the database is calledA) a data access language.B) a data manipulation language.C) Structured Query Language.D) a data definition language.

The select operationA) combines relational tables to provide the user with more information than is otherwise available.B) creates a subset consisting of columns in a table.C) identifies the table from which the columns will be selected.D) creates a subset consisting of all records in the file that meet stated criteria.

In a relational database, a record is referred to in technical terms as a(n)A) tuple.B) row.C) entity.D) field.

DBMSs typically include report-generating tools in order toA) retrieve and display data.B) display data in an easier-to-read format.C) display data in graphs.D) perform predictive analysis.

Big Data does not refer toA) datasets with fewer than a billion recordsB) datasets with unstructured dataC) Machine generated dataD) data created by social media

In a relational database, the three basic operations used to develop useful sets of data areA) select, project, and where.B) select, join, and where.C) select, project, and join.D) select, from, and join.

A field identified in a record as holding the unique identifier for that record is called theA) primary key.B) key field.C) primary field.D) unique ID.

The project operationA) combines relational tables to provide the user with more information than is otherwise available.B) creates a subset consisting of columns in a table.C) organizes elements into segments.D) identifies the table from which the columns will be selected.

Which of the following is not one of the main problems with a traditional file environment?A) data inconsistencyB) program-data independenceC) lack of flexibility in creating ad-hoc reportsD) poor security

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

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

Which of the following best illustrates the relationship between entities and attributes?A) the entity CUSTOMER with the attribute PRODUCTB) the entity CUSTOMER with the attribute PURCHASEC) the entity PRODUCT with the attribute PURCHASED) the entity PRODUCT with the attribute CUSTOMER