Cosc packet 4 – Flashcards
Unlock all answers in this set
Unlock answersquestion
A group of related data can be stored, sorted, organized, and queried
answer
Database
question
if a school keeps two lists, one for student registration and one for student financial information, both containing name and address info. This is an example of---
answer
Data Redundancy
question
This ensures that the data contained in a database is accurate and reliable
answer
Data Integrity
question
This helps to ensure data integrity be maintaining information in only one place
answer
Data Centralization
question
(In a database) this is synonymous with a category of information
answer
Field
question
(In a database) a group of related records is referred to as a ------
answer
Table
question
(In a Microsoft Access) something like the Gettysburg Address would be stored in a _______ Field
answer
Long Text
question
You can set a_____ which is automatically displayed in a field unless the user enters something different.
answer
Default Value
question
This can not a likely primary key
answer
Date of Birth
question
This is used to ensure that data is organized most efficiently
answer
Normalization
question
Databases are the most frequently used electronic databases
answer
Relational
question
This indicates that for each record in a table, there is only a single corresponding record in a related table
answer
One-to-one Relationship
question
This means that for each value in the foreign key of one table, here is a corresponding value in the primary key of another table
answer
Record integrity
question
Nontraditional data such as audio clips, video clips, pictures, and very large documents are called_____
answer
Unstructured data
question
Data in a multidimensional database is organized in a ______
answer
Cube format
question
This check would be used to restrict the fines for speeding violations from $50 to $250
answer
Range
question
This check determines whether a required field such as LastName was filled in.
answer
Completeness
question
This check compares the values of data in two or more fields to see whether those values are reasonable
answer
Consistancy
question
You can use this to temporarily display records of residents of the city of Boston.
answer
Filter
question
This is a way of retrieving information from one or more tables that defines a particular subset of data
answer
Query
question
This displays a subset of data from a table based on the specified criteria
answer
Select Query
question
SQL uses this to extract records from a database by using English-like expressions that have variables and operations
answer
Relational Algebra
question
This involves putting data into an electronic file in a format that another application can recognize
answer
Exporting
question
This data is a large scale electronic repository of data that contains and organizes all of an organization's data in one place.
answer
Warehouse
question
Data staging consists of all of the following steps, Except
answer
Mining the data
question
This is designed to improve communications and help employees complete their routine tasks
answer
OSS (Office Support System)
question
( in a transaction- processing system) If the TPS Data base can be queried and updated while the transaction is taking place, this is called____
answer
Real time processing
question
MIS () provide reports called___, which show conditions that are unusual or need attention from users of the system.
answer
Exception reports
