Answer / 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.

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

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

0 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

Describe what redo logs are.

1 Answers  

---

How many memory layers are in the shared pool?

3 Answers  

---