Classical

Database MCQ - ER-model & Relational Model

21:  

_______ produces the relation that has attributes of R1 and R2

A.

Cartesian product

B.

Difference

C.

Intersection

D.

Product

 
 

Option: A

Explanation :


22:  

DBMS helps achieve

A.

Data independence

B.

Centralized control of data

C.

Neither (A) nor (B)

D.

both (A) and (B)

 
 

Option: D

Explanation :


23:  

Which of the following are the properties of entities?

A.

Groups

B.

Table

C.

Attributes

D.

Switchboards

 
 

Option: C

Explanation :


24:  

 In a relation

A.

Ordering of rows is immaterial

B.

No two rows are identical

C.

(A) and (B) both are true

D.

None of these

 
 

Option: C

Explanation :


25:  

It is better to use files than a DBMS when there are

A.

Stringent real-time requirements

B.

Multiple users wish to access the data

C.

Complex relationships among data

D.

All of the above.

 
 

Option: B

Explanation :




Suggest an improvement