| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| create index a on employee(dno)
In this,which index was created? | | 2 |
| What are the type of Indexes? which one is best, why? | | 5 |
| what is IDE,DMV in sql server? | Value-Labs | 1 |
| What is the difference between the following two sql
statements
select count(*) from <tablename>
select count(col_name) from <tablename> | 247Customer | 2 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| What is a trigger? | | 3 |
| What are the different types of replication? How are they used? | | 3 |
| what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha | | 4 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 11 |
| Why we need a group by clause? | | 3 |
| Explain Active/Active and Active/Passive cluster
configurations? | | 1 |
| What is the difference between truncate and delete statement? | CTS | 4 |
| Explain different isolation levels? | | 3 |
| Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table? | eFunds | 5 |
| hi, may i know what is the command to get abstract the
current month, current year and current day from a given
date.i want these three in a isolated way..seperatedly is
that any way in sql server 2000 | | 3 |
| What are the steps you will take, if you are tasked with
securing an SQL Server?
| HCL | 1 |
| can we call functions from stored procedure in SQL Server
2005 ? How? | | 2 |
| in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only. | | 7 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| What is Trigger? | Misys | 2 |
| |
| For more SQL Server Interview Questions Click Here |