Answer 1

A View is a stored SQL statement - it has no data, but can be called like a Table in a SELECT statement. It is commonly used to create a commonly-used, complex SQL statement that can be referenced like a table, to save you from writing large SQL statements again and again.

A result set is the data from running a SELECT statement. If you run a SELECT statement from a View or a Table, the output is the result set.