| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
| Google | 10 |
| can anyone explain me the concept of Serialization in Detail
and Clear? plz its urgent i have interview on friday (15th feb) | | 1 |
| to explain sql server 2000 architecture & authentication | | 1 |
| What is the use of placing primary key and foreign key
constrains on columns. | Value-Labs | 2 |
| how to know Who Is Blocking Your SQL Server? | | 3 |
| write down the code for "how we delete a table without
using of Drop command " ? | Sonata | 2 |
| Which virtual table does a trigger use? | | 3 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 1 |
| Which virtual table does a trigger use? | TCS | 6 |
| Why Do you want to work in this company? | HCL | 3 |
| How do we get month name in SQL Server 2000, Oracle, MS Access? | | 9 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 2 |
| How can your resolve deadlocks? | IBM | 3 |
| wht's the differece between sqlserver05 and sqlserver2000 | | 3 |
| Can we create a clustered index on composite primary key. | | 2 |
| what is normalization?
what is denormalization?
| Satyam | 5 |
| WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER? | | 6 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| In which year relase the 7.0& 2000 & 2005? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
