Answer / saravakumar

Online operation means when online operations are happening
the database are in normal operational condition, the
processes which are participating in online operations does
not require exclusive access to database.

Can a unique index be created on a column, which contains null?

0 Answers  

---

What is RMS migrations?

0 Answers   Satyam,

---

what is a join? : Sql server database administration

0 Answers  

---

What is normalization and its types?

0 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

How many database files are there in sql server 2000?what are they?

0 Answers  

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers  

---

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 Answers   HCL,

---

How to insert new line characters into strings?

0 Answers  

---

How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

0 Answers  

---