Database Management System (DBMS) MCQs with answers Page - 75

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. Key to represent relationship between tables is called

  • (A) primary key
  • (B) secondary key
  • (C) foreign key
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. A window into a portion of a database is

  • (A) schema
  • (B) view
  • (C) query
  • (D) data dictionary

A

Admin • 833.24K Points
Coach

Q. A primary key is combined with a foreign key creates

  • (A) parent-child relation ship 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 mentioned

A

Admin • 833.24K Points
Coach

Q. The entity set person is classified as student and employee. This process is called

  • (A) generalization
  • (B) specialization
  • (C) inheritance
  • (D) constraint generalization

A

Admin • 833.24K Points
Coach

Q. Which relationship is used to represent a specialization entity?

  • (A) isa
  • (B) ais
  • (C) onis
  • (D) whois

A

Admin • 833.24K Points
Coach

Q. The refinement from an initial entity set into successive levels of entity subgroupings represents a design process in which distinctions are made explicit.

  • (A) hierarchy
  • (B) bottom-up
  • (C) top-down
  • (D) radical

A

Admin • 833.24K Points
Coach

Q. There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called

  • (A) commonality
  • (B) specialization
  • (C) generalization
  • (D) similarity

A

Admin • 833.24K Points
Coach

Q. If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has

  • (A) hierarchy
  • (B) multilevel inheritance
  • (C) single inheritance
  • (D) multiple inheritance

A

Admin • 833.24K Points
Coach

Q. A constraint requires that an entity belong to no more than one lower- level entity set.

  • (A) disjointness
  • (B) uniqueness
  • (C) special
  • (D) relational

A

Admin • 833.24K Points
Coach

Q. Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is

  • (A) overlapping
  • (B) disjointness
  • (C) uniqueness
  • (D) relational

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.