| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| Different Types of Functions ?
| Satyam | 2 |
| What is a NOLOCK? | | 3 |
| What is ACID Property of Transaction? | | 4 |
| Why we need a group by clause? | | 3 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 16 |
| 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 |
| Difference between sql server 2000 and sql server 2005?
| Satyam | 4 |
| What is the difference between DTS and SSIS? | Allianz | 3 |
| 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 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 4 |
| 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 | 8 |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 2 |
| how to change column into row in sql | ESS | 2 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| How To Change Column Ordinal Position in SQL Server 2005
using Query i.e I Want To Add Column at Particular Ordinal
Position in SQL Server 2005 | | 2 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| when inserting to a table how many rows will be effected
using triggers
| | 1 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |