SQL SERVER DBA -INTERVIEW QUESTIONS

SQL Server Architecture

Pre requirement for installing SQL server

Where you check the error message while installation is failed

Default protocol used in SQL Server

Pre requirement of operating system before installing?

Pre requirement of SQL Server version is needed to upgrade SQL Server 2005

Difference between Standard and Enterprise

Different types of editions in SQL Server?

Use of DBCC

How to find SPID

How to find the user how are all connected to the SQL Server

Types of Backup

Use of diff Backup

Use of Log backup

Scenario —- Backup & restore

Detach\Attach database

Scenario —– A\D Database

About Log shipping

Types of standby server used in LS

Use of that standby server

Scenario —– LS

How to monitor Log Shipping?

How you perform switching between the servers?

How you transfer the user from Prim to Sec in LS?

About Replication

Pear-Pear Replication

How to monitor Replication

How to perform Job Scheduling

Who is Operator?

What happen when schedule fail?

What are the options available in doing scheduling?

Use of sysprocess

How to find blocking Process

How you find the Physical location of Data and Log file?

About Index

When you perform Defragmentation?

Which command is used to find Fragmentation?

Use of sp_who and sp_who2

Have you know about xp_cmdshell

Where you configure this?

About System Databases?

Scenario — I create table in Model, and then I create new database what happen in new database?

What should be in Resource database?

In default how many system databases in 2000, 2005 and 2008

What permission need to access SQL server Agent

How you configure Database Mail?