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?

236

What are sub reports?

208

How to create sub reports?

251

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

1017

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

1094

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

1007

which table keeps the locking information? : Sql server administration

1139

what is a mixed extent? : Sql server administration

1172

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

1034

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

1172

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

1098

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

1061

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

1073

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

1154

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

1090

Un-Answered Questions { SQL Server }

State a few properties of relational databases?

1177

What to check if a User database is locked?

1112

Tell me what is the difference between locking and multi-versioning?

1082

Why use identity in sql server?

1168

Explain the database you used in your final year project?

1099

Why do you want to join software field as you have done your BE in Electronics?

2195

In how many ways you can invoke ssrs reports?

147

What is the difference between ddl and dml?

1097

What are the advantages of log shipping?

1039

What is sql server programming?

1090

Explain time data type in sal server 2008?

966

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

1000

Is truncate a dml command?

996

Name the different type of indexes in sql?

1012

What is coalesce in sql server?

1099

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