Database MCQ - ER-model & Relational Model

36:  

Which of the operations constitute a basic set of operations for manipulating relational data?

A.

Predicate calculus

B.

Relational calculus

C.

Relational algebra

D.

None of the above

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



37:  

Which of the following is another name for weak entity?

A.

Child

B.

Owner

C.

Dominant

D.

All of the above

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



38:  

Which of the following database object does not physically exist?

A.

Base table

B.

Index

C.

View

D.

None of the above

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

abhijit ghosh said: (5:24pm on Thursday 6th June 2013)
If view does not exist physically then where it get stored and how its values are seen when we execute select or update query on it?
chhavinder kumar said: (6:03pm on Wednesday 3rd May 2017)
Whay should view does not physically exist
karthika said: (12:54am on Sunday 14th January 2018)
View is just logical..that is why it is absent phisically.......i guess so

Write your comments here:



39:  

NULL is

A.

The same as 0 for integer

B.

The same as blank for character

C.

The same as 0 for integer and blank for character

D.

Not a value

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



40:  

 Which of the following is record based logical model?

A.

Network Model

B.

Object oriented model

C.

E-R Model

D.

None of these

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here: