BANA 2372 HOLLANDER FINAL EXAM REVIEW
STUDY SHEET 2026 ACCURATE RESPONSES
FULL SOLUTION
◉ ___ provide a description of the data characteristics and the set of
relationships that link the data found within the database. Answer:
Metadata
◉ ___ serve as the intermediary between the user and the database.
Answer: DBMSs
◉ Which of the following is information? Answer: The average time
of driving from Corvallis to Portland is 1 hour and 45 minutes
◉ Which of the following is NOT a problem of a file system? Answer:
Lack of application programs
◉ Which of the following is NOT a function of DBMS? Answer:
Generate information from data
◉ Which of the following is NOT an issue of data quality? Answer:
Security
,◉ Which of the following is information? Answer: We issued 3,512
invoices in the last 3 months
◉ One disadvantage of the DBMS is that it increases the risk of data
security breaches. Answer: False
◉ What are the problems associated with file systems? How do they
challenge the types of information that can be created from the data
as well as the accuracy of the information? Answer: File systems
have problems such as lengthy development times, difficulty in
getting quick answers, a complex system administration, the lack of
security and limited data sharing, as well as extensive programming.
Lengthy development times challenge the types of information that
can be created from the data as well as the accuracy of the
information due to any simple task needing to be completed
requires extensive amounts of time, especially if the file system is
older and therefore slower overall as well. The difficulty in getting
quick answers also requires extensive time in which the accuracy of
the information may not be relevant once it is ready in comparison
to when it needed to be. A complex system administration presents
challenges such as increasing the numbers of files and information,
which then creates issues such as adding, sending, modifying, or
deleting such files. This problem also relates to increased time
requirements. The lack of security and limited data sharing creates
challenges in such that there is no security and all information can
be tampered with. Extensive programming issues relates to all
challenges listed above.
, ◉ Which of the following is metadata? Answer: IP addresses
consists of 4 numbers between 0 and 255 and are usually displayed
with a period between each number as in 10.222.255.1
◉ Discuss any three functions performed by the DBMS that
guarantee the integrity and consistency of the data in the database.
Answer: Data Storage Management, Security Management, and
Backup and Recovery Management all relate to the integrity and
consistency of the data in the database. This is because without
performance tuning in which allows for efficient performance,
storage and access speed, the data will not process in the time it is
needed. Security management is needed to keep the integrity of the
data otherwise it may be tampered with and lose its integrity and
consistency from outside sources. Lastly, recovery management is
needed in case of a database failure or crash in which all data could
be lost if it were unable to be backed up and recovered. This would
overall diminish the consistency and integrity of the data in case
only half of the data were to be saved and the rest to be lost.
◉ Data and information are essentially the same thing. Answer:
False
◉ Metadata describe the data characteristics and the set of
relationships that links the data found within the database. Answer:
True
STUDY SHEET 2026 ACCURATE RESPONSES
FULL SOLUTION
◉ ___ provide a description of the data characteristics and the set of
relationships that link the data found within the database. Answer:
Metadata
◉ ___ serve as the intermediary between the user and the database.
Answer: DBMSs
◉ Which of the following is information? Answer: The average time
of driving from Corvallis to Portland is 1 hour and 45 minutes
◉ Which of the following is NOT a problem of a file system? Answer:
Lack of application programs
◉ Which of the following is NOT a function of DBMS? Answer:
Generate information from data
◉ Which of the following is NOT an issue of data quality? Answer:
Security
,◉ Which of the following is information? Answer: We issued 3,512
invoices in the last 3 months
◉ One disadvantage of the DBMS is that it increases the risk of data
security breaches. Answer: False
◉ What are the problems associated with file systems? How do they
challenge the types of information that can be created from the data
as well as the accuracy of the information? Answer: File systems
have problems such as lengthy development times, difficulty in
getting quick answers, a complex system administration, the lack of
security and limited data sharing, as well as extensive programming.
Lengthy development times challenge the types of information that
can be created from the data as well as the accuracy of the
information due to any simple task needing to be completed
requires extensive amounts of time, especially if the file system is
older and therefore slower overall as well. The difficulty in getting
quick answers also requires extensive time in which the accuracy of
the information may not be relevant once it is ready in comparison
to when it needed to be. A complex system administration presents
challenges such as increasing the numbers of files and information,
which then creates issues such as adding, sending, modifying, or
deleting such files. This problem also relates to increased time
requirements. The lack of security and limited data sharing creates
challenges in such that there is no security and all information can
be tampered with. Extensive programming issues relates to all
challenges listed above.
, ◉ Which of the following is metadata? Answer: IP addresses
consists of 4 numbers between 0 and 255 and are usually displayed
with a period between each number as in 10.222.255.1
◉ Discuss any three functions performed by the DBMS that
guarantee the integrity and consistency of the data in the database.
Answer: Data Storage Management, Security Management, and
Backup and Recovery Management all relate to the integrity and
consistency of the data in the database. This is because without
performance tuning in which allows for efficient performance,
storage and access speed, the data will not process in the time it is
needed. Security management is needed to keep the integrity of the
data otherwise it may be tampered with and lose its integrity and
consistency from outside sources. Lastly, recovery management is
needed in case of a database failure or crash in which all data could
be lost if it were unable to be backed up and recovered. This would
overall diminish the consistency and integrity of the data in case
only half of the data were to be saved and the rest to be lost.
◉ Data and information are essentially the same thing. Answer:
False
◉ Metadata describe the data characteristics and the set of
relationships that links the data found within the database. Answer:
True
