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 :

Click on Discuss to view users comments.

Write your comments here:



22:  

DBMS helps achieve

A.

Data independence

B.

Centralized control of data

C.

Control redundancy

D.

All of above

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



23:  

Which of the following are the properties of entities?

A.

Groups

B.

Table

C.

Attributes

D.

Switchboards

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



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 :

Click on Discuss to view users comments.

Write your comments here:



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 :

Click on Discuss to view users comments.

md ilyas said: (6:51pm on Wednesday 25th February 2015)
multiple access is possible in dbms

Write your comments here: