question

True

answer

Each characteristic or quality describing a particular entity is called an attribute.

question

False

answer

A grouping of characters into a word, a group of words, or a complete number is called a record.

question

True

answer

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

question

True

answer

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

question

True

answer

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

question

True

answer

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

question

False

answer

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

question

True

answer

OODBMS are slower than relational DBMS.

question

True

answer

A data warehouse may include information from legacy systems.

question

False

answer

A data warehouse is typically comprised of several smaller data marts.

question

True

answer

OLAP is a key tool of BI.

question

False

answer

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

question

True

answer

Data mining can be a challenge to individual privacy.

question

False

answer

Predictive analysis is a technique of data mining.

question

False

answer

Implementing a Web interface for a database requires changes to the database its

question

True

answer

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

question

False

answer

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

question

True

answer

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

question

True

answer

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

question

True

answer

Data cleansing is the same process as data scrubbing.

question

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

answer

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

question

I dentify the data needed to run the business

answer

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

question

library's card-catalog.

answer

An example of a pre-digital database is a:

question

The entity CUSTOMER with the attribute ADDRESS

answer

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

question

relational DBMS.

answer

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

question

Relationships between entities

answer

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

question

attribute

answer

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

question

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

answer

The most basic business database is comprised of

question

row

answer

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

question

tuple.

answer

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

question

primary key.

answer

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

question

key field

answer

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

question

entity-relationship diagram.

answer

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

question

in two short marks.

answer

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

question

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

answer

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

question

intersection relation.

answer

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

question

normalization.

answer

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

question

physical database available for different logical views

answer

A DBMS makes the

question

presents data as they would be perceived by end users.

answer

The logical view of a database

question

Query wizard tool

answer

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

question

DBMS for small handheld computing devices.

answer

Oracle Database Lite is a

question

DBMS for desktop systems

answer

Access is a:

question

popular open-source DBMS.

answer

MySQL is a

question

DBMS for midrange computers.

answer

Microsoft SQL Server is a(n):

question

select, project, and join

answer

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

question

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

answer

The select operation:

question

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

answer

The join operation

question

creates a subset consisting of columns in a table

answer

The project operation:

question

creating an inventory of data definitions contained in the database

answer

The data dictionary serves as an important data management tool by

question

data dictionary.

answer

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:

question

data manipulation language.

answer

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

question

SQL.

answer

The most prominent data manipulation language today is:

question

display data in an easier-to-read format

answer

DBMS typically include report-generating tools in order to:

question

object-oriented DBMS

answer

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

question

OODBMS

answer

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

question

both historical and current data

answer

A data warehouse is composed of:

question

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

answer

Which of the following statements about data warehouses is not true?

question

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

answer

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

question

business intelligence

answer

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

question

OLAP.

answer

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

question

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

answer

OLAP is a tool for enabling

question

find hidden relationships in data

answer

Data mining is a tool for allowing users to

question

occurrences linked to a single event

answer

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

question

events linked over time

answer

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

question

HTML

answer

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

question

text mining

answer

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

question

data redundancy

answer

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.

question

data scrubbing

answer

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

question

Web usage mining

answer

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

question

Web structure mining

answer

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?

MIS Exam 1 – Flashcards with Answers

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards