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

1 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

Hot backup procedure?

2 Answers  

---

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

0 Answers   Oracle,

---

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

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

2 Answers   Mphasis,

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---