Chapter 11 : Databases and Information System : Questions

A category of information in a database table

Field

Another name for the primary key is the key _____

Field

Property that must be satisfied for an entry to be accepted into the field

Field Constraint

Defines the maximum number of characters or numbers that a field can hold

Field Size

In a database, an object field is used for storing __________. "Variable-length text and numbers" "Graphics and audio content" "Fixed-length text and numbers" "Data about physical objects such as computers"

Graphics and audio content

Which of the following applications is considered an office support system? "A company's expert system" "An ATM system" "Windows XP" "Microsoft Office"

Microsoft Office

Which of the following is not a data-mining technique? "Clustering" "Model Management" "Classification" "Affinity Grouping"

Model Management

Large databases accessed by many users, such as those used by ebay, are usually designed as _____ databases.

Multidimensional

A technique for understanding spoken or written language

Natural Language Processing

All of the following are part of the process of data staging for a data warehouse except _____. "Storage" "Extraction" "Transformation" "Normalization"

Normalization

The process of eliminating data redundancy by ensuring that tables in a database pertain to a single topic is called _____.

Normalization

Confirms that only numbers are entered in the field

Numeric Check

Databases that contain not only data, but also methods of processing or manipulating that data are called ____________ databases.

Object-Oriented

Designed to assist employees in accomplishing their day-to-day tasks and to improve communications

Office Support System

A _____ relationship indicates that for each record in a table, there is only one corresponding record

One-to-Many

Transaction processing done in real time

Online Transaction Processing

SQL is a(n) __________. "Type of database architecture" "Query Language" "Application Programming Language" "Relational database program"

Query Language

Which of the following is NOT an example of a common data type? "Object" "Hyperlink" "Numeric" "Alphanumeric"

Alphanumeric

Which of the following is not a possible primary key? "Social Security Number" "Driver's License Number" "Street Address" "Student ID Number"

Street Address

Database query language

Structured Query Language

(True/False) The objective of an ERP is to accumulate all information relevant to running a business in a central location and make it readily available to whomever needs the information to make decisions

TRUE

(True/False) The two main advantages of multidimensional databases are that they can easily be customized to provide information to a variety of users (based on their need) and they can process data much faster than pure relational databases can

TRUE

(True/False) To establish a relationship between two tables, both tables must have a common field

TRUE

Broad-based software systems that integrate multiple data sources and tie together the various processes of an enterprise to enable information to flow more smoothly

Enterprise Resource Planning System

(True/False) A data warehouse includes data that pertains to just one period in time

FALSE

(True/False) All of the data in a relational database is stored in the same table

FALSE

(True/False) All related data , even simple tasks, should be housed in a database to create organized information

FALSE

(True/False) Data integrity means that the data contained in a database is safe from hackers and corrpution

FALSE

(True/False) Data mining is the process by which great amounts of data are normalized

FALSE

(True/False) Forecasting allows managers to assign a value, based on some criterion, to data

FALSE

(True/False) Primary keys have to be numbers that are already contained in the database

FALSE

(True/False) Small slices of a data warehouse are called data mines

FALSE

(True/False) There are no disadvantages associated with using databases

FALSE

(True/False) Transaction processing means that transaction data is accumulated until a certain point is reached, and then a number of transactions are processed all at once

FALSE

Which of the following is a reason for creating a list instead of creating a database? "To organize data for simple tasks" "To prevent data inconsistency" "To prevent data redundancy" "To make it easier to share data in a central location"

To organize data for simple tasks

A(n) ______________ is used to keep track of everyday business activities.

Transaction Processing System

Supports order processing, payroll, and other routine transactions

Transaction Processing System

Occurs when there is duplicate information in tables

Data Redundancy

Indicates what type of data can be stored in the field

Data Type

___________ is the process of ensuring that data entered into a database is correct (or at least reasonable) and complete.

Data Validation

What is important to remember when designing a database? "Data redundancy leads to wasted time and increased errors. Design your database to avoid redundancy" "Formatting is as important as data layout" "To design a database, a person must know a programming language such as SQL" "Databases are appropriate for maintaining small amounts of data but not so much for large amounts")

Data redundancy leads to wasted time and increased errors

Collection of related data that can be easily stored, sorted, organized, and queried

Database

Helps managers develop solutions for specific problems

Decision Support System

If all students at a college were from New Jersey, the "State" field could be set to a _____. "Test Value" "Foreign Key" "Default Value" "Standard Value"

Default Value

__________ are the values the database uses for the field unless the user enters another value.

Default Values

An individual trained in the design and building of databases is called a database _____

Administrator

Large object data in binary form

Binary Large Object

Data contained in the database is accurate and reliable

Data Integrity

Which of the following is NOT one of the four main operations of a DBMS? "Creating databases and entering data" "Extracting (or querying) data" "Viewing (or browsing) and sorting (or indexing) data" "Creating a data dictionary"

Creating a data dictionary

Companies use a software program on their Web sites to capture information about each click that users make as they navigate through the site. This data is referred to as _____.

Clickstream data

Ensures that all fields defined as required have data entered in them

Completeness Check

Compares the values of data in two or more fields to see if these values are reasonable

Consistency Check

All of the following are advantages of using a database except _____. "Maintaining Data Integrity" "Data Redundancy" "Flexible Use of Data" "Information Sharing"

Data Redundancy

Application software specifically designed to interact with the user to capture and analyze data

DBMS

When you want to extract data from two or more tables, you can use a(n) _____ query

Join

The primary key is a unique field also referred to as _____.

Key Field

Which of the following is not a category of information systems? "Management Information System" "Office Support System" "Knowledge-Based System" "Transaction Processing System"

Knowledge-Based System

Information system that produces management reports

Management Information System

Which of the following is a database management system? "SQL" "Microsoft Excel" "Microsoft Access" "Microsoft Project"

Microsoft Access

Ensures that data entered into the database falls within a certain span of numbers

Range Check

____________ databases are characterized by logical linkages between tables via primary and foreign keys.

Relational

A(n) ____________ organizes data in table format by logically grouping similar data into relations (or tables that contain related data).

Relational Database

Provides a consolidated picture of detailed data

Summary Report

(True/False) "Data integrity" means that that data contained in the database is accurate and reliable

TRUE

(True/False) A consistency check compares the values of data in two or more fields in a database to see if these values are reasonable

TRUE

(True/False) A record is a group of related database fields

TRUE

(True/False) Almost all relational databases today use structured query language, or SQL

TRUE

(True/False) Data dictionary and database schema refer to the same thing

TRUE

(True/False) Data mining is the process by which large amounts of data are analyzed to spot otherwise hidden trends

TRUE

(True/False) Data redundancy in a database can result in a waste of data entry time, storage space, and processing time

TRUE

(True/False) Databases provide for data centralization

TRUE

(True/False) Databases, data warehouses, and data marts are integral parts of information systems because they store the information that makes information systems functional

TRUE

(True/False) If you are going to store a phone number as a 10-digit number with no formatting, then the number data type is appropriate for that field

TRUE

(True/False) Information systems are software-based solutions used to gather and analyze information

TRUE

(True/False) Many businesses mine data to understand their customers better

TRUE

(True/False) Object-oriented databases are adept at handling unstructured data such as audio clips, video clips, pictures, and extremely large documents

TRUE

(True/False) Precautions must be taken to guarantee that information entered into a database is in a useful format

TRUE

(True/False) Real-time processing means that the database is queried and updated while the transaction is taking place

TRUE

Criteria used to ensure that data entered into the database is correct (or at least reasonable) and complete

Validation Rules