ADVERTISEMENT
ADVERTISEMENT

DBMS ER-Diagram Reduction to Table Multiple-Choice Questions (MCQs)

DBMS ER-Diagram Reduction to Table MCQs: This section contains DBMS ER-Diagram Reduction to Table Multiple-Choice Questions (MCQs) and Answers.
Submitted by Anushree Goswami, on February 16, 2022

1. You can represent the database using the ___.

  1. Tables
  2. Notations
  3. Database
  4. Fields

Answer: B) Notations

Explanation:

You can represent the database using the notations.

Discuss this Question


2. An entity or relationship set may be represented in a database as a ___.

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

Answer: A) Table

Explanation:

An entity or relationship set may be represented in a database as a table.

Discuss this Question


3. What are some important points to convert ER Diagrams into tables?

  1. Tables are created from entity types.
  2. Whenever an attribute is single-valued, it becomes a column for the table.
  3. Primary keys represent key attributes of entity types.
  4. All of the above

Answer: D) All of the above

Explanation:

Some important points to convert ER Diagrams into tables are -

  1. Tables are created from entity types.
  2. Whenever an attribute is single-valued, it becomes a column for the table.
  3. Primary keys represent key attributes of entity types.

Discuss this Question


4. A separate table represents the ___ attribute.

  1. Single-valued
  2. Double-valued
  3. Multivalued
  4. None of the above

Answer: C) Multivalued

Explanation:

A separate table represents the multivalued attribute.

Discuss this Question


5. Components represent an attribute of a ___.

  1. Simple
  2. Combined
  3. Composite
  4. Intrinsic

Answer: C) Composite

Explanation:

Components represent an attribute of a composite.

Discuss this Question


6. Which attributes aren't considered in a table?

  1. Core
  2. Composite
  3. Derived
  4. None

Answer: C) Derived

Explanation:

Derived attributes aren't considered in a table.

Discuss this Question


7. How many rules are there for reducing the ER Diagram into a table?

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

Answer: D) 6

Explanation:

There are 6 rules for reduction of ER Diagram into a table.

Discuss this Question


8. Entity type's key attribute is represented by -

  1. Foreign Key
  2. Composite Key
  3. Alternate Key
  4. Primary Key

Answer: D) Primary Key

Explanation:

Entity type's key attribute is represented by Primary Key.

Discuss this Question


9. Which type of attributes become the column for the table.

  1. Single-valued
  2. Double-valued
  3. Multivalued
  4. None

Answer: A) Single-valued

Explanation:

Single-valued attributes become the column for the table.

Discuss this Question


10. What cannot be represented in a tabular form?

  1. Entity set
  2. Relationship Set
  3. Dataset
  4. None

Answer: D) None

Explanation:

All entity set, relationship set and dataset can be represented in a tabular form.

Discuss this Question



ADVERTISEMENT
ADVERTISEMENT


Comments and Discussions!



ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.