| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the types of indexes available with SQL Server? | | 2 |
| Explain the new features of SQL server 2000? | | 1 |
| What is the system function to get the current user's user
id? | TCS | 3 |
| What is transaction ? Give me one example. | Melstar | 7 |
| What are the four main query statements? | | 3 |
| Can you link only other SQL Servers or any database servers
such as Oracle? | | 1 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query? | | 2 |
| What is Peer to peer Replication? | HCL | 1 |
| Difference between Cluster and Non-cluster index? | Oracle | 9 |
| there is a table having two columns no and name
and the data is
1 A
2 B
3 C
write a query that will result a horizontal output
A,B,C
| vsworx | 7 |
| Which is better in performance - CONSTRAINT or TRIGGER over
a column which restricts say an input of particular value
in a column of a table? | Accenture | 3 |
| Why we need a group by clause? | | 3 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| what is curser. | | 8 |
| what are the joins,primary key,foriegn key, candidate key,
super key and expain them? | Polaris | 2 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 2 |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| hi,
i have a table called names and field name
select * from names
name
a
b
c
d
i want to display like this
name
a,b,c,d
how it is possible
Regards
Baiju | | 3 |
| What is Covering Indexes?
Plz explain with example | | 2 |
| |
| For more SQL Server Interview Questions Click Here |