| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between login and a user? | TCS | 5 |
| What is the difference between windows authentication and
sql server authentication | HCL | 3 |
| Can anybody explain me cold backup and hot backup?
| TCS | 2 |
| Which institute is best for SQL Server 2005 Training? | | 3 |
| What is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 2 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning | TCS | 1 |
| Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases? | | 2 |
| What is a view? is View updatable? | IBM | 10 |
| can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
| Google | 6 |
| i have a table student like
sname
-----
ram
ram
ram
raj
raj
raj
i need the output like
sname
-----
ram
raj
ram
raj
ram
raj
| IBM | 4 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 2 |
| How to delete an attribute from the emp table | | 3 |
| SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent. | | 2 |
| Which virtual table does a trigger use? | TCS | 5 |
| What are cursors? | | 7 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 2 |
| what is diffence between replicaion and logshipping? | | 1 |
| What's the purpose of Stored Procedure? | Wipro | 3 |
| what is extended StoreProcedure ?
| Satyam | 3 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map