COMPUTER SCIENCE 101 TEST 3
QUESTIONS WITH CORRECT
ANSWERS!!
Database - ANSWERis a logically organized collection of related data
designed and built for a specific purpose.
Bit - ANSWER0 or 1
Character (byte) - ANSWERa letter number or special character made of bits
Field - ANSWERunit of data containing 1 or more characters
Hierarchy - ANSWERThe way data is stored
Key field - ANSWERis a field (or fields) in a record that
holds unique data that identifies that record from all the other
records in the table and in the database
Database Management System - ANSWERSoftware that enables users to store,
modify, and extract information
from a database.
Benefits of a Database Management System - ANSWER• Reduced data redundancy
(redundant data is stored in multiple places, which
causes problems keeping all the copies current)
• Speed: modern DBMSs are much faster than manual data-organization systems
and faster than older computer-based database arrangements
• Improved data integrity: the data is accurate, consistent, and up to date
• Timeliness: the speed and efficiency of DBMSs generally ensure that data can be
supplied in a timely fashion (when people need it)
• Ease of sharing: the data in a database belongs to and is shared, usually over a
network, by an entire organization. The data is independent of the programs that
process the data, and it is easy for nontechnical users to access it.
Database Components - ANSWER• Data Dictionary
• DBMS Utilities
• Report Generator
Data Dictionary - ANSWERRepository that stores the data definitions and
descriptions of the
structure of the data and the database
, DBMS Utilities - ANSWER• Programs that allow you to maintain the database by
creating, editing,
deleting data, records, and files
• Also include automated backup and recovery
Report Generator - ANSWER• Program for producing on-screen or printed readable
documents from
all or part of a database
Database Administrator - ANSWERCoordinates all related activities and needs for
an
organization's database
Database Administrator ensures that it will have.. - ANSWERRecoverability
• Integrity
• Security
• Availability
• Reliability
• Performance
Relational Database - ANSWERGrew out of the hierarchical and network database
models
• Relates or connects data in different files through the use of primary
keys, or common data elements
• Data stored in tables (relations, or files) of rows (tuples, or records)
and columns (attributes, or fields)
• More flexible than previous models; built with SQL
• Users don't need to know data structure to use the database
• Users employ SQL (structured query language) to create, modify,
maintain, and query the database (query by example)
• Some relational database allow the use of natural spoken language to
make queries
Data Mining - ANSWERThe computer-assisted process of sifting through and
analyzing vast amounts of data to extract hidden patterns and meaning and to
discover new knowledge.
Data Warehouse - ANSWERis a special database of cleaned-up data and metadata.
Big Data - ANSWERSo large and complex that it cannot be processed using
conventional methods, such as ordinary database
management software.
Implications of Big Data - ANSWER1.Big Data derives from a bundle of old & new
data sources
Including web pages, sensor signals, GPS location data from smartphones,
browsing habits, genetic information, and surveillance videos.
2.Big data could lead to a revolution in measurement
The volume and variety of data, along with the powerful smart software, could
revolutionize how things are measured
QUESTIONS WITH CORRECT
ANSWERS!!
Database - ANSWERis a logically organized collection of related data
designed and built for a specific purpose.
Bit - ANSWER0 or 1
Character (byte) - ANSWERa letter number or special character made of bits
Field - ANSWERunit of data containing 1 or more characters
Hierarchy - ANSWERThe way data is stored
Key field - ANSWERis a field (or fields) in a record that
holds unique data that identifies that record from all the other
records in the table and in the database
Database Management System - ANSWERSoftware that enables users to store,
modify, and extract information
from a database.
Benefits of a Database Management System - ANSWER• Reduced data redundancy
(redundant data is stored in multiple places, which
causes problems keeping all the copies current)
• Speed: modern DBMSs are much faster than manual data-organization systems
and faster than older computer-based database arrangements
• Improved data integrity: the data is accurate, consistent, and up to date
• Timeliness: the speed and efficiency of DBMSs generally ensure that data can be
supplied in a timely fashion (when people need it)
• Ease of sharing: the data in a database belongs to and is shared, usually over a
network, by an entire organization. The data is independent of the programs that
process the data, and it is easy for nontechnical users to access it.
Database Components - ANSWER• Data Dictionary
• DBMS Utilities
• Report Generator
Data Dictionary - ANSWERRepository that stores the data definitions and
descriptions of the
structure of the data and the database
, DBMS Utilities - ANSWER• Programs that allow you to maintain the database by
creating, editing,
deleting data, records, and files
• Also include automated backup and recovery
Report Generator - ANSWER• Program for producing on-screen or printed readable
documents from
all or part of a database
Database Administrator - ANSWERCoordinates all related activities and needs for
an
organization's database
Database Administrator ensures that it will have.. - ANSWERRecoverability
• Integrity
• Security
• Availability
• Reliability
• Performance
Relational Database - ANSWERGrew out of the hierarchical and network database
models
• Relates or connects data in different files through the use of primary
keys, or common data elements
• Data stored in tables (relations, or files) of rows (tuples, or records)
and columns (attributes, or fields)
• More flexible than previous models; built with SQL
• Users don't need to know data structure to use the database
• Users employ SQL (structured query language) to create, modify,
maintain, and query the database (query by example)
• Some relational database allow the use of natural spoken language to
make queries
Data Mining - ANSWERThe computer-assisted process of sifting through and
analyzing vast amounts of data to extract hidden patterns and meaning and to
discover new knowledge.
Data Warehouse - ANSWERis a special database of cleaned-up data and metadata.
Big Data - ANSWERSo large and complex that it cannot be processed using
conventional methods, such as ordinary database
management software.
Implications of Big Data - ANSWER1.Big Data derives from a bundle of old & new
data sources
Including web pages, sensor signals, GPS location data from smartphones,
browsing habits, genetic information, and surveillance videos.
2.Big data could lead to a revolution in measurement
The volume and variety of data, along with the powerful smart software, could
revolutionize how things are measured
