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 the joins,primary key,foriegn key, candidate key, super key and expain them?

Polaris,

6 17264

explain different types of jions with examples briefly?

Zensar,

1 6560

explain different types of jions with examples briefly?

Accenture, Excellence, Zensar,

2 9025

explain different types of jions with examples briefly?

Zensar,

3 10613

can we call functions from stored procedure in SQL Server 2005 ? How?

3 12040

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

HP,

17 50489

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 5844

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 8274

Difference between Triggers and Stored Procedure

Claimat, HCL, Protech, Silgate,

23 74491

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 7590

How to list all tables having unique constraints in any of the columns in a database.

1 4643

Advantages and Disadvantages of Cursor?

Polytechnic, TCS, Zenith,

15 101531

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 77760

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 9936

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 9725

Un-Answered Questions { SQL Server }

How many types of functions are there in sql server?

1005

Explain about thread and memory management process of SQL?

1036

You want to implement the one-to-many relationship while designing tables. How would you do it?

1009

Explain what is the main purpose of having conversation group?

996

What is sql server query analyzer?

1110

How do you debug a procedure in sql server?

1009

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

1039

How to encrypt Strored Procedure in SQL SERVER?

1241

why would you call update statistics? : Sql server database administration

1167

What is index, cluster index and nonclustered index?

1063

Do you know what are the restrictions that views have to follow?

1141

What is code near application topology?

285

What is the report builder?

145

What is the fastest way to permanently delete a 1 million row table named customers?

1348

What are the steps to process a single select statement?

998

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