List of top DBMS Questions on Database Introduction

Match List - I with List - II.

List - I		List - II
(A)	Data Base Schema	(I)	Limitation on the type of data
(B)	Data Constraint	(II)	Data about data
(C)	Meta Data	(III)	State or snapshot of the database
(D)	Database Instance	(IV)	Visual or logical architecture

Choose the correct answer from the options given below:

Consider the following statements:
(A) Each attribute in a relation has a unique name
(B) All data values in an attribute must be from the same domain
(C) A special value NULL is used to represent values that are unknown
(D) A database constraint allow different types of data to inserted into the table
Choose the correct answer from the options given below:

____ is the logical architecture of a Database while ____ after loading data in a database.

File system becomes difficult to handle when number of files increases and volume of data also grows. Identify the limitations of file system.

Consider the table below: UNIFORM

Vcode	Vname	Vcolor
1	Shirt	White
2	Pant	Grey
3	Skirt	Grey

Which of the following tuples cannot be inserted into the UNIFORM table ?

Identify the one which is not an online database.

Which of the following is a disadvantage of using questionnaire method of data collection?