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? and what are the different types of cursor?
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.
Implicit cursors
Explicit cursors
Paramaeteried cursors
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.
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? and what are the different types of cursor?
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.
Implicit cursors
Explicit cursors
Paramaeteried cursors
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.
No comments:
Post a Comment