| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| Difference between Function and Procedure-in general? | | 2 |
| what are the joins,primary key,foriegn key, candidate key,
super key and expain them? | | 2 |
| How to find the date and time of last updated table? | | 3 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| What is the difference between windows authentication and
sql server authentication | HCL | 3 |
| What is data integrity? Explain constraints? | | 1 |
| plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005 | | 1 |
| How to Generate a Series of Random Integers With T-SQL? | | 1 |
|
CLR Integration ?
what is Notification services ?
| Satyam | 1 |
| Difference between Cluster and Non-cluster index? | Oracle | 6 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| What do you mean by COLLATION? | | 4 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 3 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 2 |
| What is the diff between Static Queries and Dynamic queries
give me some examples | CSC | 1 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| How to find the date and time of last updated table?
| | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map