Database MCQ - ER-model & Relational Model

41:  

A data dictionary is a special file that contains:

A.

The name of all fields in all files.

B.

The width of all fields in all files.

C.

The data type of all fields in all file

D.

All of the above

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here:



42:  

 A file manipulation command that extracts some of the records from a file is called

A.

SELECT

B.

PROJECT

C.

JOIN

D.

PRODUCT

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



43:  

 A primary key is combined with a foreign key creates

A.

Parent-Child relationship between the tables that connect them

B.

Many to many relationship between the tables that connect them.

C.

Network model between the tables that connect them.

D.

None of the above

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



44:  

 In E-R Diagram derived attribute are represented by

A.

Ellipse

B.

Dashed ellipse

C.

Rectangle

D.

Triangle

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



45:  

Cross Product is a:

A.

Unary Operator

B.

Ternary Operator

C.

Binary Operator

D.

Not an operator

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here: