wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

RDBMS

Total questions: 20

Worksheet time: 4mins

Name
Class
Date
1.

A database is an organized collection of _______________.

a)

a. data

b)

b. Attributes

c)

c. Record

d)

d. None of the above

2.

Which of the following software is appropriate to store data about school students?

a)

MySQL

b)

Word

c)

Excel

d)

Acess

3.

Which of the following is not a database programs?

a)

a. MySQL

b)

b. Oracle

c)

c. Writer

d)

d. OObase

4.

__________ store data in Single table.

a)

a. Flat File

b)

b. Relational

c)

c. Single File

d)

d. One File

5.

___________ are dedicated computers that hold the actual databases and run only DBMS and related Software.

a)

a. Main Server

b)

b. Web Server

c)

c. Database Server

d)

d. Non Database Server

6.

Duplication of data is called _________.

a)

a. Inconsistency

b)

b. Consistency

c)

c. Redundancy

d)

d. Foreign Key

7.

Data Integrity means that data is accurate and consistent in the database.(T/F)

a)

a. True

b)

b. False

8.

A database can have only one table.(T/F)

a)

a. True

b)

b. False

9.

Which of the following will help to maintain unique record in the table?

a)

a. Foreign Key

b)

b. Primary Key

c)

c. Composite Key

d)

d. Alternate Key

10.

Which of the following field of table “Book” can act as primary key?

a)

a. Book_number

b)

b. Subject

c)

c. price

d)

d. Author_name

11.

When primary key is made up of two or more columns then it is called __ primary key

a)

a. Mixed

b)

b. Reference

c)

c. Composite

d)

d. Compost

12.

Duplicate values can be entered in primary key.(T/F)

a)

a. True

b)

b. False

13.

A key which is referring to the primary key of another table is called _______

a)

a. Alternate Key

b)

b. Primary Key

c)

c. First Primary Key

d)

d. Foreign Key

14.

A field which is ______ for each and every record is called Primary key.

a. Common

b. Same

c. Unique

d. None of the above

a)

a. Common

b)

b. Same

c)

c. Unique

d)

d. None of the above

15.

Identify the Foreign Key from table “Sales”

Table Client:

ClientID (primary Key)

clientname

clientphone

Table : Sales

SalesID (Primary Key)

ClientID

Profit

a)

a. SalesID

b)

b. Profit

c)

c. Clientphone

d)

d. ClientID

16.

There can be multiple primary key in a table.(T/F)

a. True

b. False

a)

a. True

b)

b. False

17.

___________ represent a single record in a table.

a)

a. Tuples

b)

b. Attributes

c)

c. Relation

d)

d. All of the above

18.

Every row in a table has the same structure.(T/F)

a)

True

b)

False

19.

__________ are used to identify which type of data we are going to store in the database.

a)

a. Datatype

b)

b. Record

c)

c. Table

d)

d. Attributes

20.

RDBMS stands for

a)

Relational Database Manegement system

b)

Rational Database Manegement system

c)

Relative Database Manegement system

d)

Related Database Management System