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

1 Answers  

---

What view would you use to look at the size of a data file?

3 Answers  

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

when does an alert gets signaled?

0 Answers   Oracle,

---

Can we take incremental backups in datapump?

1 Answers  

---

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

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  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

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

1 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---