| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is physical sort data and logical sort data in index? | | 1 |
| what is replication?
where do u use Go Keyword?
| Satyam | 1 |
| how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server. | IBM | 3 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| Can you link only other SQL Servers or any database servers
such as Oracle? | | 1 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 12 |
| Which is better in performance - CONSTRAINT or TRIGGER over
a column which restricts say an input of particular value
in a column of a table? | Accenture | 3 |
| create index a on employee(dno)
In this,which index was created? | | 1 |
| What are functions | | 3 |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 1 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| What is BCP? When do we use it? | | 1 |
| What are the type of Indexes? which one is best, why? | | 5 |
| What value could be assigned to Varchar Type? | | 2 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| what is extended StoreProcedure ?
| Satyam | 3 |
| What is the difference between distinct clause and group by
clause? | Value-Labs | 1 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 14 |
| How will u get 5 years back record? | | 3 |
| how to select a field with firstletter as capital and
remaining are small letters | | 7 |
| |
| For more SQL Server Interview Questions Click Here |