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

1 Answers  

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

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

2 Answers  

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

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 does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---