×

Multiple-Choice Questions

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Management MCQs

More

DBMS Higher Degree Relationship Multiple-Choice Questions (MCQs)

DBMS Higher Degree Relationship MCQs: This section contains DBMS Higher Degree Relationship Multiple-Choice Questions (MCQs) and Answers.
Submitted by Anushree Goswami, on February 19, 2022

1. In relation to a/an ___, the degree of relationship is determined by the number of occurrences of that ___ that occur in another ___.

  1. Entity
  2. Relationship
  3. Table
  4. Database

Answer: A) Entity

Explanation:

In relation to an entity, the degree of relationship is determined by the number of occurrences of that entity that occur in another entity.

Discuss this Question


2. How many degrees of relationships are there?

  1. 2
  2. 3
  3. 4
  4. 5

Answer: B) 3

Explanation:

There are 3 degrees of relationships: One-to-One, One-to-Many and Many-to-Many.

Discuss this Question


3. A one-to-one relationship occurs when one occurrence of one entity occurs in ___ instance of another entity.

  1. More than two
  2. Multiple
  3. Only Two
  4. Only One

Answer: D) Only One

Explanation:

A one-to-one relationship occurs when one occurrence of one entity occurs in only one instance of another entity.

Discuss this Question


4. Which of the following degrees exists rarely in a relationship?

  1. One-to-One
  2. Many-to-Many
  3. Both A and B
  4. One-to-Many

Answer: C) Both A and B

Explanation:

Both One-to-One and Many-to-Many degrees exist rarely in a relationship.

Discuss this Question


5. What could be an example of a One-to-One degree of relationship?

  1. Employee and Company
  2. Department and Employee
  3. Employee and Project
  4. All of the above

Answer: A) Employee and Company

Explanation:

Employee and Company is an example of One-to-One degree of relationship.

Discuss this Question


6. In a ___ relationship, there are many instances of something occurring in one entity associated with many instances of something else.

  1. One-to-One
  2. One-to-Many
  3. Many-to-Many
  4. None of the above

Answer: B) One-to-Many

Explanation:

In a one-to-many relationship, there are many instances of something occurring in one entity associated with many instances of something else.

Discuss this Question


7. In a many-to-many relationship, ____ events in one entity affect ____ events in another.

  1. One
  2. Two
  3. Three
  4. Many

Answer: D) Many

Explanation:

In a many-to-many relationship, many events in one entity affect many events in another.

Discuss this Question


8. What could be an example of a One-to-Many degree of relationship?

  1. Department and Company
  2. Department and Employee
  3. Department and CEO
  4. All of the above

Answer: B) Department and Employee

Explanation:

Department and Employee is an example of a One-to-Many degree of relationship.

Discuss this Question


9. What could be an example of a Many-to-Many degree of relationship?

  1. Employee and Department
  2. Employee and Project
  3. Employee and CEO
  4. All of the above

Answer: B) Employee and Project

Explanation:

Employee and Project is an example of a Many-to-Many degree of relationship.

Discuss this Question


10. One-to-Many is denoted as –

  1. 1:M
  2. M:M
  3. M:1
  4. 1:1

Answer: A) 1:M

Explanation:

One-to-Many is denoted as 1:M.

Discuss this Question


11. One-to-One is denoted as –

  1. 1:1
  2. 1:M
  3. M:1
  4. M:M

Answer: A) 1:1

Explanation:

One-to-One is denoted as 1:1.

Discuss this Question


12. Many-to-Many is denoted as –

  1. 1:1
  2. 1:M
  3. M:1
  4. M:M

Answer: D) M:M

Explanation:

Many-to-Many is denoted as M:M.

Discuss this Question





Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.