BITS WILP Database Design and Applications Quiz-1 2017-H1

Question 1

Which of the following concept is not part of ER modeling.

Select one:

degree of a relationship

partial key

primary key

weak entity type

Feedback

The correct answer is: primary key

Question 2

SQL is a procedural query language for Relational model.

Select one:

True

False

Feedback

The correct answer is 'False'.

Question 3

In ER modeling, which of the following is not correct?

Select one:

Weak entity types are represented by double rectangles

Weak entity types always have total participation

A weak entity type can have a multivalued attribute.

A weak entity type and its owner entity type can heve many-to-many relationship.

Feedback

The correct answer is: A weak entity type and its owner entity type can heve many-to-many relationship.

Question 4

The number of columns or attributes of a relation is known as the cardinality of that relation.

Select one:

True

False

Feedback

The correct answer is 'False'.

Question 5

Assume that we have two tables EMP and DEPT. Now when we execute the SQL query-

 SELECT * FROM EMP, DEPT; 

which of the following is correct?

Select one:

Shows SQL error since no join condition in WHERE clause

Always gives  zero tuples in the result

Result will have EMP tuples joined with DEPT table  if some join condition is met.

It is Cartesian product of EMP and DEPT

Feedback

The correct answer is: It is Cartesian product of EMP and DEPT

Question 6

Which of the following is not a representational or implementation data model?

Select one:

Relational model

Object model

ER model

Object relational model

Feedback

The correct answer is: ER model

Question 7

Ordering of tuples is not significant in a relation.

Select one:

True

False

Feedback

The correct answer is 'True'.