What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

Explain an ORA-01555

2 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

---

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

when does an alert gets signaled?

0 Answers   Oracle,

---

Name three advisory statistics you can collect.

1 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---