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

How to retrieve error messages using mssql_get_last_message()?

1054

What are user defined functions in ms sql server?

999

Can binary strings be converted into numeric or float data types?

1033

Can you use order by when defining a view?

977

What are commonly used odbc functions in php?

1014

What are views in ms sql server?

1084

How to enter unicode character string literals in ms sql server?

1073

How to create database with physical files specified in ms sql server?

993

How to create an index on an existing table in ms sql server?

980

What are the requirements on sql server network connections?

993

How to verify the port number of the sql server?

1162

What are date and time data types in ms sql server?

1092

How to execute a sql statement using odbc_exec()?

1140

What is a database table?

970

How to create a stored procedure with a statement block in ms sql server?

1070

Un-Answered Questions { SQL Server }

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2762

What is the full meaning of dml?

952

Explain where clause?

985

What is autocommit mode in sql server?

1174

What is the largest component inside a field?

1127

Do you know what are the properties of the relational tables?

1031

What is a group function explain with an example?

988

What is the temp table?

922

What is query parameter in ssrs?

160

How many types of schemas are there?

1041

Explain how you can deploy an SSRS report?

150

What are page splits? : SQL Server Architecture

989

What different steps will a sql server developer take to secure sql server?

993

What is self join in sql server joins?

1059

What do we have to check in database testing?

1019

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