| 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 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 11 |
| How to create logins using windows Authentication mode? | | 2 |
| What are Magic Table? | Evalueserve | 16 |
| What are the new features in SQL Server 2005? | Emphasis | 2 |
| Which virtual table does a trigger use? | | 3 |
| What is Peer to peer Replication? | HCL | 1 |
| how to generate XML out of QUERY? | McAfee | 1 |
| what are file groups? | Evalueserve | 3 |
| What is a trigger? | | 6 |
| What is SQL Profiler what is the use of it? | 247Customer | 2 |
| what is extended StoreProcedure ?
| Satyam | 3 |
| Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database? | | 4 |
| How the data stores in a page? | | 1 |
| Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example. | | 1 |
| how to delete duplicate rows from table | CSC | 9 |
| Can we create clustered index on non primary key column | CTS | 14 |
| 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 |
| 1.Describe way(s) to tune the SQL table in order to
optimize performance.
2. Explain SQL Injection and how can you prevent them? | Techno-Solutions | 1 |
| What are mdf,ndf,ldf files and how to see the data in those
files? | Accenture | 5 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
