| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a trigger? | | 3 |
| How do SQL server 2000 and XML linked? | | 1 |
| What are the different types of joins and what does each do? | | 2 |
| please can anyone answer this query
Table 1 has 2 columns: EmployeeId,Age
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region who has the oldest person | | 5 |
| Wht is Stuff in sql ser | | 1 |
| What are explicit and implicit transactions? | | 1 |
| i want table name basis on column name. | | 2 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 12 |
| In which year relase the 7.0& 2000 & 2005? | | 1 |
| what is cluster and nin-cluster index? | | 2 |
| Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow? | | 2 |
| What value could be assigned to Varchar Type? | | 2 |
| how can i store resumes in database? | HCL | 1 |
| We create an index to fast the search. How it fast the
query? Do we write any special keyword with query? | | 3 |
| Which is best Subquery (or) joins in sql server? explain why | | 1 |
| how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)? | Marlabs | 5 |
| Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table? | eFunds | 4 |
| you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required | | 2 |
| what is the main difference between constraints(like
primary key etc..)& joins? | Annik | 2 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
