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

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. The function that an entity plays in a relationship is called that entity’s _____________

  • (A) Participation
  • (B) Position
  • (C) Role
  • (D) Instance

A

Admin • 833.24K Points
Coach

Q. The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

  • (A) Simple attribute
  • (B) Composite attribute
  • (C) Multivalued attribute
  • (D) Derived attribute

A

Admin • 833.24K Points
Coach

Q. In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.

  • (A) Desciptive
  • (B) Derived
  • (C) Recursive
  • (D) Relative

A

Admin • 833.24K Points
Coach

Q. _____________ can help us detect poor E-R design.

  • (A) Database Design Process
  • (B) E-R Design Process
  • (C) Relational scheme
  • (D) Functional dependencies

A

Admin • 833.24K Points
Coach

Q. If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

  • (A) A many-to-many relationship set
  • (B) A multivalued attribute of an entity set
  • (C) A one-to-many relationship set
  • (D) Both A many-to-many relationship set and A multivalued attribute of an entity set

A

Admin • 833.24K Points
Coach

Q. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.

  • (A) A many-to-many relationship set
  • (B) A multivalued attribute of an entity set
  • (C) A one-to-many relationship set
  • (D) All of the mentioned

A

Admin • 833.24K Points
Coach

Q. A data dictionary is a special file that contains?

  • (A) The names of all fields in all files
  • (B) The data types of all fields in all files
  • (C) The widths of all fields in all files
  • (D) All of the mentioned

A

Admin • 833.24K Points
Coach

Q. A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called

  • (A) Metadata
  • (B) Catalog
  • (C) Log
  • (D) Dictionary

A

Admin • 833.24K Points
Coach

Q. Relational schemas and other metadata about relations are stored in a structure called the ____________

  • (A) Metadata
  • (B) Catalog
  • (C) Log
  • (D) Data Dictionary

A

Admin • 833.24K Points
Coach

Q. ___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.

  • (A) Database
  • (B) Instance
  • (C) Tablespace
  • (D) Segment

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.