R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following is not a limitation of view?

  • (A) Adding Column is Expensive by Joining Table Outside View
  • (B) Cross Database Queries Not Allowed in Indexed View
  • (C) Index Created on View Used Often
  • (D) ORDER BY Does Not Work
  • Correct Answer - Option(C)
  • Views: 177
  • Filed under category SQL Server

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on SQL Server

Q. MS SQL Server developed by?

Q. Which of the following lies between the host machine (Windows OS) and SQL Server?

Q. With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

Q. Which of the following is not a feature of SQL Server 2008 R2 Enterprise?

Q. Which of the following is not a aggregate function ?

Q. Which of the stored procedure is used to test the SQL injection attack?

Q. he SQL server data platform include the tools

Q. Rollback operations are also logged

Q. An index can be defined for a single column

Q. In different types of database, which work, is done?

Learn All SQL Server MCQs

Question analytics