CIS 2010 GSU FINAL || WITH ANSWERS ALL
PASSED!!
Entity correct answers Attributes, columns, fields, keys stores info about a person, place ,
thing , transaction , or event
Database Management System correct answers Deletes, creates, updates, and reads data
Relation Database Model correct answers Stores info in the form of logically related 2-d
labels
Primary Key correct answers Is a field (or group of fields) that uniquely identifies a given
record in a table
Query-by-example correct answers Helps users graphically design the answer to questions
against database
Record correct answers Collection of data elements
Database correct answers Maintains information about various types of objects, inventory,
events (transactions), people (employees) and place (warehouses)
Foreign key correct answers Primary key of one table that appears as an attribute on another
table and acts to provide a logical relationship between 2 tables
Relational database correct answers Increased information security increased information
integrity
Integrity constraints correct answers Rules that help ensure the quality of information
Data Dictionary correct answers Compiles all of the meta data about the data about the data
elements in a data model
Information Redundancy correct answers Is the duplication of data or the storage of some
data in multiple places
Metadata correct answers Provides details about data
Relational Integrity Constraint correct answers Rules that enforce basic and fundamental
information-based constraints
Data models correct answers Data structures that details the real action ship between
graphical elements in pictures or data
Structured Query Language correct answers Tool where users write order of data
Information Integrity correct answers Measure of the quality of information
Dirty Data correct answers Flawed or erroneous data
, Infographics correct answers Presents the results of data analysis
Information scrubbing correct answers Weeding out, fixing or discarding inconsistent,
incorrect or incomplete data
Classification correct answers Assigns records to one of pre-defined set of classes
Estimation correct answers Determines values for an unknown continuous variables behavior
or estimated future value
Affinity Group correct answers Determines what things go where
Clustering correct answers Segments to heterogeneous population of records into a number of
more homogeneous subgroups
Data warehouse correct answers Is a logical collection of information gathered from many
operational databases, that supports business analysis activities and decision making tasks
Data mining correct answers To analyze date and extract info
Machine generated data correct answers Created by a machine without human interaction
Advanced Analytics correct answers Forcasting future trends and producing insights
Distributed computing correct answers Processes and manages algorithms
Web analytics correct answers Analyazes unstructured data to identify consumer behavior
Variety correct answers Different forms of structured and unstructured data
Veracity correct answers The uncertainty of data, including invoices and abnormalities
Volume correct answers The scale of data, enormous values of data generated daily by
machines and networks
Structured data correct answers Data with defined length type, and formats and includes
numbers, data, or strings such as customer address
Data mart correct answers Contains a subset of data of a data warehouse
Data scientist correct answers Extracts data by performing statistical analysis
Text analytics correct answers Analyzes unstructured data from sentences and texts
Cluster analysis correct answers Divides information sets into mutually exclusive groups
Market-based analysis correct answers Analyzes customer behavior
PASSED!!
Entity correct answers Attributes, columns, fields, keys stores info about a person, place ,
thing , transaction , or event
Database Management System correct answers Deletes, creates, updates, and reads data
Relation Database Model correct answers Stores info in the form of logically related 2-d
labels
Primary Key correct answers Is a field (or group of fields) that uniquely identifies a given
record in a table
Query-by-example correct answers Helps users graphically design the answer to questions
against database
Record correct answers Collection of data elements
Database correct answers Maintains information about various types of objects, inventory,
events (transactions), people (employees) and place (warehouses)
Foreign key correct answers Primary key of one table that appears as an attribute on another
table and acts to provide a logical relationship between 2 tables
Relational database correct answers Increased information security increased information
integrity
Integrity constraints correct answers Rules that help ensure the quality of information
Data Dictionary correct answers Compiles all of the meta data about the data about the data
elements in a data model
Information Redundancy correct answers Is the duplication of data or the storage of some
data in multiple places
Metadata correct answers Provides details about data
Relational Integrity Constraint correct answers Rules that enforce basic and fundamental
information-based constraints
Data models correct answers Data structures that details the real action ship between
graphical elements in pictures or data
Structured Query Language correct answers Tool where users write order of data
Information Integrity correct answers Measure of the quality of information
Dirty Data correct answers Flawed or erroneous data
, Infographics correct answers Presents the results of data analysis
Information scrubbing correct answers Weeding out, fixing or discarding inconsistent,
incorrect or incomplete data
Classification correct answers Assigns records to one of pre-defined set of classes
Estimation correct answers Determines values for an unknown continuous variables behavior
or estimated future value
Affinity Group correct answers Determines what things go where
Clustering correct answers Segments to heterogeneous population of records into a number of
more homogeneous subgroups
Data warehouse correct answers Is a logical collection of information gathered from many
operational databases, that supports business analysis activities and decision making tasks
Data mining correct answers To analyze date and extract info
Machine generated data correct answers Created by a machine without human interaction
Advanced Analytics correct answers Forcasting future trends and producing insights
Distributed computing correct answers Processes and manages algorithms
Web analytics correct answers Analyazes unstructured data to identify consumer behavior
Variety correct answers Different forms of structured and unstructured data
Veracity correct answers The uncertainty of data, including invoices and abnormalities
Volume correct answers The scale of data, enormous values of data generated daily by
machines and networks
Structured data correct answers Data with defined length type, and formats and includes
numbers, data, or strings such as customer address
Data mart correct answers Contains a subset of data of a data warehouse
Data scientist correct answers Extracts data by performing statistical analysis
Text analytics correct answers Analyzes unstructured data from sentences and texts
Cluster analysis correct answers Divides information sets into mutually exclusive groups
Market-based analysis correct answers Analyzes customer behavior
