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
S
SQLSERVERQUEST
Community Contributor
Quizzes Created: 1 | Total Attempts: 286
| Attempts: 286
SettingsSettings
Please wait...
  • 1/5 Questions

    Can we create index on View ?

    • True
    • False
Please wait...
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.

Do You Know Views In SQL Server? - Quiz

Quiz Preview

  • 2. 

    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:

  • 3. 

    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:

  • 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:

  • 5. 

    Can we use Order by in SQL Server Views?

    • NO

    • YES

    • Some Cases Yes

    Correct Answer
    A. Some Cases Yes
    Explanation
    Order by in view in SQL Server can be used with top operator only.

    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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.