| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| is there more the two primary key in a single table? | Systematix | 19 |
| What's the difference between DELETE TABLE and TRUNCATE
TABLE commands? | | 6 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL? | | 1 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| What is a view? is View updatable? | IBM | 10 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| What is the STUFF function and how does it differ from the
REPLACE function? | | 1 |
| What is the diff between Dynamic queries and static queries
| ICS-Integrated-Computer-Solutions | 1 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| can anyone explain me the concept of Serialization in Detail
and Clear? plz its urgent i have interview on friday (15th feb) | | 1 |
| Which databases are part of SQL server default installation?
Explain the usage of each? | Accenture | 2 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| explain different types of jions with examples briefly? | Zensar | 1 |
| Where do you think the users names and passwords will be
stored in sql server? | | 2 |
| What is database normalization? | Digicel | 5 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| how can u select the Distinct values in the table, table
having 20 columns , i want all columns | | 1 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |