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

Is it possible to call a stored procedure within a stored procedure?

975

What function does a database engine serve in the sql server?

1035

Explain the creation and execution of a user-defined function in the sql server?

1051

List the different normalization forms?

979

What are a scheduled jobs?

956

Why is replication required on the sql server?

1061

Which language is supported by sql server?

1013

Which tcl commands are available on the sql server?

1082

List the types of recovery model available in sql server?

928

List the advantages of using stored procedures?

1052

What command is used to delete a table from the database in the sql server and how?

1113

When is update_statistics command used?

1042

What are 3 ways to get a count of the number of records in a table?

1078

What is a user-defined function in the sql server and what is its advantage?

1105

What are the pre-defined functions in the sql server?

1109

Un-Answered Questions { SQL Server }

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1010

What is a partitioned view?

989

Differentiate sql server reporting services vs. Crystal reports?

200

How to create new databases with "create database" statements?

1019

What will happen if a column containing char type data is changed to the nchar data type?

1102

In which files does sql server actually store data?

904

what is normalization? : Sql server database administration

1095

What is nolock hint in sql server 2008

1127

How will you monitor replication latency in transactional replication? : sql server replication

1143

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2093

What is the difference between sdf and mdf?

1300

What is difference between after and before?

1085

what are the core components of SSRS?

129

Explain the use of containers in ssis and also their types?

968

What is normalization? Explain its different types?

1088

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