CIS 100 Final Exam Practice Qs – Flashcards
Unlock all answers in this set
Unlock answersquestion
A term used to refer to data sets that are too large to process through traditional means
answer
Big Data
question
Provides a detailed description of each field and table in a database
answer
Data Dictionary
question
One of the most commonly used by companies to store information
answer
Relational Database
question
Within the context of a database, this refers ti a collection of related records
answer
File
question
Database that is characterized by data organized into multiple tables that are related by common fields
answer
Data Warehouse
question
Inaccurate input entered into a database resulting in incorrect output
answer
GIGO
question
A common type of flat file database format that stores records as a line of text separated by commas
answer
CSV
question
Query Wizards and ______ automate the process of writing SQL commands in a relational databse
answer
QBE
question
Diagramming technique that is commonly used to illustrate relationships between tables
answer
ERD
question
Graphical representation of the structure of a database
answer
Schema
question
The process of extracting information from a data warehouse or data mart
answer
Mining
question
Overall quality and accuracy of the data
answer
Integrity
question
In the context of a database, which of the following refers to a collection of related fields that describe some object or activity?
answer
Record
question
A primary key is a _____ within a database table that uniquely identifies each record
answer
Field
question
A program that lets computer users create and access a collection of organized data
answer
Database Management System (DBMS)
question
A skilled and trained computer professional who directs all activities related to an organization's database
answer
Database Administrator
