DO YOU KNOW VIEWS IN SQL SERVER?

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By SQLSERVERQUEST

SQLSERVERQUEST

Community Contributor

Quizzes Created: 1 | Total Attempts: 286

| Attempts: 286

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/5 Questions

Can we use Order by in SQL Server Views?
- NO
- YES
- Some Cases Yes

About This Quiz

Explore the functionalities of SQL Server Views with this quiz. It tests knowledge on view updatability, indexing, and order handling. Ideal for learners aiming to enhance their SQL Server skills.

2.

Can we create index on View ?
- True
- False
Correct Answer

A. True

Explanation

Yes, we can create an index on a view. A view is a virtual table that is based on the result of a query. While the view itself does not store any data, it can be used to simplify complex queries or provide a customized view of the data. By creating an index on a view, we can improve the performance of queries that involve the view by allowing the database to retrieve the data more efficiently.

Rate this question:
3.

In updatable view the number of tables which got affected ?
- Only one base table
- All base table
- No base table
- Update is not possible in view
Correct Answer

A. Only one base table

Explanation

In an updatable view, only one base table is affected. This means that any updates made to the view will only modify the data in one specific table, rather than affecting multiple tables. This is because an updatable view is a virtual table that is derived from one or more base tables, and any changes made to the view are ultimately reflected in the corresponding base table. Therefore, the correct answer is "only one base table".

Rate this question:
4.

View can reference temporary tables ?
- True
- False
Correct Answer

A. False

Explanation

Views cannot reference temporary tables. Temporary tables are created and used within a session and are not accessible outside of that session. Views, on the other hand, are stored database objects that can be accessed by multiple sessions. Therefore, views cannot reference temporary tables.

Rate this question:

1
5.

Derived columns are updatable in SQL Server View?
- True
- False
Correct Answer

A. False

Explanation

Derived columns are not updatable in SQL Server View. A derived column is a column that is calculated based on other columns in the view. Since it is a calculated column, it does not have a physical existence in the underlying table and therefore cannot be updated directly. To update the value of a derived column, you would need to update the values of the underlying columns that it is based on.

Rate this question:

Quiz Review Timeline (Updated): Mar 20, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 20, 2023

Quiz Edited by
ProProfs Editorial Team
Dec 03, 2014

Quiz Created by
SQLSERVERQUEST

Do You Know Views In SQL Server?

Can we use Order by in SQL Server Views?

Quiz Preview

Can we create index on View ?

In updatable view the number of tables which got affected ?

View can reference temporary tables ?

Derived columns are updatable in SQL Server View?