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 are cascading parameters in ssrs reports?

229

What are sub reports?

201

How to create sub reports?

242

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

965

what is the primary use of the model database? : Sql server administration

1044

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

951

which table keeps the locking information? : Sql server administration

1075

what is a mixed extent? : Sql server administration

1096

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

976

where can you add custom error messages to sql server? : Sql server administration

1111

how you can get the list of largest tables in a database? : Sql server administration

1045

can a database be shrunk with users active? : Sql server administration

1003

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1023

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1072

How you can get a list of all the table constraints in a database? : Sql server administration

1024

Un-Answered Questions { SQL Server }

Explain what is raid and what are different types of raid levels?

1018

What are data resources?

907

What happens if null values are involved in datetime operations?

969

How to handle error or exception in sql?

980

How to delete duplicate rows in sql server?

1100

In how many ways you can invoke ssrs reports?

137

What do you understand by recursive stored procedure?

924

What happens if null values are involved in bitwise operations?

1015

What is BCNF? How is it better than 2NF & 3NF?

1013

What is Sqlpaging in SqlServer 2005 ?

1062

Explain the database you used in your final year project?

1033

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1507

What is stretch database in sql server?

1064

Can sql server 2016 run on windows 7?

911

How to use column default values in insert statements in ms sql server?

1026

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