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

how can i lock the column in the table

Accenture,

2 7035

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 4948

how to get the salary in descending order with out using the keyword desc in sql

Ramco,

5 10396

difference between truncate, delete aur drop?

2 5239

how many no of arguments can be passed in procedures and functions

ABC,

1 5550

how can u get last observation in an unknown dataset ?

Genpact,

2431

What is stored procedure in SQL..??

2 4892

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 4105

whats the maximum size of view state??

2188

How can u get the number of pupils connecting the database?

Cap Gemini,

1 5683

How to a Query to copy data from on table to another table.

Cap Gemini,

6 9023

What is Schema in Database?

Cap Gemini,

1 5522

What is storeprocedure?Tell me synatx for how to write stored procedure.

Cap Gemini,

1 5055

What is index?

Cap Gemini,

1 4608

Tell me about Triggers?

Cap Gemini,

3 7221

Un-Answered Questions { SQL Server }

What are the different authentication modes in sql server? How can it be changed?

1080

How much does sql server 2016 cost?

1054

How to update muliple row in single query?

1049

How many cores do I need for sql server 2016?

890

application server is slow what may be the problem

2214

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1023

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2514

What is the use of @@spid?

995

How to drop existing views from a database in ms sql server?

1099

What is the difference between local and global temporary tables?

1134

What are the main differences between #temp tables and @table variables and which one is preferred?

1077

How to execute the cursor queries with "open" statements?

1175

Can we do dml on views?

950

What sql server means?

962

What is snapshot replication?

1047

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