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

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

Aviva,

1 3695

how to generate XML out of QUERY?

McAfee,

1 5270

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

Infosys, McAfee,

5 11173

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

Intelenet,

8 33141

hi i gone though satyam interview. what is Acid Properties?

Satyam,

2 6054

what are batch in sql server?

Satyam,

2 10213

Difference Between varchar and nvarchar datatype?

Satyam,

3 14390

Difference between sql server 2000 and sql server 2005?

Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

11 53511

what is normalization? what is denormalization?

Satyam,

9 35462

what is extended StoreProcedure ?

Satyam,

3 6961

Different Types of Functions ?

Satyam,

2 12853

CLR Integration ? what is Notification services ?

HCL, Satyam,

1 5417

what is replication? where do u use Go Keyword?

Satyam,

1 4996

how do u do Performance tunning ?

Infodat Technologies, Satyam,

1 5156

How to find the date and time of last updated table?

3 9459

Un-Answered Questions { SQL Server }

What is log in sql server?

1207

How to insert data with null values?

1082

How to throw custom exception in Stored Procedure?

1097

How to implement service broker?

1074

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1046

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

2540

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

1001

What command would you use to create an index?

1114

How do I uninstall sql server 2014?

985

what is normalization? : Sql server database administration

1164

What is checkpoint process in the sql server?

1074

What is the difference between seek predicate and predicate?

1113

Explain about temporary stored procedure?

1101

What is lookup override?

1083

Difference between 2NF &3NF ?

1132

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