| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query? | | 2 |
| Explain Active/Active and Active/Passive cluster
configurations? | | 1 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 3 |
| can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com | Symphony | 21 |
| Can we create a clustered index on composite primary key. | | 2 |
| Explain the new features of SQL server 2000? | | 1 |
| What is normalization? | | 6 |
| What's the purpose of Stored Procedure? | Wipro | 4 |
| What is blocking and how would you troubleshoot it? | HCL | 2 |
| What is a Stored Procedure? | | 7 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| Which virtual table does a trigger use? | | 3 |
| 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 are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
| GE | 1 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| Wht is Stuff in sql ser | | 1 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead? | | 1 |
| how to replace double quotes by single quotes in sql server | CAC | 2 |
| |
| For more SQL Server Interview Questions Click Here |