1.what are diff types of joins , and explain diff between cross join and full outer join
2.diff types of views
3. Diff types of index
4. What is diff b/w stores procedure and function procedure
5.diff between double and int in SQL
6.diff between char and varchar in SQL.
7.Oracle or SQL whice you will preferred and why.


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

Post New Answer

More SQL Server Interview Questions

Ms sql server index?

0 Answers  


What is 'Join' and explain its various types.

0 Answers   Genpact,


What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,


How to copy data from one table to another table?

0 Answers  


What do you understand by integration services in sql server?

0 Answers  






What is DCL?

0 Answers  


hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,


How to delete an existing database user?

0 Answers  


What are the advantages of policy management?

0 Answers  


Can we drop user if user mapped to any logins

1 Answers  


How can I know what locks are running on which resource?

0 Answers  


Explain Active/Active and Active/Passive cluster configurations

2 Answers  


Categories