Answer Posted / monal

Live Lock occurs when exclusive lock is denied continuously
by series of overlapping shared locks keep on interfering
each other and they keep changing status further preventing
them to complete the task.

Why does Oracle not permit the use of PCTUSED with indexes?

2945

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4352

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2639

---

how can you get actual data change values from previous transactions in oracle?

1089

---

What authentication modes does sql server support? : sql server DBA

1218

---

How to start SQL Server in minimal configuration mode?

7977

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1108

---

What is fill factor? : sql server DBA

1254

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2465

---

How would you extract DDL of a table without using a GUI tool?

2490

---

who owns the operating system files created by the utl_file package?

1081

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1073

---

What is a correlated sub-query? : sql server DBA

1092

---

What is transparent data encryption? : sql server DBA

1199

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1211

---