| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | | 1 |
| What are functions | | 3 |
| I have a table EMP in which the values will be like this
EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30
I want to delete only duplicate Rows. After Delete I want
the output like this
EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30
| DELL | 10 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| 9. Write a query to list a new column with the
difference in temp of the cities Delhi and Mumbai, Mumbai
and Jammu and soon. Consider the following table :
City_id City Temp.
1 delhi 40
2 Mumbai 35
3 Jammu 32
4 Pune 18
| | 2 |
| How many max. conditions can b written under the WHERE
clause?
Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))????? | SAP-Labs | 2 |
| Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE) | | 1 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | | 2 |
| 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.. | | 2 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| What is an execution plan? When would you use it? How would
you view the execution plan? | | 1 |
| What is the difference between windows authentication and
sql server authentication | HCL | 4 |
| What is Covering Indexes?
Plz explain with example | | 2 |
| What are explicit and implicit transactions? | | 2 |
| How would you Update the rows which are divisible by 10,
given a set of numbers in column? | | 1 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better? | | 1 |
| what is physical sort data and logical sort data in index? | | 2 |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 4 |
| I have to display ten columns values from diffrent ten
tables.
how many joins are require? | HCL | 8 |
| create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end
while executeing the above code it shows error
like '#temp already exist' .why it shows an error? | IBM | 5 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
