Tell me what is difference between view and materialized view?

Question Posted / preeti devi

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

How to swap the data of two columns in a table. both the columns containing varchar values.

What are the differences between stored procedure and view in sql server?

If we use where clause in the left outer join then how the query would behave/act?

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

How to create user defined functions with parameters?

What are trace flags and mention a few common trace flags used with sql server?

What is the difference between lock, block and deadlock? : sql server database administration

According to you what goes into making the best database administrator? : sql server database administration

What is cdc in sql server?

What is an execution plan? When would you use it? How would you view the execution plan?

Explain the benefits of user-defined functions?

What is referential integrity? What are the advantages of it?

For more SQL Server Interview Questions Click Here