INFO ch.4

Access is a: DBMS for mobile devices. popular open-source DBMS. DBMS for mainframe computers. DBMS for desktop PC systems. DBMS for midrange computers.

DBMS for desktop PC systems

Which of the following best describes the importance of creating an accurate data model for your business's database? It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve. It is not essential, as the data model itself is modified by the database continuously. It is somewhat important, as the type of data model will define what kinds of data will be stored. It is essential, as table relationships cannot be created without an accurate data model. It is unnecessary, as a well-designed database should not require one.

It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve.

Which of the following enables users to view the same data in different ways using multiple dimensions? SQL Data mining Big data Hadoop OLAP

OLAP

The most prominent data manipulation language today is Access. DB2. SQL. Crystal Reports.

SQL.

Which of the following best illustrates the relationship between entities and attributes? The entity PRODUCT with the attribute CUSTOMER The entity CUSTOMER with the attribute ADDRESS The entity ADDRESS with the attribute CUSTOMER The entity PRODUCT with the attribute PURCHASE The entity CUSTOMER with the attribute PRODUCT

The entity CUSTOMER with the attribute ADDRESS

Data governance deals with the policies and processes for managing the integrity and security of data in a firm. True False

True

Every record in a file should contain at least one key field. True False

True

In-memory computing relies on a computer's main memory for storing data. True False

True

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

Two-tiered DBMS

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

attribute.

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as: DSS. OLAP. in-memory computing. business intelligence. data mining.

business intelligence.

The select operation: creates a subset consisting of columns in a table. specifies the content of the database. identifies the table from which the columns will be selected. creates a subset consisting of all records in the file that meet stated criteria. combines relational tables to provide the user with more information than is otherwise available.

creates a subset consisting of all records in the file that meet stated criteria.

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

creating an inventory of the data elements contained in the database.

A schematic of the entire database that describes the relationships in a database is called a(n): data dictionary. entity-relationship diagram. intersection relationship diagram. field key diagram. data definition diagram.

entity-relationship diagram.

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

find hidden relationships in data.

A DBMS reduces data redundancy and inconsistency by enforcing referential integrity. utilizing a data dictionary. minimizing isolated files with repeated data. uncoupling program and data.

minimizing isolated files with repeated data.

OLAP is a tool that enables users to: normalize data. quickly diagram data relationships. view both logical and physical views of data. find hidden patterns in large databases. obtain online answers to ad hoc questions in a rapid amount of time.

obtain online answers to ad hoc questions in a rapid amount of time.

Hadoop is a(n): high-speed platform used to analyze large data sets. open-source software framework designed for distributing data-processing over inexpensive computers. NoSQL database technology that stores both data and procedures acting on the data as objects. data mining platform designed for storing and analyzing big data produced by web communications and transactions. pre-configured hardware-software system designed for analyzing big data.

open-source software framework designed for distributing data-processing over inexpensive computers.

The logical view of a database: presents data as they would be perceived by end users. shows the relationships between entities and attributes. presents an entry screen to the user. shows how data are organized and structured on the storage media. allows the creation of supplementary reports.

presents data as they would be perceived by end users.

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

primary key.

Relational database systems use ________ to ensure that relationships between coupled tables remain consistent. intersection relations entity-relationship diagrams foreign keys one-to-one ordering referential integrity rules

referential integrity rules

In a table for customers, the information about a single customer would reside in a single: column. entity. row. table. field.

row.

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

select, project, and join.

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

tuple.