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

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. Which forms has a relation that possesses data about an individual entity?

  • (A) 2NF
  • (B) 3NF
  • (C) 4NF
  • (D) 5NF

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) None of the mentioned

A

Admin • 833.24K Points
Coach

Q. Fifth Normal form is concerned with

  • (A) Functional dependency
  • (B) Multivalued dependency
  • (C) Join dependency
  • (D) Domain-key

A

Admin • 833.24K Points
Coach

Q. n which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

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

A

Admin • 833.24K Points
Coach

Q. In 2NF

  • (A) No functional dependencies (FDs) exist
  • (B) No multivalued dependencies (MVDs) exist
  • (C) No partial FDs exist
  • (D) No partial MVDs exist

A

Admin • 833.24K Points
Coach

Q. Where is metadata stored in MySQL?

  • (A) in the mysql database meta
  • (B) in the mysql database metasql
  • (C) in the mysql database metadata
  • (D) in the mysql database mysql

A

Admin • 833.24K Points
Coach

Q. What MySQL property is used to create a surrogate key in MySQL?

  • (A) identical
  • (B) unique
  • (C) auto_increment
  • (D) sequence

A

Admin • 833.24K Points
Coach

Q. A relational database consists of a collection of

  • (A) keys
  • (B) records
  • (C) tables
  • (D) fields

A

Admin • 833.24K Points
Coach

Q. A Database Management System (DBMS) is:

  • (A) collection of data describing one particular enterprise
  • (B) collection of programs to access data
  • (C) all options are correct
  • (D) collection of interrelated data

A

Admin • 833.24K Points
Coach

Q. Which of the following is not a level of data abstraction?

  • (A) view level
  • (B) physical level
  • (C) logical level
  • (D) critical level

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.