| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the query and condition to delete datas in sql
server. | | 1 |
| What are the different types of backup avaible in SQL SErver | Emphasis | 3 |
| Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not? | | 2 |
| How many index keys possible for a table | | 6 |
| how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server. | IBM | 3 |
| Explain the new features of SQL server 2000? | | 1 |
| About Indexed Views? with example?
plz reply... | | 1 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 13 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 1 |
| What is a cursor in SQL Server 2000 and their types? | | 2 |
| What's the difference between a primary key and a unique key? | Wipro | 7 |
| What is the datatype returned by count(*) | Asian-CERC | 16 |
| How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
| GE | 1 |
| 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 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| What is Deadlock? | Satyam | 2 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 2 |
| 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 lock escalation? | | 1 |
| how to generate XML out of QUERY? | McAfee | 1 |
| |
| For more SQL Server Interview Questions Click Here |