WorksheetsDBMS
Total questions: 15
Worksheet time: 16mins
The following are the functions of a DBMS except
Creating database
Processing data
Creating and processing forms
Administrating database
The attribute refers to a _____ of a table
Record
Foreign key
Primary key
Field
The term _____ is used to refer a row
Record
Primary key
Foreign key
Field
Consider attributes ID, CITY and NAME. which one of these can be considered as a primary key?
NAME
ID
CITY
ID, NAME
Which one of these cannot be taken as a primary key?
ID
registration no
Department ID
Street
Which one of the following is NOT an example of data
RM10
Girl
Boy
The boy received RM10
Which one of the following is NOT an advantage of DBMS
Increased data consistency
Reduced data redundancy
Improved data security
Increase data isolation
Which of the following gives a logical structure of the database graphically?
Entity - relationship diagram
Entity diagram
Database diagram
Architectural representation
If you were collecting and storing information about your music collection, an album would be considered a/an _______
Relation
Instance
Entity
Attribute
_____ is an example of simple attribute
Address
Roll No.
Course Names
None of the above
An ordered set of data constituting a record is called
Attribute
Row
Tuple
Field
This is an example of ________________
Data inconsistency
Data redundancy
Data security
Data consistency
Who is responsible for user authentication
Database Administartor
Naive User
Sophisticated user
Data Analyst
Database is a collection of
unrelated data
related data
Not known data
NULL data
Relational model describes data in the form of
box
circles
tables
none of the above
