wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

DBMS-Quiz1

Total questions: 15

Worksheet time: 7mins

Name
Class
Date
1.
A foreign key
a)
Links to a primary key in another table. 
b)
Links to another foreign key. 
c)
Links to another database system. 
d)
Should always reference a unique value in the same table. 
2.
An ER diagram shows relationships between:
a)
Tables in a relational database. 
b)
Rows in a relational database. 
c)
Records with foreign keys. 
d)
Two items about which there is data kept. 
3.

Which is the best example of a Primary Key?

a)

Price

b)

Name

c)

Address

d)

IC No

4.

Which of the following is NOT an example of a database?

a)

telephone book

b)

real estate listing

c)

online library catalog

d)

DVD

5.

GRANT & REVOKE IS THE

a)

DDL

b)

DML

c)

DCL

d)

TCL

6.

INFORMATION IS A COLLECTION OF

a)

FIELDS

b)

FILES

c)

DATA

d)

RECORDS

7.

METADATA IS A

a)

ABOUT A DATA

b)

ABOUT A FIELD

c)

ABOUT A INFORMATION

d)

ABOUT A WAREHOUSE

8.

OPERATIONS OF DATABASE

a)

INSERT

b)

DELETE

c)

RECORD

d)

SAVE

9.

CREATE & DROP IS A ----------STATEMENT

a)

DDL

b)

DCL

c)

DML

d)

TCL

10.

SELECT & INSERT

a)

DDL

b)

DML

c)

DCL

d)

TCL

11.

Which of the following is NOT an example of a database?

a)

telephone book

b)

real estate listing

c)

online library catalog

d)

DVD

12.

Which of the following is an application of DBMS?

a)

Banking

b)

Airlines

c)

university

d)

All of them

13.

Database is a collection of

a)

Data

b)

Related data

c)

Correct data

d)

fields

14.

------------------- is software package for creating and managing databases.

(a)  

15.

A field in the student file

a)

employee-id

b)

register-no

c)

branch-name

d)

account-no