| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement | | 2 |
| 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 the use of placing primary key and foreign key
constrains on columns. | Value-Labs | 2 |
| event classes in sql server | Accenture | 1 |
| What are different types of Keys? Please explain all the
keys with a suitable example. | | 2 |
| How to create logins using windows Authentication mode? | | 2 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| what is trigger | NIIT | 1 |
| What is a stored procedure? | | 3 |
| What is normalization in Database ? | | 4 |
| Wht is the difference between stored procedure and trigger | TCS | 4 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | | 2 |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| What is the difference between a local and a global variable? | | 3 |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 2 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 9 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| Can we create clustered index on non primary key column | CTS | 14 |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| What is the datatype returned by count(*) | Asian-CERC | 18 |
| |
| For more SQL Server Interview Questions Click Here |