Views — Learn free · DataAI Nexus

Self-check

Questions 1–10 of 10

1. In a database, what is a view?
Question 1A. A physical copy of a table stored on diskB. A virtual representation of a table that encapsulates a queryC. A backup of the database taken at a point in timeD. An index that speeds up joinsE. A stored file containing exported rows
2. Does a database view store its own data?
Question 2A. Yes, it stores a permanent copy of the query resultB. Yes, but only for the most recent queryC. No, it dynamically fetches data from the underlying tables whenever it is queriedD. Only when the view joins more than two tablesE. Only if it is created with an index
3. When does creating a view become advantageous?
Question 3A. When a table has fewer than ten rowsB. When the database has no primary keysC. When a query is run only onceD. When a query joining several tables is run frequently, such as daily or monthlyE. When the data must be stored in an external file
4. How do you retrieve the combined results once a view has been created?
Question 4A. By exporting the view to a CSV fileB. By running REFRESH on the viewC. By rebuilding the underlying tablesD. By re-running the original join query manuallyE. By executing a simple SELECT command on the view
5. In the EmployeeProfile example, which tables are combined by the view?
Question 5A. Employee and DepartmentB. Customer and OrderC. Product and SupplierD. Student and CourseE. Invoice and Payment
6. Which SQL statement creates a view?
Question 6A. CREATE TABLE ... AS SELECTB. CREATE VIEW ... AS SELECTC. INSERT INTO VIEWD. ALTER TABLE ... ADD VIEWE. SELECT INTO VIEW
7. In the EmployeeProfile example, on which condition are the Employee and Department tables joined?
Question 7A. Employee.Name = Department.NameB. Employee.Salary = Department.BudgetC. Employee.DeptID = Department.DeptIDD. Employee.ID = Department.ManagerIDE. Employee.Location = Department.Location
8. Why is understanding views described as crucial?
Question 8A. Because views are the only way to store data securelyB. Because views replace the need for tablesC. Because views are required for every SELECT statementD. Because they are a foundational concept leading into more advanced topics such as Materialised Views and External TablesE. Because views are needed to create primary keys
9. What is the main benefit of a view for a frequently needed multi-table result?
Question 9A. It doubles the storage used by the tablesB. It makes the underlying tables read-onlyC. It automatically normalises the tablesD. It caches the result permanently on diskE. It avoids rewriting the complex join query every time the consolidated information is needed
10. Which statement about a regular database view is NOT correct?
Question 10A. A view physically stores a snapshot of the query resultB. A view can combine data from several tablesC. A view is queried with a SELECT statementD. A view is described as the virtual representation of a tableE. A view fetches data from the underlying tables at query time