Database Systems Final Exam
Data is the result of interpreting facts to reveal meaning. (T False, Data is the result of processing RAW DATA to facts to reveal their meaning
or F)
Unstructured data is data that exists in the format in which True.
it was collected (raw state). While Structured data is the Correct. Unstructured data is in its raw state while structured data is formatted to
result of formatting unstructured data to enable storage, enable storage and generation of meaningful information.
use, and generation of information. (T or F)
Data redundancy exists when data is duplicated and True:
stored unnecessarily at different places. Data redundancy exists when data is duplicated and stored unnecessarily at
different places.
One of the advantages of a database system over FALSE:
previous data management approaches is reduced costs. Correct. Database systems require sophisticated hardware and software and highly
(T or F) skilled personnel. This increases costs.
The term database system refers to an organization of True:
components that define and regulate the collection, Correct. Database system refers to an organization of components that define and
storage, management, and use of data within a database regulate the collection, storage, management, and use of data within a database
environment. environment.
How would you define data that is verifiable? C
Correct. Data is said to be verifiable if the data always yields consistent results
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.
One of the advantages of database systems is that ___ C.
Correct. One of the advantages of database systems is that Database systems
a. Database systems maximizes data inconsistency enable the data in the database to be shared among multiple applications or users.
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.
A good Database Management System (DBMS) will False:
perform well even with a badly designed database. (T or F) Correct. A well designed database is essential for a DBMS to perform well.
Thorough database planning and design is important to True:
ensure that data is properly used to give the organization Correct. Thorough database planning and design is important for a DBMS to
the most benefit. (T or F) perform well and to give the organization the most benefit.
Which of the answers below is one of the challenges of d. Vendor dependende:
managing a database system?
Vendor dependence is one of the challenges of managing a database system.
a. Infrequent Upgrade
b. Management Simplicity
c. Reduced costs
d Vendor Dependence
, Database Systems Final Exam
Within the database environment, a data model represents b. a clearly defined area within a real-world environment that will be systematically
data structures and their attributes, relations, constraints, addressed
and transformations with the purpose of supporting a
specific problem domain. Define "problem domain" in the Correct. A problem domain is a real-world set of circumstances, objects or events
context of data models. that serve as data points and represent the boundaries and scope of the problem(s)
to be addressed.
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
Business rules use simple language to establish definitions D. 1:M
of entities, attributes, relationships, and constraints. For
instance, a business rule establishing that entities can Correct. 1:M signifies a one-to-many relationship, as described in the example. This
have multiple attributes, and that each available attribute relationship can also be described according to database convention as
may be associated with only one entity, might be stated as EMPLOYEE is assigned DEVICES.
"An employee may be assigned multiple devices" and
"Each device may be assigned to only one employee".
Classify the relationship between EMPLOYEES and
DEVICES in this example using shorthand notation.
A. 1:1
B. ..
C. M:N
D. 1:M
Business rules that are properly written will define entities, C. Constraints
attributes, relationships, and _____.
Correct. Constraints are intentional restrictions to the data, and allow us to ensure
A. Fields the data is accurate and reliable. Specifically, constraints enforce rules that were
B. Objects defined at the time of model creation as the data is manipulated.
C. Constraints
D. Classes
In the context of relational databases, a column in a B. Attributes
relational table is associated with the _____(s) of a real-
world person, place, thing, or event. Correct. Attributes are the characteristics of an entity, usually represented as a
value. In the context of relational databases, the columns in a relational table
A. Entity correspond to attributes of an entity.
B. Atrributes
C. Relationships
D. Constraints
A(n) _____ is bidirectional. c. Relationship:
a. Attribute Correct. A relationship between entities flows in both directions.
b. entity
c. relationship
d. constraint
Which of the following is true of business rules? C. They can serve as a communication tool between the users and designers.
a. They allow the designer to set company policies with
regard to data. Correct! They can serve as a communication tool between the users and designers.
b. They allow the designer to develop business processes.
c. They can serve as a communication tool between the
users and designers.
d. They provide a framework for the company's self-
actualization.
Data is the result of interpreting facts to reveal meaning. (T False, Data is the result of processing RAW DATA to facts to reveal their meaning
or F)
Unstructured data is data that exists in the format in which True.
it was collected (raw state). While Structured data is the Correct. Unstructured data is in its raw state while structured data is formatted to
result of formatting unstructured data to enable storage, enable storage and generation of meaningful information.
use, and generation of information. (T or F)
Data redundancy exists when data is duplicated and True:
stored unnecessarily at different places. Data redundancy exists when data is duplicated and stored unnecessarily at
different places.
One of the advantages of a database system over FALSE:
previous data management approaches is reduced costs. Correct. Database systems require sophisticated hardware and software and highly
(T or F) skilled personnel. This increases costs.
The term database system refers to an organization of True:
components that define and regulate the collection, Correct. Database system refers to an organization of components that define and
storage, management, and use of data within a database regulate the collection, storage, management, and use of data within a database
environment. environment.
How would you define data that is verifiable? C
Correct. Data is said to be verifiable if the data always yields consistent results
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.
One of the advantages of database systems is that ___ C.
Correct. One of the advantages of database systems is that Database systems
a. Database systems maximizes data inconsistency enable the data in the database to be shared among multiple applications or users.
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.
A good Database Management System (DBMS) will False:
perform well even with a badly designed database. (T or F) Correct. A well designed database is essential for a DBMS to perform well.
Thorough database planning and design is important to True:
ensure that data is properly used to give the organization Correct. Thorough database planning and design is important for a DBMS to
the most benefit. (T or F) perform well and to give the organization the most benefit.
Which of the answers below is one of the challenges of d. Vendor dependende:
managing a database system?
Vendor dependence is one of the challenges of managing a database system.
a. Infrequent Upgrade
b. Management Simplicity
c. Reduced costs
d Vendor Dependence
, Database Systems Final Exam
Within the database environment, a data model represents b. a clearly defined area within a real-world environment that will be systematically
data structures and their attributes, relations, constraints, addressed
and transformations with the purpose of supporting a
specific problem domain. Define "problem domain" in the Correct. A problem domain is a real-world set of circumstances, objects or events
context of data models. that serve as data points and represent the boundaries and scope of the problem(s)
to be addressed.
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
Business rules use simple language to establish definitions D. 1:M
of entities, attributes, relationships, and constraints. For
instance, a business rule establishing that entities can Correct. 1:M signifies a one-to-many relationship, as described in the example. This
have multiple attributes, and that each available attribute relationship can also be described according to database convention as
may be associated with only one entity, might be stated as EMPLOYEE is assigned DEVICES.
"An employee may be assigned multiple devices" and
"Each device may be assigned to only one employee".
Classify the relationship between EMPLOYEES and
DEVICES in this example using shorthand notation.
A. 1:1
B. ..
C. M:N
D. 1:M
Business rules that are properly written will define entities, C. Constraints
attributes, relationships, and _____.
Correct. Constraints are intentional restrictions to the data, and allow us to ensure
A. Fields the data is accurate and reliable. Specifically, constraints enforce rules that were
B. Objects defined at the time of model creation as the data is manipulated.
C. Constraints
D. Classes
In the context of relational databases, a column in a B. Attributes
relational table is associated with the _____(s) of a real-
world person, place, thing, or event. Correct. Attributes are the characteristics of an entity, usually represented as a
value. In the context of relational databases, the columns in a relational table
A. Entity correspond to attributes of an entity.
B. Atrributes
C. Relationships
D. Constraints
A(n) _____ is bidirectional. c. Relationship:
a. Attribute Correct. A relationship between entities flows in both directions.
b. entity
c. relationship
d. constraint
Which of the following is true of business rules? C. They can serve as a communication tool between the users and designers.
a. They allow the designer to set company policies with
regard to data. Correct! They can serve as a communication tool between the users and designers.
b. They allow the designer to develop business processes.
c. They can serve as a communication tool between the
users and designers.
d. They provide a framework for the company's self-
actualization.
