DBMS Basics - Quiz 5
[Answers are given in Green color]
1. A relational database is said to be a group of
____.
a. common fields c.
records
b. field values d. tables
2. One of the advantages of a relational database
model is ____.
a. structural dependence c. easier database design
b. conceptual complexity d. complex database design
3. Using network terminology, a relationship is
called a(n) ____.
a. member c. set
b. owner d.
table
4. The hierarchical database model is based on a
____.
a.
tree structure c.
lack of a child segment
b. lack of a parent segment d. Matrix
5. The hierarchical database model depicts a set
of ____ relationships.
a. M:1 c. 1:M
b. 1:1 d.
M:N
6. The hierarchical database is not very efficient
when handling ____.
a. large amounts of data c. many transactions
b.
few transactions d.
1:M relationships
7. The hierarchical database models ____.
a. have no implementation limitations c. have very strict standards
b.
promote database integrity d.
have a simple navigational system
8. A relational database model ____.
a. does not require substantial hardware and
system software overhead
b. does not promote "islands of
information" problems
c. allows trained people to use a good system
poorly
d.
lets the user operate in a human logical environment
9. The network database models have a ____.
a. navigational system that yields simple design
b. simple system that promotes efficiency
c.
relationship of owner/member that promotes database integrity
d. great deal of structural independence
10. Database models have been developed for ____.
a.
modeling real-world events or conditions
b. depositing data within a single file
c. keeping data within multiple data repositories
d. allowing DBMSs to maintain lose control over
the database activities.
11. The RDBMS ____.
a.
performs functions provided by the hierarchical and network DBMS system
b. does not manage data structures
c. allows the user/designer to ignore the logical
view of the database
d. does not manage the details of physical storage
12. System’s complexity is hidden from the user
and designer in RDBMS. This leads to ____.
a. it does not exhibit data independence
b. it does not exhibit structural independence
c.
easier data management
d. data management is very difficult
13. Database models can be grouped into two
categories: conceptual models and ____
models.
a.
implementation c.
physical
b. logical d.
query
14. Every row/record in the relational table is called
as an entity ____.
a.
instance c.
attribute
b. relationship d.
model
15. Degree of ______ is a way to classify data
models.
a. difficulty c. abstraction
b. knowledge d.
unification