(True/False) "Data integrity" means that that data contained in the database is accurate and reliable
(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/False) All related data , even simple tasks, should be housed in a database to create organized information
(True/False) Data integrity means that the data contained in a database is safe from hackers and corrpution
(True/False) Data mining is the process by which large amounts of data are analyzed to spot otherwise hidden trends
(True/False) Data redundancy in a database can result in a waste of data entry time, storage space, and processing time
(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/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/False) Information systems are software-based solutions used to gather and analyze information
(True/False) Object-oriented databases are adept at handling unstructured data such as audio clips, video clips, pictures, and extremely large documents
(True/False) Precautions must be taken to guarantee that information entered into a database is in a useful format
(True/False) Real-time processing means that the database is queried and updated while the transaction is taking place
(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/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/False) To establish a relationship between two tables, both tables must have a common field
(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
__________ are the values the database uses for the field unless the user enters another value.
___________ is the process of ensuring that data entered into a database is correct (or at least reasonable) and complete.
____________ databases are characterized by logical linkages between tables via primary and foreign keys.
A _____ relationship indicates that for each record in a table, there is only one corresponding record
A(n) ____________ organizes data in table format by logically grouping similar data into relations (or tables that contain related data).
A(n) ______________ is used to keep track of everyday business activities.
Transaction Processing System
All of the following are advantages of using a database except _____.
"Maintaining Data Integrity"
"Flexible Use of Data"
All of the following are part of the process of data staging for a data warehouse except _____.
An individual trained in the design and building of databases is called a database _____
Application software specifically designed to interact with the user to capture and analyze data
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
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 _____.
Compares the values of data in two or more fields to see if these values are reasonable
Criteria used to ensure that data entered into the database is correct (or at least reasonable) and complete
Databases that contain not only data, but also methods of processing or manipulating that data are called ____________ databases.
Designed to assist employees in accomplishing their day-to-day tasks and to improve communications
Office Support System
If all students at a college were from New Jersey, the "State" field could be set to a _____.
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
Large databases accessed by many users, such as those used by ebay, are usually designed as _____ databases.
SQL is a(n) __________.
"Type of database architecture"
"Application Programming Language"
"Relational database program"
The process of eliminating data redundancy by ensuring that tables in a database pertain to a single topic is called _____.
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
Which of the following applications is considered an office support system?
"A company's expert system"
"An ATM system"
Which of the following is a database management system?
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
Which of the following is not a category of information systems?
"Management Information System"
"Office Support System"
"Transaction Processing System"
Which of the following is not a data-mining technique?
Which of the following is not a possible primary key?
"Social Security Number"
"Driver's License Number"
"Student ID Number"
Which of the following is NOT an example of a common data type?