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

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  


What is cursors?

0 Answers   NA,


How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,


What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  


What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  






How to Insert multiple rows with a single insert statement?

0 Answers  


How can we check the sql server version?

0 Answers  


select names starts with a,b,c

8 Answers   Scope International,


What is the security model used in sql server 2005?

0 Answers  


How to start and end transact-sql statements?

0 Answers  


Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,


How to send email from database?

0 Answers  


Categories