| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Which system table contains information on constraints on
all the tables created? | | 2 |
| in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only. | | 7 |
| Explain Different types of Projects? | | 1 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 2 |
| what are the problems in logshipping? | | 2 |
| How do you find the number of rows in a table? | | 5 |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| what is hash table | Teledata | 2 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 5 |
| How would you Update the rows which are divisible by 10,
given a set of numbers in column? | | 1 |
| How to tune a stored procedure? | | 5 |
| what are the joins,primary key,foriegn key, candidate key,
super key and expain them? | Polaris | 2 |
| How reterive duplicate value in SQL? | | 5 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example. | | 1 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 2 |
| how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server. | IBM | 4 |
| 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. | | 5 |
| Alternative way to DetDate() function? | | 4 |
| Difference between sql server 2000 and sql server 2005?
| Satyam | 4 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
