Classical

Database MCQ - ER-model & Relational Model

16:  

Data independence means

A.

Data is defined separately and not included in programs

B.

Programs are not dependent on the physical attributes of data.

C.

Programs are not dependent on the logical attributes of data

D.

Both (B) and (C).

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



17:  

E-R model uses this symbol to represent weak entity set ?

A.

Dotted rectangle

B.

Diamond

C.

Doubly outlined rectangle

D.

None of these

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



18:  

SET concept is used in :

A.

Network Model

B.

Hierarchical Model

C.

Relational Model

D.

None of these

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Abhishek singh said: (2:32am on Thursday 24th November 2016)
In network database terminology, a relationship is a set. Each set is made up of at least two types of records: an owner record (equivalent to parent in the hierarchical model) and a member record (similar to the child record in the hierarchical model).

Write your comments here:



19:  

Relational Algebra is

A.

Data Definition Language

B.

Meta Language

C.

Procedural query Language

D.

None of the above

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



20:  

 Key to represent relationship between tables is called

A.

Primary key

B.

Secondary Key

C.

Foreign Key

D.

None of these

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here: