Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---

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

1 Answers  

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

Describe what redo logs are.

1 Answers  

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

Give two examples of referential integrity constraints.

2 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

How can you gather statistics on a table?

3 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

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

0 Answers  

---