MSSQL DATABASE ADMINISTRATOR INTERVIEW PREPARATION
1. What is default schema in sqlserver 2005?
Ans: DBO
2. How to access table from different server, what is the syntax and all?
Ans: Select * from Linkedservername.Databasename.dbo.Tablename
3. What is mirroring?
Ans : In database mirroring, an originating SQL Server 2005 instance continuously sends a database's transaction log records to a copy of the database on another standby SQL Server instance. The originating database and server have the role of principal, and the receiving database and server have the role of mirror. The principal and mirror servers must be separate instances of SQL Server 2005/later versions.
4. What is Checkpoint?
Ans: When we done operation on SQL SERVER that is not committed directly to the database. All operation must be logged in to Buffer pages then go to Transaction Log files after that they should be done on to the main database. Checkpoint are the point which alert Sql Server to save all the data to main database if no check point is there then log files get full we can use Checkpoint command to commit all data in the SQL SERVER. When we stop the SQL Server it will take long time because Checkpoint is also fired.
5. What are linked servers?
Ans : Linked Servers are used to fetch data from another server (from Remote Servers )
6. What is an index?
Ans : The index provides a fast way to look up data based on the values within those columns.
7. What are the different types of backups?
Ans : Full Database Backup, Differential Database Backup,Transactional log Backup,Partial Database backup,Differential partial Database Backup,File and FileGroup backup,Copy Only Database backup.
8. What is u r backup strategy?
Ans : Depends upon your company policy
9. How to access u r server?
Ans : We access through Windows Authentication mode. We also can use SQL Authentication mode but it is not secure.
10. What are the critical services that are running in IIS?
Ans :
1. What is default schema in sqlserver 2005?
Ans: DBO
2. How to access table from different server, what is the syntax and all?
Ans: Select * from Linkedservername.Databasename.dbo.Tablename
3. What is mirroring?
Ans : In database mirroring, an originating SQL Server 2005 instance continuously sends a database's transaction log records to a copy of the database on another standby SQL Server instance. The originating database and server have the role of principal, and the receiving database and server have the role of mirror. The principal and mirror servers must be separate instances of SQL Server 2005/later versions.
4. What is Checkpoint?
Ans: When we done operation on SQL SERVER that is not committed directly to the database. All operation must be logged in to Buffer pages then go to Transaction Log files after that they should be done on to the main database. Checkpoint are the point which alert Sql Server to save all the data to main database if no check point is there then log files get full we can use Checkpoint command to commit all data in the SQL SERVER. When we stop the SQL Server it will take long time because Checkpoint is also fired.
5. What are linked servers?
Ans : Linked Servers are used to fetch data from another server (from Remote Servers )
6. What is an index?
Ans : The index provides a fast way to look up data based on the values within those columns.
7. What are the different types of backups?
Ans : Full Database Backup, Differential Database Backup,Transactional log Backup,Partial Database backup,Differential partial Database Backup,File and FileGroup backup,Copy Only Database backup.
8. What is u r backup strategy?
Ans : Depends upon your company policy
9. How to access u r server?
Ans : We access through Windows Authentication mode. We also can use SQL Authentication mode but it is not secure.
10. What are the critical services that are running in IIS?
Ans :
