| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to perfor If the table running time is taking 2hours
and table is having 10 rows in it? | | 1 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| how to count datewise data in sqlserver | IndusInd-Bank | 3 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp; | Infosys | 4 |
| 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 | 1 |
| what is difference between primary key and Unique | | 8 |
| explain different types of jions with examples briefly? | Zensar | 1 |
| which database is best to use in oracle and sql server?
explain reasons? | TCS | 5 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES | Microsoft | 1 |
| what is the difference between Delete and Truncate | Geo-Research-Centre | 3 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| What are defaults? Is there a column to which a default
can't be bound? | | 2 |
| what is bit data type? and what are the information that can
be stored inside a bit column? | | 2 |
| write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
| | 7 |
| Please give me queries for the following
1. To get the count of duplicate records.
2. A query to delete the duplicate records. | 247Customer | 3 |
| What is a deadlock and what is a live lock? How will you go
about resolving deadlocks? | Microsoft | 1 |
| how will u create "n" possible tables in sql...
| Oracle | 1 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
