MySQL Views MCQs with answers Page - 1

You will find multiple-choice questions (MCQs) related to #MySQL Views here. Go through these questions to prepare effectively for your upcoming exams and interviews.

To view the correct answer for any question, simply click the "Show Answer" button.

Have a question to share? Click on "Add Question" to contribute!

A

Admin • 802.91K Points
Coach

Q. What is a view in MySQL?

  • (A) A physical copy of data
  • (B) A virtual table based on a query
  • (C) A backup of a table
  • (D) An index

A

Admin • 802.91K Points
Coach

Q. Which command is used to create a view in MySQL?

  • (A) MAKE VIEW view_name AS SELECT ...;
  • (B) CREATE VIEW view_name AS SELECT ...;
  • (C) NEW VIEW view_name AS SELECT ...;
  • (D) DEFINE VIEW view_name AS SELECT ...;

A

Admin • 802.91K Points
Coach

Q. Can a MySQL view include a JOIN between multiple tables?

  • (A) Yes
  • (B) No
  • (C) Only with INNER JOIN
  • (D) Only with LEFT JOIN

A

Admin • 802.91K Points
Coach

Q. Which command is used to remove a view?

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

A

Admin • 802.91K Points
Coach

Q. Which of the following is true about views in MySQL?

  • (A) Views store data physically
  • (B) Views are virtual tables
  • (C) Views improve data storage
  • (D) Views replace indexes

A

Admin • 802.91K Points
Coach

Q. Can you update data through a view in MySQL?

  • (A) Always
  • (B) Never
  • (C) Sometimes, depending on the query
  • (D) Only with indexes

A

Admin • 802.91K Points
Coach

Q. Which keyword is used to update an existing view?

  • (A) ALTER VIEW
  • (B) MODIFY VIEW
  • (C) UPDATE VIEW
  • (D) CHANGE VIEW

A

Admin • 802.91K Points
Coach

Q. What happens if the base table of a view is dropped?

  • (A) The view continues to work
  • (B) The view is automatically dropped
  • (C) The view becomes invalid
  • (D) The view is converted into a table

A

Admin • 802.91K Points
Coach

Q. Which command lists all views in a database?

  • (A) SHOW TABLES;
  • (B) SHOW VIEWS;
  • (C) SHOW FULL TABLES WHERE Table_type = 'VIEW';
  • (D) LIST VIEWS;

A

Admin • 802.91K Points
Coach

Q. Can a view be based on another view?

  • (A) Yes
  • (B) No
  • (C) Only if indexed
  • (D) Only in temporary views

Browse More Tags

Click on tag to learn MCQs of that tag.
What's Tag

As you may know, questions are organized under broad categories. Each category can include various types of questions. For example, the "History" category might contain questions about the Revolt of 1857, Shivaji Maharaj, Ancient History, Buddhism, and more.

To further refine this organization, we've introduced tags, which act as sub-categories to group questions more specifically.

Verified users can add tags to any question. If you have any suggestions regarding this system, we'd love to hear from you. Contact Us

Learn More