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

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 of the following is not a limitation of view?

  • (A) ORDER BY Does Not Work
  • (B) Index Created on View Used Often
  • (C) Cross Database Queries Not Allowed in Indexed View
  • (D) Adding Column is Expensive by Joining Table Outside View

A

Admin • 833.24K Points
Coach

Q. Which of the following statement is true?

  • (A) Views could be looked as an additional layer on the table which enables us to protect intricate or sensitive data based upon our needs
  • (B) Views are virtual tables that are compiled at run time
  • (C) Creating views can improve query response time
  • (D) All of the Mentioned

A

Admin • 833.24K Points
Coach

Q. SQL Server has mainly how many types of views?

  • (A) one
  • (B) two
  • (C) three
  • (D) four

A

Admin • 833.24K Points
Coach

Q. Dynamic Management View is a type of ___________

  • (A) System Defined Views
  • (B) User Defined View
  • (C) Simple View
  • (D) Complex View

A

Admin • 833.24K Points
Coach

Q. Syntax for creating views is __________

  • (A) CREATE VIEW AS SELECT
  • (B) CREATE VIEW AS UPDATE
  • (C) DROP VIEW AS SELECT
  • (D) CREATE VIEW AS UPDATE

A

Admin • 833.24K Points
Coach

Q. You can delete a view with ___________ command.

  • (A) DROP VIEW
  • (B) DELETE VIEW
  • (C) REMOVE VIEW
  • (D) TRUNCATE VIEW

A

Admin • 833.24K Points
Coach

Q. What is SCHEMABINDING a VIEW?

  • (A) Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view
  • (B) These are stored only in the Master database
  • (C) These types of view are defined by users on a specified schema
  • (D) These are used to show database self describing information

A

Admin • 833.24K Points
Coach

Q. The normal form which satisfies multivalued dependencies and which is in BCNF is

  • (A) 4 NF
  • (B) 3 NF
  • (C) 2 NF
  • (D) All of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which of the following is a tuple-generating dependencies?

  • (A) Functional dependency
  • (B) Equality-generating dependencies
  • (C) Multivalued dependencies
  • (D) Non-functional dependency

A

Admin • 833.24K Points
Coach

Q. The main task carried out in the __________ is to remove repeating attributes to separate tables.

  • (A) First Normal Form
  • (B) Second Normal Form
  • (C) Third Normal Form
  • (D) Fourth Normal Form

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.