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,

407

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

TCS,

446

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

362




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,

425

What is Lock table in SQL?

Wipro,

327

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

Nagarro,

134

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

Nagarro,

206

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

Nagarro,

226




Delete duplicate rows without using rowid.

Nagarro,

243

how to find 6th highest salary

Chetak Logistics,

209


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

925


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

446


what exactly sql injuction.how to overcome.....

1352


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

753


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1629






sql database suspect We have a sql database that is showing as suspect. How can we recover?

766


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

226


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4845


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2731


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1335


query processing

1056


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

831


optimization techinques

1412


what is the Ticketing tool used in Wipro technologies at Bangalore...???

5219


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

923