> > >

MySQL MCQs

What is the correct syntax to create a view?

CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition

CREATE VIEW view_name SELECT column_name(s) FROM table_name WHERE condition

CREATE VIEW view_name AS USING column_name(s) FROM table_name WHERE condition

None of the above

Answer

Correct Answer: CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it