What is GroupBy Clause
Group by Clause Insights
Group BY vs. Sorting
SQL Select- Quiz
SQL Subquery Statements
Understand SQL Views
How views are called?
Steps to Create View
Updating Table Row Views
Updating Table with View
SQL Views - Quiz
Key Sql Functions
Date Function - Exercise
SQL Function Conclusion
Characteristics of SQL Views - Quiz
Each question is worth one point. Select the best answer or answers for each question.
Which of the following can be characteristic(s) of a view?
A view can include WHERE statements
A view can be permanently saved in the database with the table
A view can include joins between more than one table
All of the above
Which of the following is/are not good uses for a view?
You need to combine two tables logically and be able to update the information repeatedly based on criteria in a SELECT statement
You need to select different columns from a table every time you run a given query
You need to select from different tables with a similar query
All of the above are good uses for a view
Which of the following is a specific benefit of a view?
Speed, because the query results are returned more quickly
Convenience, by having a predefined SELECT statement
Access, because making a view grants the user permission to use the tables
Security, because views can be used to prevent people from updating the database accidentally
Given the following tables:
Is the following view updateable?
CREATE VIEW MyView AS SELECT * FROM Stores, Invoices
Yes, because the tables are in the same database
Yes, because the CREATE VIEW statement references both tables
No, because there is no unique key defined for the tables
No, because you cannot use a * symbol in this statement
Your Score: 0