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

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,


What are the differences between triggers and stored procedures?

0 Answers  


How to know whether our backup is succesfully taken?

1 Answers  


If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,


What is difference between count (*) and count 1?

0 Answers  






What is meant by indexing files?

0 Answers  


Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  


What is the security principal at the database level that represents your session?

0 Answers  


What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  


How to use order by with union operators in ms sql server?

0 Answers  


Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,


SQL Server Architecture ?

0 Answers   IBM, Sapient,


Categories