1.What is ACID property?
Atomicity-All or none
Consistency-Make sure that transaction never leaves database in an inconsistent state.
Isolation-keeps transactions separated from each other until they’re finished.
Durability-guarantees that the database will keep track of pending changes in such a way that the server can recover from an abnormal termination.
2.What are the versions of SQL Server and its latest Service pack?
SQL Server 2000 (SP4),2005(SP4),2008(SP3),2008 R2(SP2),2012 (SP1)
3.What is the default port for SQL Server?
4.What are recovery modes of SQL Server?
5.What are the types of backup in SQL Server?
6.Difference between SQL Server 2000,2005 & 2008?
Please refer below site
7.How you check the version of SQL Server?
Select @@Version . In 2000 this will give only windows Service Pack information
8.How to take the backup in sql server?
Backup database [rkn] to disk=’path’
9.What is the difference between login and a user?
Login -server Level
10.what are the system databases in sql server 2005 and its use?
Master ——– Logical repository for the system objects residing in the sys schema from SQL Server 2005 onwards In SQL Server 2000 and previous editions of SQL Server, the Master database physically stored all of the system objects.
Model —– Works as template for all user database.
MSDB —- Contains information about all jobs,dts packages,sql server agent configuration.
Tempdb ——- Temporary database to store temporary tables (#temptable or ##temptale), table variables, cursors, work tables, row versioning, create or rebuild indexes sorted in TempDB, etc. Reinitialised when SQL Server restarts.
Resource ——— This is a hidden database responsible for physically storing all of the SQL Server 2005 system objects
11.What are the main types of indexes in SQL Server?
Clustered & Nonclustered
These are very basic level interview questions,feel free ask any questions and I am always ready to help you.
I recommend everyone to always go through msdn.