Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

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

0 Answers   Oracle,

---

What type of index should you use on a fact table?

1 Answers  

---

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

0 Answers   iGate,

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

when does an alert gets signaled?

0 Answers   Oracle,

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

---