| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 5 |
| What are primary keys and foreign keys? | | 3 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| What is Trigger? | Misys | 2 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| What is a join and their types? | Challenger-Financial | 2 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 2 |
| where do you use Isolations?give me some exmpale? | | 1 |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 2 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 4 |
| How would you Update the rows which are divisible by 10,
given a set of numbers in column? | | 1 |
| WHAT IS UNIQUE IDENTIFIER DATA TYPE? | Sparsh | 2 |
| What is a Trace frag?Where can we use this? | | 1 |
| write the query for taking database backup in sql | Logica-CMG | 6 |
| What are the types of indexes available with SQL Server? | | 2 |
| What is cursor ? And what is difference between Trigger ? | HCL | 1 |
| how to generate XML out of QUERY? | McAfee | 1 |
| what is the main difference between constraints(like
primary key etc..)& joins? | Annik | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
