Cosc packet 4 – Flashcards
28 test answers
Unlock all answers in this set
Unlock answers 28question
(In a database) this is synonymous with a category of information
answer
Field
Unlock the answer
question
(In a database) a group of related records is referred to as a ------
answer
Table
Unlock the answer
question
(In a Microsoft Access) something like the Gettysburg Address would be stored in a _______ Field
answer
Long Text
Unlock the answer
question
You can set a_____ which is automatically displayed in a field unless the user enters something different.
answer
Default Value
Unlock the answer
question
This can not a likely primary key
answer
Date of Birth
Unlock the answer
question
This is used to ensure that data is organized most efficiently
answer
Normalization
Unlock the answer
question
Databases are the most frequently used electronic databases
answer
Relational
Unlock the answer
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
Unlock the answer
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
Unlock the answer
question
Nontraditional data such as audio clips, video clips, pictures, and very large documents are called_____
answer
Unstructured data
Unlock the answer
question
Data in a multidimensional database is organized in a ______
answer
Cube format
Unlock the answer
question
This check would be used to restrict the fines for speeding violations from $50 to $250
answer
Range
Unlock the answer
question
This check determines whether a required field such as LastName was filled in.
answer
Completeness
Unlock the answer
question
This check compares the values of data in two or more fields to see whether those values are reasonable
answer
Consistancy
Unlock the answer
question
You can use this to temporarily display records of residents of the city of Boston.
answer
Filter
Unlock the answer
question
This is a way of retrieving information from one or more tables that defines a particular subset of data
answer
Query
Unlock the answer
question
This displays a subset of data from a table based on the specified criteria
answer
Select Query
Unlock the answer
question
SQL uses this to extract records from a database by using English-like expressions that have variables and operations
answer
Relational Algebra
Unlock the answer
question
This involves putting data into an electronic file in a format that another application can recognize
answer
Exporting
Unlock the answer
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
Unlock the answer
question
Data staging consists of all of the following steps, Except
answer
Mining the data
Unlock the answer
question
This is designed to improve communications and help employees complete their routine tasks
answer
OSS (Office Support System)
Unlock the answer
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
Unlock the answer
question
MIS () provide reports called___, which show conditions that are unusual or need attention from users of the system.
answer
Exception reports
Unlock the answer
