Database MCQ - ER-model & Relational Model

31:  

The users who use easy-to-use menu are called

A.

Sophisticated end users

B.

Naïve users.

C.

Stand-alone users.

D.

Casual end user

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



32:  

 Which database level is closest to the users?

A.

External

B.

Internal

C.

Physical

D.

Conceptual

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



33:  

Which are the two ways in which entities can participate in a relationship?

A.

Passive and active

B.

Total and partial

C.

Simple and Complex

D.

All of the above

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



34:  

The result of the UNION operation between R1 and R2 is a relation that includes

A.

All the tuples of R1

B.

All the tuples of R2

C.

All the tuples of R1 and R2

D.

All the tuples of R1 and R2 which have common columns

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

shekhar said: (6:26pm on Thursday 15th August 2013)
option D is correct because UNION result depend on condition that both relation should have comman field or common column to generate result.
shekhar said: (6:26pm on Thursday 15th August 2013)
option D is correct because UNION result depend on condition that both relation should have comman field or common column to generate result.

Write your comments here:



35:  

 A set of possible data values is called

A.

Attribute

B.

Degree.

C.

Tuple.

D.

Domain.

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here: