question

a grouping of characteristics into a word, a group of words is called a record.

answer

True

question

each characteristic or quality describing a particular entity is called an attribute

answer

True

question

every record in a file should contain at least one key field

answer

True

question

In normalization, complex groupings of data are streamlined to eliminate awkward many-to-many relationships.

answer

True

question

Many applications today require databases that can store and retrieve multimedia.

answer

True

question

One of the drawbacks to OODBMS is that they cannot work with applets.

answer

False

question

OODBMS are slower than relational DBMS.

answer

True

question

A data warehouse may include information from legacy systems.

answer

True

question

A data warehouse is typically comprised of several smaller data marts

answer

False

question

DBMS simplify how end users work with databases by separating the logical and physical views of the data.

answer

True

question

OLAP is a key tool of BI.

answer

True

question

OLAP is used to find hidden patterns and relationships in large databases, and infer rules from these to infer future behavior.

answer

False

question

Data mining can be a challenge to individual privacy.

answer

True

question

Predictive analysis is a technique of data mining.

answer

False

question

Implementing a Web interface for a database requires changes to the database itself.

answer

False

question

Common Gateway Interface is a specification for processing data on a Web server.

answer

True

question

In linking databases to the Web, the role of the application server is to host the DBMS.

answer

False

question

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

answer

True

question

The use of different terms for identifying data in a firm?s various information systems is an example of redundant data.

answer

True

question

Data cleansing is the same process as data scrubbing.

answer

True

question

Which of the following is not a true statement about MDM?

answer

It is a quality-of-data concept that is used to identify a company?s most important data.

question

What is the first step you should take in managing data for a firm?

answer

Identify the data needed to run the business

question

An example of a pre-digital database is a:

answer

library's card-catalog

question

Which of the following best illustrates the relationship between entities and attributes?

answer

The entity CUSTOMER with the attribute ADDRESS

question

The type of logical database model that treats data as if they were stored in two-dimensional tables is the:

answer

relational DBMS.

question

What are the relationships that the relational database is named for?

answer

Relationships between entities

question

A characteristic or quality describing an entity is called a(n):

answer

attribute.

question

The most basic business database is comprised of:

answer

five tables: for customers, employees, suppliers, products, and sales.

question

In a table for customers, the information about a single customer would reside in a single:

answer

row

question

In a relational database, a record is also called a(n):

answer

tuple

question

A field identified in a table as holding the unique identifier of the table's records is called the:

answer

primary key.

question

A field identified in a record as holding the unique identifier for that record is called the

answer

key field

question

A schematic of the entire database that describes the relationships in a database is called a(n):

answer

entity-relationship diagram.

question

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends

answer

in two short marks.

question

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:

answer

with a crow's foot preceded by a short mark.

question

A table that links two tables that have a many-to-many relationship is often called a(n):

answer

intersection relation.

question

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

answer

normalization.

question

A DBMS makes the:

answer

physical database available for different logical views.

question

The logical view of a database:

answer

presents data as they would be perceived by end users

question

Which of the following is not a typical feature of DBMS?

answer

Query wizard tool

question

Oracle Database Lite is a:

answer

DBMS for small handheld computing devices.

question

Access is a

answer

DBMS for desktop systems

question

My SQL is a:

answer

popular open-source DBMS.

question

Microsoft SQL Server is a(n):

answer

DBMS for midrange computers.

question

In a relational database, the three basic operations used to develop useful sets of data are:

answer

select, project, and join.

question

The select operation:

answer

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

question

The join operation:

answer

combines relational tables to provide the user with more information than is otherwise available

question

The project operation:

answer

creates a subset consisting of columns in a table.

question

The data dictionary serves as an important data management tool by:

answer

creating an inventory of data definitions contained in the database.

question

A n automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the:

answer

data dictionary.

question

The specialized language programmers use to add and change data in the database is called:

answer

data definition language.

question

The most prominent data manipulation language today is:

answer

SQL

question

DBMS typically include report-generating tools in order to:

answer

display data in an easier-to-read format

question

The type of database management approach that can handle multimedia is the:

answer

object-oriented DBMS.

question

Which of the following database types is useful for storing Java applets as well as handling large numbers of transactions?

answer

OODBMS

question

A data warehouse is composed of:

answer

both historical and current data.

question

W hich of the following statements about data warehouses is not true?

answer

Data warehouse systems provide easy-to-use tools for managers to easily update data.

question

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:

answer

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

question

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:

answer

business intelligence.

question

The tool that enables users to view the same data in different ways using multiple dimensions is:

answer

OLAP.

question

OLAP is a tool for enabling:

answer

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

question

Data mining is a tool for allowing users to:

answer

find hidden relationships in data

question

In terms of the data relationships found by data mining, associations refers to:

answer

occurrences linked to a single event

question

In terms of the data relationships found by data mining, sequences refers to:

answer

events linked over time

question

An alternative to using application server software for interfacing between a Web server and back-end databases is:

answer

HTML.

question

Businesses use ________ tools to search and analyze unstructured data sets, such as e-mails and memos

answer

Text mining

question

The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.

answer

data redundancy

question

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called

answer

data scrubbing

question

Which of the following would you use to find patterns in user interaction data recorded by Web servers?

answer

Web usage mining

question

Which of the following would you use to find out which Web sites with content related to database design were the most often linked to by other Web sites?

answer

Web structure mining

question

What is the Primary Key of the Animals Table?

answer

Pet Number

question

What is the Foreign Key of the Owners Table?

answer

No Foreign Key Exists

question

What is the Primary Key of the Animal Owners Table?

answer

Combined Key (Pet Number and Owner ID)

question

What are the Foreign Key(s) of the Animal Owners Table?

answer

Both Pet Number and Owner ID

question

No Repeating Elements or Groups of Elements describes which Normal Form?

answer

First Normal Form

question

No Partial Dependencies on a Concatenated Key describes which Normal Form?

answer

Second Normal Form

question

No Dependencies on Non-Key Attributes describes which Normal Form?

answer

Third Normal Form

question

The database table below is normalized to what normal form?

answer

...

question

Tables that contain a Concatenated Primary Key and fields that rely on only part of the key, fail the test for which Normal Form?

answer

Second Normal Form

question

What Normal Form process rids the database of repeating elements?

answer

First Normal Form

question

Which data type should be used for a field containing zip code data in access

answer

Text

question

Which data type should be used for a field containing Price data in Access

answer

Currency

question

Which data type should be used for a field containing street address data in access?

answer

Text

question

Which data type should be used for a field containing E numbers in Access?

answer

Text

question

What type of key should be used for linking a table?

answer

Foreign Key

Bus 3500 Exam 1-MIS – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards