What is difference between materialized view and view?


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

Post New Answer

More SQL Server Interview Questions

Name the different type of indexes in sql?

0 Answers  


Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  


What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,


Which are the important points to note when multilanguage data is stored in a table?

0 Answers  


I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,






what is sql injection?

2 Answers  


how insert selected column only ?

3 Answers   Robert Half,


What are key constraints?

0 Answers  


What is the difference between a local and a global variable?

5 Answers  


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  


Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  


What is for xml in sql server?

0 Answers  


Categories