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: 181
  • 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. SQL server 2005 never combined the administrative feature of query analyzer

Q. The arranging of data in a logical sequence is called

Q. Syntax for viewing the methods and properties we can pipe our output to Get-Member by ______________

Q. Which of the following is a free database software running free SQL Server technology?

Q. Database software focus on

Q. ______________ returns the rank of rows within the partition of a result set, without any gaps in the ranking.

Q. DML triggers in SQL Server is applicable to _____________

Q. When SQL server is connected with a particular database then this database is called.

Q. Full form of SOAP

Q. Which of the following SQL Server tools is used to enhance data management and governance?

Learn All SQL Server MCQs

Question analytics