Explore topic-wise MCQs in Mysql.

This section includes 5 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.

1.

What is abc in the following statement?
CREATE VIEW xyz (abc) AS SELECT a FROM t;
A. view
B. database
C. column name
D. row name
E. None of these
Answer» D. row name
Discussion
2.

What is xyz in the following statement?
CREATE VIEW xyz AS SELECT a, b FROM t;
A. column
B. database
C. table
D. view
E. None of these
Answer» E. None of these
Discussion
3.

A view can refer to multiple tables via __________.

A. SELECT
B. GROUP
C. UNION
D. JOIN
E. None of these
Answer» E. None of these
Discussion
4.

Which of the following does not support materialized view?

A. Oracle
B. SybaseSQL
C. MySQL
D. PostgreSQL
E. None of these
Answer» D. PostgreSQL
Discussion
5.

A view can be deleted using the command __________.

A. CLEAR
B. DROP
C. DELETE
D. REMOVE
E. None of these
Answer» C. DELETE
Discussion