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 17294

explain different types of jions with examples briefly?

Zensar,

1 6569

explain different types of jions with examples briefly?

Accenture, Excellence, Zensar,

2 9037

explain different types of jions with examples briefly?

Zensar,

3 10624

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

3 12049

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

HP,

17 50542

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

3 5870

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 8293

Difference between Triggers and Stored Procedure

Claimat, HCL, Protech, Silgate,

23 74562

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 7612

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

1 4649

Advantages and Disadvantages of Cursor?

Polytechnic, TCS, Zenith,

15 101618

Write a query to delete duplicate records in SQL SERVER

Infosys,

36 77957

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

6 9966

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

8 9774

Un-Answered Questions { SQL Server }

How do I find the sql server version?

1098

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1284

How do I start sql server 2017?

1005

Can we shrink data file in sql server?

1116

Why and when do stored procedure recompile?

1046

What is the primary use of the model database?

1143

Why use identity in sql server?

1185

How efficient you are in oracle and SQL server?

1241

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2550

What are the properties of the transaction?

1063

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1205

How raid can influence database performance?

1102

Why we use the openxml clause?

1061

How can I check that whether automatic statistic update is enabled or not?

1105

How to convert character strings into numeric values?

1176

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