| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a view? | | 4 |
| can you any body tell me why are go for the rebuild the
master database.what is the reason? | | 1 |
| How to find the date and time of last updated table? | | 3 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | HCL | 4 |
| How to find the last update record in SQL Server? | | 3 |
| What are the different types of joins and what does each do? | | 2 |
| what is cluster and nin-cluster index? | | 4 |
| hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
| | 2 |
| Can you tell me the difference between DELETE & TRUNCATE
commands? | | 11 |
| What is a materialized view? | | 2 |
| How will u find the query which is running in some other
machine | IBM | 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 a stored procedure and trigger? | | 2 |
| About DTS usage ? | Cognizent | 2 |
| how to rename the table | | 3 |
| What is a stored procedure? | | 3 |
| How do you simulate a deadlock for testing purposes | | 1 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| What is a transaction and what are ACID properties? | IBM | 4 |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
