Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 715 |
Which of the following statements is not true for views in SQL?
| Select statement used in the view definition cannot include ORDER BY clause | |
| A view derives its data from the base tables(s) | |
| A view is updatable if it has been defined from a single relation | |
| A view contains a copy of the data |
Question 715 Explanation:
●In SQL, a view is a virtual table based on the result-set of an SQL statement.
● A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.
● You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
● A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.
● You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
Correct Answer: C
Question 715 Explanation:
●In SQL, a view is a virtual table based on the result-set of an SQL statement.
● A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.
● You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
● A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.
● You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.