INSY 3304 Quiz 1 QUESTIONS AND
ANSWERS 100% CORRECT
Data - ANSWER-Raw facts, or facts that have not yet been processed to reveal their
meaning to the end user.
Field - ANSWER-a character or group of characters(alphabetic or numeric) that has a
specific meaning. A field is used to define and store data.
Record - ANSWER-A logically connected set of one or more fields that describes a
person, place ,or thing.
File - ANSWER-A collection of related records. For example, a file might contain data
about the students currently enrolled at Gigantic University.
What is data redundancy, and which characteristics of a file system can lead to it? -
ANSWER-Data redundancy refers to the duplicate data that my exist in the database.
Some characteristics include duplicate data, poor data integrity, and data that is isolated
and separated.
What are some basic database functions that a spreadsheet cannot perform? -
ANSWER-support for self-documentation through metadata.
enforcement of data types or domains to ensure consistency of data within a column.
defined relationships among tables.
Constraints to ensure consistency of data across related tables.
Explain why the cost of ownership may be lower with a cloud database than with a
traditional, company database. - ANSWER-Cloud databases are on the Internet instead
of the company's infrastructure. This reduces costs because the company does not
need to purchase the hardware and software necessary to house the database and
support the necessary levels of system performance.
What is a DBMS, and what are its functions? - ANSWER-A DBMS is a collection of
programs that manages the database structure and controls access to the data stored
in the database.
Some functions include data collection, transaction control, security, backup and
recovery, integrity, multi-user access, and database access language.
What are the main components of a database system? - ANSWER-Hardware, Software,
People, Procedures, Data
ANSWERS 100% CORRECT
Data - ANSWER-Raw facts, or facts that have not yet been processed to reveal their
meaning to the end user.
Field - ANSWER-a character or group of characters(alphabetic or numeric) that has a
specific meaning. A field is used to define and store data.
Record - ANSWER-A logically connected set of one or more fields that describes a
person, place ,or thing.
File - ANSWER-A collection of related records. For example, a file might contain data
about the students currently enrolled at Gigantic University.
What is data redundancy, and which characteristics of a file system can lead to it? -
ANSWER-Data redundancy refers to the duplicate data that my exist in the database.
Some characteristics include duplicate data, poor data integrity, and data that is isolated
and separated.
What are some basic database functions that a spreadsheet cannot perform? -
ANSWER-support for self-documentation through metadata.
enforcement of data types or domains to ensure consistency of data within a column.
defined relationships among tables.
Constraints to ensure consistency of data across related tables.
Explain why the cost of ownership may be lower with a cloud database than with a
traditional, company database. - ANSWER-Cloud databases are on the Internet instead
of the company's infrastructure. This reduces costs because the company does not
need to purchase the hardware and software necessary to house the database and
support the necessary levels of system performance.
What is a DBMS, and what are its functions? - ANSWER-A DBMS is a collection of
programs that manages the database structure and controls access to the data stored
in the database.
Some functions include data collection, transaction control, security, backup and
recovery, integrity, multi-user access, and database access language.
What are the main components of a database system? - ANSWER-Hardware, Software,
People, Procedures, Data
