MySQL MCQs with answers Page - 5

Dear candidates you will find MCQ questions of MySQL here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

📊 MySQL
Q. Which of the following does not support materialized view?
  • (A) Oracle
  • (B) SybaseSQL
  • (C) MySQL
  • (D) PostgreSQL
💬 Discuss
✅ Correct Answer: (C) MySQL
📊 MySQL
Q. What can be used to check for views that have been invalidated by DROP or ALTER operations?
  • (A) DETAILS TABLE
  • (B) CHECK TABLE
  • (C) VERIFY TABLE
  • (D) CREATE TABLE
💬 Discuss
✅ Correct Answer: (B) CHECK TABLE
📊 MySQL
Q. What cannot be done on a view?
  • (A) index
  • (B) drop
  • (C) display
  • (D) filter
💬 Discuss
✅ Correct Answer: (A) index
📊 MySQL
Q. A view can be deleted using the command __________
  • (A) CLEAR
  • (B) DROP
  • (C) DELETE
  • (D) REMOVE
💬 Discuss
✅ Correct Answer: (B) DROP
📊 MySQL
Q. Views are not updatable.
  • (A) False
  • (B) True
  • (C) ---
  • (D) ---
💬 Discuss
✅ Correct Answer: (A) False
📊 MySQL
Q. A view can refer to multiple tables via
  • (A) SELECT
  • (B) GROUP
  • (C) UNION
  • (D) JOIN
💬 Discuss
✅ Correct Answer: (D) JOIN
📊 MySQL
Q. What is abc in the following statement?
Code: 
CREATE VIEW xyz (abc) AS SELECT a FROM t;
  • (A) view
  • (B) database
  • (C) column name
  • (D) row name
💬 Discuss
✅ Correct Answer: (C) column name
📊 MySQL
Q. What is xyz in the following statement?
Code: 
CREATE VIEW xyz AS SELECT a, b FROM t;
  • (A) column
  • (B) database
  • (C) table
  • (D) view
💬 Discuss
✅ Correct Answer: (D) view
📊 MySQL
Q. A View can be used to select a subset of the table columns.
  • (A) False
  • (B) True
  • (C) ---
  • (D) ---
💬 Discuss
✅ Correct Answer: (B) True
📊 MySQL
Q. Which of these is also known as a virtual table?
  • (A) JOIN
  • (B) VIEW
  • (C) DATABASE
  • (D) SCHEMA
💬 Discuss
✅ Correct Answer: (B) VIEW

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play