Do You Know Views In SQL Server?

5 Questions | By SQLSERVERQUEST | Updated: Mar 20, 2022 | Attempts: 267

Share

Do You Know Views In SQL Server? - Quiz

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

Featured Quizzes

Quiz: Does That Guy Like Me? Quiz: Does That Guy Like Me?

Am I Handsome? Quiz Am I Handsome? Quiz

Quiz: Which Phobia Do I Have? Quiz: Which Phobia Do I Have?

Quiz: Which movie character are you? Quiz: Which movie character are you?

Jojo's Bizarre Adventure: Which Stand do you have? Jojo's Bizarre Adventure: Which Stand do you have?

Where Should I Live Quiz Where Should I Live Quiz

Popular Topics

Back to Top

Back to top

Back to Top

Back to top

×

Wait!
Here's an interesting quiz for you.

SQL server quiz questions and answers