> > >

SQL MCQs

Which of the following is true for creating SQL Views? (check any that apply)

If you have a complex select with lots of joins, you can implement it in a view and simply call the view without need to consider all these joins.

Each user can be given permission to access the database only through a small set of views that contain the specific data the user is authorized to see, thus restricting the user's access to stored data

A view can draw data from several different tables and present it as a single table, turning multi-table queries into single-table queries against the view.

Answer

Correct Answer: A view can draw data from several different tables and present it as a single table, turning multi-table queries into single-table queries against the view.

Explanation:

Note: This question has more than 1 correct answers

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

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it