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,

1042

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,

1101

Un-Answered Questions { SQL Server }

Describe in brief databases and sql server databases architecture.

1008

Why I am getting this error when renaming a database in ms sql server?

1052

What is linked report?

131

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

976

What is a covering index?

983

Do you know what are the differences between lost updates and uncommitted dependencies?

1081

how many clustered indexes can be created on a table? : Sql server database administration

1152

What is a rollup clause?

968

What causes index fragmentation?

997

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

979

How global temporary tables are represented and its scope?

977

What are the differences between local and global temporary tables?

1082

Can we deploy SSRS reports on our personal website?

168

What is rs.exe utility?

156

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