Classical

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 :


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 :


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 :


44:  

 In E-R Diagram derived attribute are represented by

A.

Ellipse

B.

Dashed ellipse

C.

Rectangle

D.

Triangle

 
 

Option: B

Explanation :


45:  

Cross Product is a:

A.

Unary Operator

B.

Ternary Operator

C.

Binary Operator

D.

Not an operator

 
 

Option: C

Explanation :




Suggest an improvement