| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between the following two sql
statements
select count(*) from <tablename>
select count(col_name) from <tablename> | 247Customer | 2 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 18 |
| What is a job? | | 3 |
| what is cluster and nin-cluster index? | | 4 |
| to explain sql server 2000 architecture & authentication | | 1 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | HCL | 4 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| What is the difference between local table and global table | Polaris | 1 |
| What is SQL Profiler what is the use of it? | 247Customer | 2 |
| I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer. | Satyam | 4 |
| What is a Trace frag?Where can we use this? | | 1 |
| Why we need a group by clause? | | 3 |
| sql server has its default date format in da form "yy-mm-dd"
its possible to convert da current date format of sql
server to desired format. Now my question is dat how to get
da previous and comin days date in my desired format?? | | 1 |
| How m-m relationships are implemented? | | 1 |
| what are the new features of sql server 2005? | HP | 5 |
| What is de-normalization and when do you do it? | | 3 |
| wht's the differece between sqlserver05 and sqlserver2000 | | 3 |
| how many type of subquery? | | 2 |
| What is Query Execution Plan? How does it help optimize or
tune a database driven application? | Accenture | 1 |
| |
| For more SQL Server Interview Questions Click Here |