⟩ What is Forward – only cursors / Read only cursor?
Forward – only cursors / Read only cursor: These are the fastest of the cursors and cannot be updated. They cannot be created on query that returns only read only columns.
Forward – only cursors / Read only cursor: These are the fastest of the cursors and cannot be updated. They cannot be created on query that returns only read only columns.
CREATE INDEX myIndex ON myTable(myColumn)What type of Index will get created after executing the above statement?
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
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 are defaults? Is there a column to which a default can't be bound?
How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is database replication? What are the different types of replication you can set up in SQL Server?
What are different types of BACKUPs available in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is the difference between DELETE TABLE and TRUNCATE TABLE commands?
What is a major difference between SQL Server 6.5 and 7.0 platform wise?
What is new philosophy for database devises for SQL Server 7.0?