Database Management Systems (3130703) MCQs

MCQs of Data Models

Showing 31 to 30 out of 40 Questions
31.

Relationship between 2 entities is called relationship.

(a)

Unary

(b)

Binary

(c)

Ternary

(d)

Quatary

Answer:

Option (b)

32.

Relationship between 3 entities is called _________relationship.

(a)

Unary

(b)

Binary

(c)

Ternary

(d)

Quatarnary

Answer:

Option (c)

33.

Which of the following atrribute is Composite Attribute?

(a)

Name

(b)

Mobile Number

(c)

Salary

(d)

City

Answer:

Option (a)

34.

Which of the following is an Multi-valued attribute?

(a)

Rollno

(b)

Age

(c)

Phoneno

(d)

Birthdate

Answer:

Option (c)

35.

Which of the following is an Derived attribute?

(a)

Age

(b)

Birthdate

(c)

Salary

(d)

Phoneno

Answer:

Option (a)

36.

Attributes of the relationship is called __________ attribute.

(a)

double

(b)

single

(c)

named

(d)

descriptive

Answer:

Option (d)

37.

The same entity participates in a relationship set more than once then it is called _________

(a)

multi relationship set

(b)

recursive relationship set

(c)

self relationship set

(d)

many relationship set

Answer:

Option (b)

38.

Below given is an example of which mapping cardinality?

A customer is connected with only one loan using the relationship borrower and a loan is connected with only one customer using borrower.

(a)

One to One

(b)

One to Many

(c)

Many to One

(d)

Many to Many

Answer:

Option (a)

39.

Below given is an example of which mapping cardinality?

A loan is connected with only one customer using borrower and a customer is connected with more than one loans using borrower.

(a)

One to One

(b)

One to Many

(c)

Many to Many

(d)

Multi to Multi

Answer:

Option (b)

40.

Below given is an example of which mapping cardinality?

A customer is connected with more than one loan using borrower and a loan is connected with more than one customer using borrower.

(a)

One to One

(b)

One to Many

(c)

Many to One

(d)

Many to Many

Answer:

Option (d)

Showing 31 to 30 out of 40 Questions