| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Say if we have a table that contains only a single column ,
say OrderID, which has IDENTITY attribute defined on it. So
how can we insert data in this table.
I am reframing my question, that how can we make the table
to increment the column "OrderID" value several times??? | | 3 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | HCL | 3 |
| What is a transaction and what are ACID properties? | | 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 | 2 |
| Explain some DBCC commands? | | 3 |
| About Indexed Views? with example?
plz reply... | | 1 |
| how to implement locking in sql server | Satyam | 1 |
| what is the diffrence between Snap Shot and Transaction
Replication | CSC | 1 |
| What is Deadlock? | Satyam | 2 |
| how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)? | Marlabs | 5 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| What is the difference between having and where clause? | | 3 |
| If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead? | | 1 |
| i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used.. | | 1 |
| can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use? | | 1 |
| What is bit datatype and what's the information that can be
stored inside a bit column? | | 1 |
| what is the main difference between constraints(like
primary key etc..)& joins? | Annik | 2 |
| How can your resolve deadlocks? | IBM | 3 |
| What are three SQL keywords used to change or set someone?s
permissions? | | 3 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 2 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
