Do You Know Views In SQL Server?

5 Questions | Total Attempts: 236

SettingsSettingsSettings
Please wait...
Do You Know Views In SQL Server?

SQL Server View Knowledge Testing


Questions and Answers
  • 1. 
    Can we use Order by in SQL Server Views?
    • A. 

      NO

    • B. 

      YES

    • C. 

      Some Cases Yes

  • 2. 
    Can we create index on View ?
    • A. 

      True

    • B. 

      False

  • 3. 
    In updatable view the number of tables which got affected ?
    • A. 

      Only one base table

    • B. 

      All base table

    • C. 

      No base table

    • D. 

      Update is not possible in view

  • 4. 
    View can reference temporary tables ?
    • A. 

      True

    • B. 

      False

  • 5. 
    Derived columns are updatable in SQL Server View?
    • A. 

      True

    • B. 

      False

Related Topics
Back to Top Back to top