Database Design & Management Exam 1
Review
False - answer Conversion from a manual file system to a database system is simply a
matter of importing the data into the DBMS.
True - answer The most important advantage of the DBMS is its ability to let the
user/designer operate in a human logical environment.
True - answer Business rules help you determine the relationships that exist between
entities.
False - answer The order of rows and columns is extremely important to the DBMS.
True - answer When constructing database tables it is the metadata that determines the
data type and column properties.
True - answerThe E-R model is a tool which is commonly used to translate different
views of data among managers, users, and programmers to fit into a common
framework.
True - answerAn Entity is a person, place, or thing about which data are to be collected
and stored.
True - answerEntity integrity must exist before you can evaluate referential integrity
between two tables.
True - answerIn a relational table, each table must have an attribute or a combination of
attributes that uniquely identifies each row.
True - answerEach column in a relational table has a specific range of values known as
the attribute domain.
False - answerTo maintain entity integrity, a null value is permitted in the primary key.
True - answerControlled redundancy makes a relational database work.
False - answerA field filled with a null value is the same as a field filled with spaces.
True - answerIn SQL, the difference between DDL and DML is that one defines the data
structure while the other allows users to extract the data.
, True - answerSQL allows the user to specify WHAT must be done, without specifying
HOW it must be done.
Use - answerProper database design requires the database designer to precisely
identify the database's expected......
Dictionary management - answerThe DBMS function that stores the definitions of the
data elements and their relationships, is:......
Restoring the database after a failure - answerDBMS recovery management deals
with......
Distributed - answerA DBMS that supports a database located at several different sites
is called a......DBMS.
Sharing of data in the database
Promoting a clearer view of the big picture
Providing better access to more and better managed data
(All of the above) - answerThe advantages of DBMS include which of the following?
Islands of information - answerOne drawback to a file based system that leads to
potential data anomalies is:
It is the structural blueprint of the database - answerWhat does logical design mean?
Tables - answerThe user perceives the relational database as a collection of......in
which data are stored.
Hierarchical - answerThe......structure is an ordered data arrangement that logically
resembles an upside-down tree.
Parent - answerWithin the hierarchical model, the top layer or root is perceived as
the......of the segment directly beneath it.
Navigational data access environment - answerLike the hierarchical model, the network
model provides a......
Set - answerIn network terminology, a relationship is called a......
Crow's Foot - answerAnother common ER modeling technique used primarily in the
business sector for ERD's is......
Inheritance - answerThe ability of an object to use the attributes and methods of classes
of objects in an Object-Oriented database is called......
Process - answerWhich of the following is NOT a component of the E-R data model?
Review
False - answer Conversion from a manual file system to a database system is simply a
matter of importing the data into the DBMS.
True - answer The most important advantage of the DBMS is its ability to let the
user/designer operate in a human logical environment.
True - answer Business rules help you determine the relationships that exist between
entities.
False - answer The order of rows and columns is extremely important to the DBMS.
True - answer When constructing database tables it is the metadata that determines the
data type and column properties.
True - answerThe E-R model is a tool which is commonly used to translate different
views of data among managers, users, and programmers to fit into a common
framework.
True - answerAn Entity is a person, place, or thing about which data are to be collected
and stored.
True - answerEntity integrity must exist before you can evaluate referential integrity
between two tables.
True - answerIn a relational table, each table must have an attribute or a combination of
attributes that uniquely identifies each row.
True - answerEach column in a relational table has a specific range of values known as
the attribute domain.
False - answerTo maintain entity integrity, a null value is permitted in the primary key.
True - answerControlled redundancy makes a relational database work.
False - answerA field filled with a null value is the same as a field filled with spaces.
True - answerIn SQL, the difference between DDL and DML is that one defines the data
structure while the other allows users to extract the data.
, True - answerSQL allows the user to specify WHAT must be done, without specifying
HOW it must be done.
Use - answerProper database design requires the database designer to precisely
identify the database's expected......
Dictionary management - answerThe DBMS function that stores the definitions of the
data elements and their relationships, is:......
Restoring the database after a failure - answerDBMS recovery management deals
with......
Distributed - answerA DBMS that supports a database located at several different sites
is called a......DBMS.
Sharing of data in the database
Promoting a clearer view of the big picture
Providing better access to more and better managed data
(All of the above) - answerThe advantages of DBMS include which of the following?
Islands of information - answerOne drawback to a file based system that leads to
potential data anomalies is:
It is the structural blueprint of the database - answerWhat does logical design mean?
Tables - answerThe user perceives the relational database as a collection of......in
which data are stored.
Hierarchical - answerThe......structure is an ordered data arrangement that logically
resembles an upside-down tree.
Parent - answerWithin the hierarchical model, the top layer or root is perceived as
the......of the segment directly beneath it.
Navigational data access environment - answerLike the hierarchical model, the network
model provides a......
Set - answerIn network terminology, a relationship is called a......
Crow's Foot - answerAnother common ER modeling technique used primarily in the
business sector for ERD's is......
Inheritance - answerThe ability of an object to use the attributes and methods of classes
of objects in an Object-Oriented database is called......
Process - answerWhich of the following is NOT a component of the E-R data model?
