MENU
Educational Resources
Exam Papers
Form 1 Videos
Form 2 Videos
Form 3 Videos
Form 4 Videos
Grade 4 Videos
Grade 5 Videos
Grade 6 Videos
Grade 7 Videos
Class 8 Videos
Form 1 Exams
Form 2 Exams
Form 3 Exams
Form 4 Exams
KCSE Videos
Class 8 Exams
Grade 5 Exams
Grade 4 Exams
Grade 3 Exams
Grade 2 Exams
Grade 1 Exams
Online Tests
Online Tuition
Sign In
Join
Get access to thousands of educational resources
Get premium membership
and access revision papers with marking schemes, video lessons and live classes.
OR
Processing. Please wait.
Form 2 Computer Studies Questions and Answers on Databases
State two ways of enforcing referential integrity in a database.
(0m 0s)
688 Views
SHARE
|
« Previous
Next »
1.
Differentiate between a foreign key and primary in a relational database.
2.
Mention two advantages of entering data into a database using a form.
3.
Define the following terms as used in database: a)Record b)File c)Database
4.
State one function of each of these objects in a database. a)Table b)Query c)Forms d)Reports
5.
List three types of relationships that can be used to link tables in a database.
6.
Define the term database management system (DBMS).
7.
List three database management system objects.
8.
Explain these database models: a)Relational b)Hierarchical
9.
Distinguish between relational database and flat file model.
10.
Define the term dynaset as used in database
11.
List four features of database software
12.
Differentiate between database and database management software
13.
Explain these database models: a)Network model b)Flat file
14.
The figure below shows an example of a database model: Name the type of database model represented by the figure.
15.
State one disadvantages of flat file database model
16.
Give three functions of a database management system.
17.
State three ways in which a primary key field can be used in a database.
18.
Define the term normalisation as used in a database.
19.
Differentiate between an index and a primary key.
20.
Mention three objectives of normalisation.
21.
Differentiate between a report and a form.
22.
List two types of form layout available in a database form wizard dialog box.
23.
List any six general field properties that can be set on a field in a table.
24.
Name any two examples of a database package.
25.
Differentiate between the term entity and attribute in a database.
26.
State two qualities of a primary key field.
27.
A form two student wishes to create a field named ADM. No in a table. This field will be used to store admission numbers of students in a class. Outline the steps to follow to achieve this.
28.
Define the term control as used in database forms.
29.
Explain three categories of database controls.
30.
State three disadvantages of traditional file management system over electronic file management system.
31.
Name four types of Action Queries.
32.
Give the function of each of the following queries. -Make table query -Delete query -Append query -Update query;
33.
Differentiate between an action query and a select query.
34.
Give three ways of opening Ms-Access program.
35.
Differentiate between single and double types of integer field size as used in database.
36.
Expand the term OLE objects as used in database.
37.
Give the function of Object Linking and Embedding (OLE) object data type.
38.
State two ways of enforcing referential integrity in a database.
39.
State three views in a Microsoft database window.
×
Share Content Via:
Facebook
Twitter
WhatsApp
Close
Get premium membership