Free Printable Introduction to DBMS

1.

.A…..is a collection of information organized in such a way that a computer program can select required data.

(a)

2.

The ……data type store date

(a)

3.

…………...is the small unit of data storage.

(a)

4.

……………is also called as tuple.

(a)

5.

RDBMS stands for…………………………..

(a)

6.

Data helps in decision making

a)

True

b)

false

7.

Data security means unauthorized users cannot access data

a)

True

b)

False

8.

Time datatype holds date

a)

True

b)

False

9.

database contains only single table

a)

False

b)

True

10.

In one to one relationship multiple records IN A table are associated with multiple records in another table.

a)

True

b)

False

11.

Primary key field is

a)

i) duplicate

b)

ii) Unique

c)

iii)Blank

d)

iv)Not Null

12.

Text has following data types.

a)

i)character

b)

ii)String

c)

iii)Char

d)

iv)Varchar

13.

Which one is the correct format for TIME() datatype...

a)

i) MM:HH:SS

b)

ii) HH:MM:SS

c)

iii) SS:MM:HH

d)

iv) HH:SS:MM:MM

14.

In ……relationship multiple records in a table are connected with multiple records in another table,

a)

i)One to One

b)

ii) One to Many

c)

iii)Many to Many

d)

iv)Many to one.

15.

All columns in a table make a …..

a)

i)Column

b)

ii)Key

c)

iii)Row

d)

iv)Fields

16.

……….consists of Columns and Raw.

a)

i)Table

b)

ii)Rows

c)

iii)Record

d)

iv)Data.

Introduction to DBMS

Total questions: 16

Worksheet time: 11mins

Similar Resources on Wayground