Database Systems FINAL Exam
Questions and Answers | Professor
Verified Answers | Graded A+
Data is the result of interpreting facts to reveal meaning. (T or F) - CORRECT ANSWERS
False, Data is the result of processing RAW DATA to facts to reveal their meaning
Unstructured data is data that exists in the format in which it was collected (raw state). While Structured
data is the result of formatting unstructured data to enable storage, use, and generation of information.
(T or F) - CORRECT ANSWERS True.
Correct. Unstructured data is in its raw state while structured data is formatted to enable storage and
generation of meaningful information.
Data redundancy exists when data is duplicated and stored unnecessarily at different places. - CORRECT
ANSWERS True:
Data redundancy exists when data is duplicated and stored unnecessarily at different places.
One of the advantages of a database system over previous data management approaches is reduced
costs. (T or F) - CORRECT ANSWERS FALSE:
Correct. Database systems require sophisticated hardware and software and highly skilled personnel.
This increases costs.
The term database system refers to an organization of components that define and regulate the
collection, storage, management, and use of data within a database environment. - CORRECT ANSWERS
True:
Correct. Database system refers to an organization of components that define and regulate the
collection, storage, management, and use of data within a database environment.
How would you define data that is verifiable?
,a. The data is stored in different places within the database.
b. The data cannot be changed or manipulated.
c. The data always yields consistent results.
d. The data is obtained from trusted sources. - CORRECT ANSWERS C
Correct. Data is said to be verifiable if the data always yields consistent results
One of the advantages of database systems is that ___
a. Database systems maximizes data inconsistency
b. Database systems decreases end user productivity
c. Database systems enable the data in the database to be shared among multiple applications or users.
d. Database systems do not integrate many different users' data into a single all-encompassing data
repository. - CORRECT ANSWERS C.
Correct. One of the advantages of database systems is that Database systems enable the data in the
database to be shared among multiple applications or users.
A good Database Management System (DBMS) will perform well even with a badly designed database.
(T or F) - CORRECT ANSWERS False:
Correct. A well designed database is essential for a DBMS to perform well.
, Thorough database planning and design is important to ensure that data is properly used to give the
organization the most benefit. (T or F) - CORRECT ANSWERS True:
Correct. Thorough database planning and design is important for a DBMS to perform well and to give
the organization the most benefit.
Which of the answers below is one of the challenges of managing a database system?
a. Infrequent Upgrade
b. Management Simplicity
c. Reduced costs
d Vendor Dependence - CORRECT ANSWERS d. Vendor dependende:
Vendor dependence is one of the challenges of managing a database system.
Within the database environment, a data model represents data structures and their attributes,
relations, constraints, and transformations with the purpose of supporting a specific problem domain.
Define "problem domain" in the context of data models.
a. a blueprint containing all necessary instructions for building a database that will meet all end-user
requirements
b. a clearly defined area within a real-world environment that will be systematically addressed
c. a relatively simple and usually graphical representation of complex real-world objects or events
d. the process of creating a specific data model for a particular set of real-world data to be addressed -
CORRECT ANSWERS b. a clearly defined area within a real-world environment that will be
systematically addressed
Questions and Answers | Professor
Verified Answers | Graded A+
Data is the result of interpreting facts to reveal meaning. (T or F) - CORRECT ANSWERS
False, Data is the result of processing RAW DATA to facts to reveal their meaning
Unstructured data is data that exists in the format in which it was collected (raw state). While Structured
data is the result of formatting unstructured data to enable storage, use, and generation of information.
(T or F) - CORRECT ANSWERS True.
Correct. Unstructured data is in its raw state while structured data is formatted to enable storage and
generation of meaningful information.
Data redundancy exists when data is duplicated and stored unnecessarily at different places. - CORRECT
ANSWERS True:
Data redundancy exists when data is duplicated and stored unnecessarily at different places.
One of the advantages of a database system over previous data management approaches is reduced
costs. (T or F) - CORRECT ANSWERS FALSE:
Correct. Database systems require sophisticated hardware and software and highly skilled personnel.
This increases costs.
The term database system refers to an organization of components that define and regulate the
collection, storage, management, and use of data within a database environment. - CORRECT ANSWERS
True:
Correct. Database system refers to an organization of components that define and regulate the
collection, storage, management, and use of data within a database environment.
How would you define data that is verifiable?
,a. The data is stored in different places within the database.
b. The data cannot be changed or manipulated.
c. The data always yields consistent results.
d. The data is obtained from trusted sources. - CORRECT ANSWERS C
Correct. Data is said to be verifiable if the data always yields consistent results
One of the advantages of database systems is that ___
a. Database systems maximizes data inconsistency
b. Database systems decreases end user productivity
c. Database systems enable the data in the database to be shared among multiple applications or users.
d. Database systems do not integrate many different users' data into a single all-encompassing data
repository. - CORRECT ANSWERS C.
Correct. One of the advantages of database systems is that Database systems enable the data in the
database to be shared among multiple applications or users.
A good Database Management System (DBMS) will perform well even with a badly designed database.
(T or F) - CORRECT ANSWERS False:
Correct. A well designed database is essential for a DBMS to perform well.
, Thorough database planning and design is important to ensure that data is properly used to give the
organization the most benefit. (T or F) - CORRECT ANSWERS True:
Correct. Thorough database planning and design is important for a DBMS to perform well and to give
the organization the most benefit.
Which of the answers below is one of the challenges of managing a database system?
a. Infrequent Upgrade
b. Management Simplicity
c. Reduced costs
d Vendor Dependence - CORRECT ANSWERS d. Vendor dependende:
Vendor dependence is one of the challenges of managing a database system.
Within the database environment, a data model represents data structures and their attributes,
relations, constraints, and transformations with the purpose of supporting a specific problem domain.
Define "problem domain" in the context of data models.
a. a blueprint containing all necessary instructions for building a database that will meet all end-user
requirements
b. a clearly defined area within a real-world environment that will be systematically addressed
c. a relatively simple and usually graphical representation of complex real-world objects or events
d. the process of creating a specific data model for a particular set of real-world data to be addressed -
CORRECT ANSWERS b. a clearly defined area within a real-world environment that will be
systematically addressed
