SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What encryption security is available in sql azure?

101

Explain security with sql azure?

186

Can I use sql azure as a backup with log shipping or database mirroring?

156

What is it’s similarity with sql server?

160

What are horizontal and vertical scaling?

172

What are rest-style architecture's?

173

What is the data tier application?

169

How do you handle datasets larger than 50 gb?

164

What is the difference in accessing db between sql server vs sql azure?

174

How many databases can we create in a single server?

209

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

187

What is sql azure database?

206

How do you migrate data from mssql server to azure?

167

Where actually sql azure database is hosted?

167

How many servers can we create in a single subscription?

162

Un-Answered Questions { SQL Server }

Can you explain what are commit and rollback in sql?

986

what types of replication are supported in sql server? : Sql server database administration

1134

Can We Use Data-grids For Our Report In Ssrs?

188

What is shared lock?

949

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1211

What are security principals used in sql server 2005?

1040

What is stored in the mssqlsystemresource database? : sql server database administration

1081

Explain the commands in sql server?

1098

What are the commands used in DCL?

1086

Tell me what is log shipping?

1034

How is foreign key related to primary key?

1015

What is extended stored procedures?

1030

Which command is used for user defined error messages?

1106

Explain sql server authentication modes?

1190

What is optimization and its types?

1043

For More Un-Answered { SQL Server } Questions Click Here