Database MCQ - ER-model & Relational Model

26:  

The conceptual model is

A.

Dependent on hardware

B.

Dependent on software.

C.

Dependent on both hardware and software

D.

Independent of both hardware and software

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



27:  

What is a relationship called when it is maintained between two entities?

A.

Unary

B.

Binary

C.

Ternary

D.

Quaternary

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



28:  

Which of the following operation is used if we are interested in only certain columns of a table?

A.

PROJECTION

B.

SELECTION

C.

UNION

D.

JOIN

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



29:  

The RDBMS terminology for a row is

A.

Tuple.

B.

Relation.

C.

Attribute.

D.

Degree.

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



30:  

 Which of the following is an advantage of view?

A.

Data security

B.

Derived columns

C.

Hiding of complex queries

D.

All of the above

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here: