| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| What is row by row processing ? | | 1 |
| How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables? | TCS | 3 |
| Alternative way to DetDate() function? | | 4 |
| What is SQL server agent? | SAP-Labs | 2 |
| Which virtual table does a trigger use? | | 3 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.? | | 2 |
| What is the difference between SSAS 2000 and SSAS 2005? | APX | 1 |
| what is the query and condition to delete datas in sql
server. | | 2 |
| I Have Employee table having column name as ID,SALARY
how to get second max salary from employee table with id
ex
ID SALARY
1 20000
7 37000
2 5000 | | 11 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| What is Schema? and why we use schemas? | | 1 |
| What is the difference between distinct clause and group by
clause? | Value-Labs | 1 |
| What is the use of MOVE keyword in restore command | IBM | 2 |
| What is INTVAL( )and where we use
Plz any body help me | | 1 |
| which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM | Wipro | 4 |
| what are default? Is there a column to which a default cant be
bound? | | 1 |
| can you any body tell me the difference between candidate
key and primary key | | 4 |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 7 |
| |
| For more SQL Server Interview Questions Click Here |