COMP 100 FINAL EXAM QUESTIONS AND VERIFIED
ANSWERS
Which is NOT a component of a database that describes how data is stored? - Answers
- Report
Type of database that is best for organizing unstructured data such as video and audio?
- Answers - Object-oriented
NOT considered a step in data staging? - Answers - inputting data not stored in source
database
gas purchase made with a credit card at the pump would be entered into which type of
database system? - Answers - Transaction-processing system
Database system that uses artificial intelligence? - Answers - knowledge-based system
group of data that can be stored, sorted, organized, queried - Answers - database
school keeps two lists, both containing name and address is an example - Answers -
redundancy
data ___ ensures that the data contained in a database is accurate and reliable -
Answers - integrity
Data ___ helps ensure data integrity by maintaining information in only one place -
Answers - Centralization
in a database, ____ is synonymous with a category of info - Answers - field
group of related fields - Answers - table
Microsoft Access, gettysburg address would be stored in a - Answers - Long text
you can set a ___ which is automatically displayed in a field unless the user enters
something different - Answers - default value
NOT likely a primary key - Answers - date of birth
____ is used to ensure data is organized most efficiently - Answers - normalization
____ databases are the most frequently used electronic databases - Answers -
relational
, ____relationship indicated that for each record in a tale, there is only a single
corresponding record in a related table - Answers - one to one
____ means that for each value in the foreign key of one table there is a corresponding
value in the primary key of another table - Answers - Referential intergrity
Nontraditional data such as audio clips, video clips, pictures and very large documents
are called ____ data - Answers - Unstructured
Data in a multidimensional database is organized in a ____ format - Answers - Cube
A ___ check would be used to restrict the fines for speeding violations from 50 to 250 -
Answers - Range
A(n) ____ check determines whether a required field such as LastName was filled in -
Answers - Completeness
A ___ check compares the values of data in two or more fields to see whether those
valuables are reasonable - Answers - Consistency
You would use a ___ to temporarily display records of residents of the city of Boston -
Answers - Filter
____ is a way of retrieving information from one or more tables that defines a particular
subset of data - Answers - Query
____ displays a subset of data from a table (or tables based on the specified criteria -
Answers - Select Query
SQL uses ____ to extract records from a database by using english-like expressions
that have variables and operations - Answers - Relational algebra
_____ involves putting data into an electronic file in a format that another application
can recognize - Answers - Exporting
Data ___ is a large- scale electronic repository of data that contains and organizes all of
an organization data in one place - Answers - warehouse
Data staging consist of all the following stages EXCEPT - Answers - Mining the data
A(n) ___ is designed to improve communications and help employees complete their
routine tasks - Answers - Office Support System (OSS)
In a transaction-processing system, if the TPS database can be queried and updated
while the transaction is taking place, this is called ___ processing - Answers - Real-time
ANSWERS
Which is NOT a component of a database that describes how data is stored? - Answers
- Report
Type of database that is best for organizing unstructured data such as video and audio?
- Answers - Object-oriented
NOT considered a step in data staging? - Answers - inputting data not stored in source
database
gas purchase made with a credit card at the pump would be entered into which type of
database system? - Answers - Transaction-processing system
Database system that uses artificial intelligence? - Answers - knowledge-based system
group of data that can be stored, sorted, organized, queried - Answers - database
school keeps two lists, both containing name and address is an example - Answers -
redundancy
data ___ ensures that the data contained in a database is accurate and reliable -
Answers - integrity
Data ___ helps ensure data integrity by maintaining information in only one place -
Answers - Centralization
in a database, ____ is synonymous with a category of info - Answers - field
group of related fields - Answers - table
Microsoft Access, gettysburg address would be stored in a - Answers - Long text
you can set a ___ which is automatically displayed in a field unless the user enters
something different - Answers - default value
NOT likely a primary key - Answers - date of birth
____ is used to ensure data is organized most efficiently - Answers - normalization
____ databases are the most frequently used electronic databases - Answers -
relational
, ____relationship indicated that for each record in a tale, there is only a single
corresponding record in a related table - Answers - one to one
____ means that for each value in the foreign key of one table there is a corresponding
value in the primary key of another table - Answers - Referential intergrity
Nontraditional data such as audio clips, video clips, pictures and very large documents
are called ____ data - Answers - Unstructured
Data in a multidimensional database is organized in a ____ format - Answers - Cube
A ___ check would be used to restrict the fines for speeding violations from 50 to 250 -
Answers - Range
A(n) ____ check determines whether a required field such as LastName was filled in -
Answers - Completeness
A ___ check compares the values of data in two or more fields to see whether those
valuables are reasonable - Answers - Consistency
You would use a ___ to temporarily display records of residents of the city of Boston -
Answers - Filter
____ is a way of retrieving information from one or more tables that defines a particular
subset of data - Answers - Query
____ displays a subset of data from a table (or tables based on the specified criteria -
Answers - Select Query
SQL uses ____ to extract records from a database by using english-like expressions
that have variables and operations - Answers - Relational algebra
_____ involves putting data into an electronic file in a format that another application
can recognize - Answers - Exporting
Data ___ is a large- scale electronic repository of data that contains and organizes all of
an organization data in one place - Answers - warehouse
Data staging consist of all the following stages EXCEPT - Answers - Mining the data
A(n) ___ is designed to improve communications and help employees complete their
routine tasks - Answers - Office Support System (OSS)
In a transaction-processing system, if the TPS database can be queried and updated
while the transaction is taking place, this is called ___ processing - Answers - Real-time
