R

Ram Sharma • 193.86K Points
Coach 

Q. What is SCHEMABINDING a VIEW?

  • (A) These are used to show database self describing information
  • (B) These types of view are defined by users on a specified schema
  • (C) These are stored only in the Master database
  • (D) Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view
  • Correct Answer - Option(C)
  • Views: 189
  • 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. What is SQL Server 2012 R2 Hard Disk Space Requirement for database engine?

Q. Dynamic Management View is a type of ___________

Q. Which of the following data type is not present in SQL Server?

Q. Point out the correct statement.

Q. SQL server 2005 never combined the administrative feature of query analyzer

Q. Which is not a type of join in T-SQL?

Q. Which of the following feature of SQL Server was used before XML technology for semi structured data?

Q. What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine?

Q. Full form of MOM

Q. Which of the following joins are SQL server default?

Learn All SQL Server MCQs

Question analytics