DATABASE THEORY MIDTERM STUDY GUIDE | FROM
QUESTION TO PERFECTION| STUDY WITH CONFIDENCE!
Course Code:
Course Title:
Programme:
Academic Year: 2026/2027
Duration: 2 Hours.
Total Marks: 70%.
Candidate Instructions:
1) Write your Registration Number on every answer booklet used.
2) Answer ALL questions in Section A and ANY TWO (2) questions in Section B.
3) Read each question carefully before answering.
4) Begin each question on a new page.
5) The marks for each question are indicated in brackets.
6) This paper consists of several printed pages, including this page.
7) Ensure your copy is complete before the examination begins.
8) Unauthorized materials and communication with other candidates are not permitted.
Turn Over.
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
, Which advantage of database processing makes it easier to make a change in the database
structure? Answer: data independence
An advantage of using the database approach to processing is that it facilitates consistency.
(T/F) Answer: True
If a user is authorized to access database data, the user will always be able to make changes to
the data.
(T/F) Answer: False
What should an administrator use to more easily assign database access permissions to multiple
users? Answer: groups
Which of the following statements is correct?
a. In a nondatabase, file-oriented environment, data is often partitioned into several disjointed
systems with each system having its own collection of files.
b. User data cannot be combined and shared among authorized users.
c. Database users should not have access to the same information.
d. Controlling redundancy is easier with the nondatabase approach. Answer: In a nondatabase,
file-oriented enviornment, data is often partitions into several disjointed systems with each
system having its own collection of files.
A database file requires a large amount of disk space and internal ________________. Answer:
memory
Which type of rule ensures that changes made to the database do not result in a loss of data
consistency? Answer: integrity constraint
How does the use of a database facilitate data consistency? Answer: by controlling redundancy
Explain why it is better to control redundancy rather than eliminate it. Answer: - eliminating
redundancy is the ideal, but it is not always possible
- Sometimes you might choose to introduce a limited amount of redundancy into a database,
long as you keep the redundancy under tight control
- it is better to say that you control redundancy rather than eliminate it, because it is not possible
with current data base models
____________________ integrity is a relational database concept stating that table relationships
must be consistent and follow integrity constraints. Answer: Referential
A good DMBS provides data ___________, which is a property that lets you change Answer:
independence
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
QUESTION TO PERFECTION| STUDY WITH CONFIDENCE!
Course Code:
Course Title:
Programme:
Academic Year: 2026/2027
Duration: 2 Hours.
Total Marks: 70%.
Candidate Instructions:
1) Write your Registration Number on every answer booklet used.
2) Answer ALL questions in Section A and ANY TWO (2) questions in Section B.
3) Read each question carefully before answering.
4) Begin each question on a new page.
5) The marks for each question are indicated in brackets.
6) This paper consists of several printed pages, including this page.
7) Ensure your copy is complete before the examination begins.
8) Unauthorized materials and communication with other candidates are not permitted.
Turn Over.
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
, Which advantage of database processing makes it easier to make a change in the database
structure? Answer: data independence
An advantage of using the database approach to processing is that it facilitates consistency.
(T/F) Answer: True
If a user is authorized to access database data, the user will always be able to make changes to
the data.
(T/F) Answer: False
What should an administrator use to more easily assign database access permissions to multiple
users? Answer: groups
Which of the following statements is correct?
a. In a nondatabase, file-oriented environment, data is often partitioned into several disjointed
systems with each system having its own collection of files.
b. User data cannot be combined and shared among authorized users.
c. Database users should not have access to the same information.
d. Controlling redundancy is easier with the nondatabase approach. Answer: In a nondatabase,
file-oriented enviornment, data is often partitions into several disjointed systems with each
system having its own collection of files.
A database file requires a large amount of disk space and internal ________________. Answer:
memory
Which type of rule ensures that changes made to the database do not result in a loss of data
consistency? Answer: integrity constraint
How does the use of a database facilitate data consistency? Answer: by controlling redundancy
Explain why it is better to control redundancy rather than eliminate it. Answer: - eliminating
redundancy is the ideal, but it is not always possible
- Sometimes you might choose to introduce a limited amount of redundancy into a database,
long as you keep the redundancy under tight control
- it is better to say that you control redundancy rather than eliminate it, because it is not possible
with current data base models
____________________ integrity is a relational database concept stating that table relationships
must be consistent and follow integrity constraints. Answer: Referential
A good DMBS provides data ___________, which is a property that lets you change Answer:
independence
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
