TCS:
What is default schema in sqlserver 2005?
Ans: DBO
How to access table from different server, what is the syntax and all?
Ans: Select * from Linkedservername.Databasename.dbo.Tablename
What is mirroring?
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.
What are linked servers?
What is an index?
What are the different types of backups?
What is u r backup strategy?
How to access u r server?
What are the critical services that are running in iis ?
No comments:
Post a Comment