| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| can you any body tell me which service pack is installed in
the sql server? | | 3 |
| What is the difference between a local and a global variable? | | 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. | | 5 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| Differences between functions and stored procedures? | 247Customer | 6 |
| what are default? Is there a column to which a default cant be
bound? | | 1 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better? | | 1 |
| Differnce between sel server 2000 and 2005 | | 3 |
| what is Archive old data? | | 1 |
| How can your resolve deadlocks? | IBM | 3 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | | 2 |
| How many index keys possible for a table | | 6 |
| I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer. | Satyam | 4 |
| 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 |
| What is a transaction and what are ACID properties? | | 2 |
| 1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
| | 3 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | | 1 |
| logshipping is Any difference 2000 and 2005? | | 1 |
| how do we find every fifth record in a table | | 11 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
