| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the purpose of using COLLATE in a query? | | 1 |
| What is the advantage of specifying WITH GRANT OPTION in
the GRANT command? | | 2 |
| Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take? | | 1 |
| What is a function? Give some example? | | 2 |
| How to select nth record from a table? | DELL | 9 |
| what is Archive old data? | | 1 |
| Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000? | Infosys | 1 |
| How to perfor If the table running time is taking 2hours
and table is having 10 rows in it? | | 1 |
| What is the system function to get the current user's user
id? | TCS | 3 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 3 |
| Plz tell about backup&recovery? | | 2 |
| What's the purpose of Stored Procedure? | Wipro | 4 |
| How to find the date and time of last updated table?
| Teledata | 4 |
| Hello all,
I have data like :-
year amt
2004 10
2005 20
2006 30
Now i want output as:-
2004 2005 2006
10 30 60
but i have to use here group by on year.So, i need a single
query within that i can find.
| | 2 |
| What is Peer to peer Replication? | HCL | 1 |
| What are Sql Reporting Services and analysis services? Can
u Explain | | 1 |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| I am having table Title with TITLE id,Author ID, Publiser
ID , table AUTHOR with Author ID, Author Name, table
PUBLISER with Pub ID, Pub name Here hot to find out the
publiser id who have relesed the books of patriticular
author? | | 3 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
