| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Which TCP/IP port does SQL Server run on? | | 2 |
| What is Deadlock? | Satyam | 3 |
| which one will take 1st priority in case of insert statement
and select statement??? | | 2 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| How do you fine the performance tunning? | Accenture | 2 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 4 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 4 |
| How to perfor If the table running time is taking 2hours
and table is having 10 rows in it? | | 1 |
| hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
| | 2 |
| How to handle errors in Stored Procedures. I want to display
a message to the user in the .aspx page that is calling a
stored procedure in it's code behind. please help me. | 247Customer | 2 |
| What is a view? is View updatable? | IBM | 12 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 11 |
| How to Get the last identity value used | | 4 |
| How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all) | McAfee | 5 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| What are the different types of replication? How are they used? | | 3 |
| Difference between Function and Procedure-in general? | | 4 |
| Explain the architecture of SQL Server? | | 2 |
| How the data stores in a page? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |