| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| When you first load SQL SERVER you will startup with what
all databases? | CompuSol | 2 |
| What is the use of DBCC commands? | | 1 |
| what is normalization?
what is denormalization?
| Satyam | 4 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | HCL | 2 |
| what is difference between having and where clause ? | | 1 |
| Difference between Cluster and Non-cluster index? | Oracle | 6 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| how can i store resumes in database? | HCL | 1 |
| how to get the automatic backup of the database in the sql
server | | 3 |
| What is referential integrity and how is it achieved? | Adea-Solutions | 1 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| From where can you change the default port? | | 3 |
| WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT | | 8 |
| Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table? | eFunds | 4 |
| explain different types of jions with examples briefly? | Zensar | 1 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| what is the Enterprise manager(2000) and management studio
(2005)? | | 2 |
| What is the default value of CHAR type? | Bosch | 6 |
| How to find the date and time of last updated table?
| | 2 |
| |
| For more SQL Server Interview Questions Click Here |