SQL Server Interview Question and Answers

11. What are the different types of BACKUPs avaialabe in SQL Server 2005?
    In SQL Server 2005 Backup Types are
  • Full
  • Transaction Log
  • Differential
  • Partial
  • Differential Partial
  • File and Filegroup
  • Copy Only Database Backups.
12. What are Data files?
  This is the physical storage for all of the data on disk. Pages are read into the buffer cache when users request data for viewing or modification. After data has been modified in memory (the buffer cache), it is written back to the data file during the checkpoint process.
13. Define Primary Key?
  • The primary key is the columns used to uniquely identify each row of a table.
  • A table can have only one primary key.
  • No primary key value can appear in more than one row in the table.
14. What is cursors?
  Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time.
15. What is SQL Profiler?
  SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save data about each event to a file or SQL Server table to analyze later.

Page 3 of 15