MCQ Questions

Question No. 1

Fill in the blanks

Answer :

(a) Small set of information becomes ............................ , this set of information helps make decision.

(b) It's a ............................ with a NOT NULL constraint and Check constraint to be > 0.

(c) ............................ represents some aspect of the real world called "............................".

(d) Its a column, having referential integrity constraint called ............................

(e) Logical association of any ------------- tables created to preserve the data integrity is called relationship.

Question No. 2

Answer the following questions:

Answer :

1. What is data?

2. What is the full form of DBMS?

3. What is DBMS and which are the types of DBMS?

4. Which types of relationship in DBMS?

5. What is table in DBMS?

6. What are the types of data models?

7. What is the difference between DBMS and RDBMS?

Question No. 3

Data is always some .................................. information.

Answer :

useless

useful

power full

Question No. 4

DBMS accepts the 'flat file' data that means there is no relation among .................................. data whereas RDBMS does not accept this type of design.

Answer :

same

wrong

different

Question No. 5

A transaction usually means a sequence of information exchange and its related ----------------

Answer :

work

data

useful

none of these

Question No. 6

In relational data model, data exists in two dimensional tables known as ----------------

Answer :

relations

formal

professional

none of these

Question No. 7

----------------------- is used for simpler business applications whereas RDBMS is used for more complex applications.

Answer :

DBMS

RDBMS

DBMSR

none of these

Question No. 8

RDBMS solution is required by large sets of .................................. whereas small sets of data can be managed by DBMS.

Answer :

data

software

time

Question No. 9

Its a CELL, intersection between row and a column having .................................. value

Answer :

NULL

NALL

NELL

Question No. 10

DBMS accepts the 'flat file' data that means there is no relation among .................................. data whereas RDBMS does not accept this type of design.

Answer :

same

wrong

different

Question No. 11

Although the foreign key concept is supported by both DBMS and RDBMS, its only RDBMS that enforces the -------------

Answer :

idea

Site

none of these

rules

Question No. 12

Relationship among tables is maintained in a ----------------- whereas this is not the case with DBMS as it is used to manage the database.

Answer :

DBMS

RDBMS

(a) is right

none of these

Question No. 13

Its a CELL, intersection between row and a column having .................................. value

Answer :

NULL

NALL

NELL

Question No. 14

DBMS accepts the 'flat file' data that means there is no relation among .................................. data whereas RDBMS does not accept this type of design.

Answer :

same

wrong

different

Question No. 15

Although the foreign key concept is supported by both DBMS and RDBMS, its only RDBMS that enforces the -------------

Answer :

idea

Site

none of these

rules

Question No. 16

Relationship among tables is maintained in a ----------------- whereas this is not the case with DBMS as it is used to manage the database.

Answer :

DBMS

RDBMS

(a) is right

none of these

Chapter

Enter Your Book Codewwww

Enter Your Book Code

Insert 6 Digit Book Code

Enter the code sent to