| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| i have a table student like
sname
-----
ram
ram
ram
raj
raj
raj
i need the output like
sname
-----
ram
raj
ram
raj
ram
raj
| IBM | 7 |
| can you any body tell me the how to decrease the logfile | | 4 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| What about UPDATESTATISTICS ? | Intelligroup | 2 |
| What is the difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| how to connect sybase to sql server 2005?. | ABC | 1 |
| what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha | | 4 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| table:employee
EID ENAME MID(manager ids)
101 rama null
102 sita 101
103 siva 101
104 ganesh 103
. . .
. . .
for 103 ID the manager ID is 101(RAMA) and for 104 manager
is SIVA
if i give employee id (EID) you have to tell the manager for
that EID write query?
eample:if i give 102 .The query output should be manager for
102 ID that it should print RAMA as output
| | 5 |
| Explain DBMS, RDBMS? | | 4 |
| A table contains list of customers and his city with other
details. Each customer has a unique number and the table
consists millions of data. Query is: I want to retrieve 10
customers from each city, no script, only from single query? | Infosys | 3 |
| i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.
so i want only duplicates no.
| iFlex | 2 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| How to delete an attribute from the emp table | | 3 |
| How do you know which index a table is using? | | 4 |
| Anyone please explain me the concept of Serialization? | | 3 |
| can you any body tell me while running BCP Out in instance
in sql server 2000 is getting error.
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.?
| | 1 |
| What are the different types of replication? How are they used? | | 3 |
| what is index seek and index scan? | | 2 |
| can primery key be a non clustered index? | | 8 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
