ASP.NET 3.5 Interview questions

·         Differences Between SQL Server 7 And 2000   1)    The level of locks required by SQL Server 2000 Database Consistency Checker (DBCC) statements is much lower than in SQL Server 7. SQL Server 2000 DBCC statements can now be run concurrently with data modification statements, significantly lowering their impact on users who are working in the database.   2)    A computer can run multiple instances of SQL Server 2000. A computer can run only one instance of SQL Server 7.0 or earlier, although in some cases it can also run multiple instances of SQL Server 2000.   ·          Up to 16 simultaneous instances of SQL Server can run on a single computer.   ·         In a File-Server database system, the data is stored in a file. Applications using that database system have direct access to the file for operations. In a cl...