WorksheetsData Access and Management
Total questions: 9
Worksheet time: 5mins
Name
Class
Date
1.
The following are functions of a DBMS except
a)
Creating database
b)
Processing data
c)
Creating and processing forms
d)
Administrating database
2.
A database management system (DBMS) is a:
a)
Software system used to create, maintain, and provide controlled access to a database
b)
Hardware system used to create, maintain, and provide controlled access to a database
c)
Hardware system used to create, maintain, and provide uncontrolled access to a database
d)
Software system used to create, maintain, and provide uncontrolled access to a database
3.
A_______ in a table represents a relationship among a set of values
a)
Field
b)
Foreign key
c)
Record
d)
Primary key
4.
The term attribute refers to a ________ of a table
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
5.
The term _______ is used to refer a row
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
6.
Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?
a)
NAME
b)
ID
c)
CITY
d)
ID, NAME
7.
which one of the following cannot be taken as a primary key?
a)
ID
b)
RegistrationNo
c)
DepartmentID
d)
Street
8.
Which of the following is NOT example of data?
a)
RM10
b)
The
c)
The boy received RM10
d)
Boy
9.
Which of the following is NOT Advantages of DBMS
a)
Increased data consistency
b)
Reduced data redundancy
c)
Improved data security
d)
Increase data isolation
100 %
