Views

Share this topic

Views

From the book I Am Datapedia!, published here free by the author.

Part of I Am Datapedia!

Self-check

Questions 1–10 of 10

  1. 1. In a database, what is a view?

    Question 1
  2. 2. Does a database view store its own data?

    Question 2
  3. 3. When does creating a view become advantageous?

    Question 3
  4. 4. How do you retrieve the combined results once a view has been created?

    Question 4
  5. 5. In the EmployeeProfile example, which tables are combined by the view?

    Question 5
  6. 6. Which SQL statement creates a view?

    Question 6
  7. 7. In the EmployeeProfile example, on which condition are the Employee and Department tables joined?

    Question 7
  8. 8. Why is understanding views described as crucial?

    Question 8
  9. 9. What is the main benefit of a view for a frequently needed multi-table result?

    Question 9
  10. 10. Which statement about a regular database view is NOT correct?

    Question 10