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 17029

explain different types of jions with examples briefly?

Zensar,

1 6472

explain different types of jions with examples briefly?

Accenture, Excellence, Zensar,

2 8903

explain different types of jions with examples briefly?

Zensar,

3 10465

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

3 11911

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

HP,

17 49889

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

3 5702

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 8068

Difference between Triggers and Stored Procedure

Claimat, HCL, Protech, Silgate,

23 73583

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 7382

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

1 4561

Advantages and Disadvantages of Cursor?

Polytechnic, TCS, Zenith,

15 100877

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 76551

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

6 9682

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

8 9455

Un-Answered Questions { SQL Server }

How do I view a stored procedure in sql server query?

929

What is a rollup clause?

968

Can foreign key be deleted?

923

What are the advantages of policy management?

997

Tell me what is the significance of null value and why should we avoid permitting null values?

984

What is Federation and Federation Member?

Explain transaction server implicit?

983

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

958

Explain primary key?

965

How to encrypt data between dialogs?

1107

Explain what stored procedure sp_replcounters is used for? : sql server replication

1518

What are different types of roles provided by ssrs?

150

What is difference between rownum and rowid?

902

Explain the difference between delete,drop and truncate in SQL Server?

1099

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

967

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