| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| can you any body tell me the difference between candidate
key and primary key | | 4 |
| Can we create a clustered index on composite primary key. | | 2 |
| What are different types of Keys? Please explain all the
keys with a suitable example. | | 2 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| What is the order in which the SQL query is executed? list
them in order. | CTS | 1 |
| 1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;" | | 6 |
| Which virtual table does a trigger use? | TCS | 6 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| how can do you the system monitoring? | | 1 |
| What are Magic Table? | Evalueserve | 15 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| How do you read transaction logs | | 1 |
| What is Files and Filegroups in SQL Server & it's
implementation. | Zenith | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| can you any body tell me the how to decrease the logfile | | 4 |
| What are primary keys and foreign keys? | | 3 |
| Wht is the difference between stored procedure and trigger | TCS | 4 |
| write the query for taking database backup in sql | Logica-CMG | 6 |
| how to dispaly a particular row details from a given table | | 1 |
| |
| For more SQL Server Interview Questions Click Here |