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

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

Aptroid,

1594

what is checksum in sql server.........???

TCS,

1686

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1514

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

United Healthcare,

1682

What is Lock table in SQL?

Wipro,

1469

Can we call a function that has out parameter in select statement

Nagarro,

1360

Call by value and call by reference in procedure and function, with NOCOPY.

Nagarro,

1306

If we delete pack Spec what will be the status of pack Body ?

Nagarro,

1476

Delete duplicate rows without using rowid.

Nagarro,

1532

how to find 6th highest salary

Chetak Logistics,

1528

Explain few examples of stored procedure over triggers?

ADITI,

1041

What are the different types of backups that exist?

ADITI,

1167

What can be used instead of trigger?

ADITI,

1156

What does asynchronous call backs means?

Alcatel-Lucent,

1157

How do you implement session management in SQL Server mode?

Cap Gemini,

1100

Un-Answered Questions { SQL Server }

What are the difficulties faced in cube development? : sql server analysis services, ssas

1041

Why is sql server log file full?

1034

What is the simplest way to create a new database in ms sql server?

1010

What is 1nf normalization form?

1034

What is the default schema of your login session in ms sql server?

1049

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

960

What is the maximum size of a row in sql server?

967

What are the diifferences between the ms sql server vs mysql?

1175

Explain active/passive and active/active cluster configurations?

1059

How to define and use table alias names in ms sql server?

1132

Tell me what is log shipping?

977

What is sql injection and why is it a problem? : sql server security

1132

What is an index in sql?

1006

What is Federation Root Database?

104

Do you know the capabilities of cursors?

1150

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