Answer-What is the purpose of a 'View' in a database?

Answer B To provide a virtual table based on the result-set of an SQL statement.

Question

What is the purpose of a "View" in a database?

A To physically store a subset of data from a table. Correct Incorrect

B To provide a virtual table based on the result-set of an SQL statement. Correct Incorrect

C To enforce data integrity constraints. Correct Incorrect

D To define a new data type. Correct Incorrect

E To optimize query performance by pre-calculating results. Correct Incorrect

Answer: B) To provide a virtual table based on the result-set of an SQL statement.

Given a `Queue` data structure with `enqueue` and `dequeue` operations. What is the element returned by the last `dequeue` operation in the following seque...
Query optimization heuristic that “pushes selections down” improves:
Which SQL command is used to retrieve data from a database?
In the context of database transactions, which isolation level allows "non-repeatable reads" but prevents "dirty reads"?
What does re.sub(r'(\w+)', r'_\1_', 'hello world') return?
What is the purpose of 'indexing' in a database?
Which of the following database models represents data as a collection of tables, where each table consists of rows and columns?
Which of the following is used to enforce referential integrity?
What is the purpose of a "View" in a database?
Which of the following schedules is serializable?

Please enter email id The email must be a valid email address.

Please enter Mobile Number Please enter valid Mobile Number

Please enter your Doubt

Thank You for posting your query. Please check your email for further guidance.