Where do we generally create INDEX?
Do you know what are pages and extents? : SQL Server Architecture
What is Service Broker in sql server 2012?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What are “lost updates”?
Can primary key be a foreign key?
What is a fill factor?
Explain the database you used in your final year project?
What is the difference between executequery () and executeupdate ()?
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.
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?