Answer / kittu_chintu2005

CATALOG is used when you use a repository database as catalog.
NOCATALOG is used when you used the controlfile to register your backup information.
Default in NOCATALOG.

Answer / manish

catalog means backup information store in control file as well as catalog database.

nocatalog means backup information store in only control file no other external repository

Answer / mohammed rafi uddin

Catalogue means backup contains the information of control file, backup information and tendency of time period and requires no network connectivity.whereas no catalogue having separate database backup information, no limit of time period & It should be network wise connection.

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

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

2 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

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

1 Answers  

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---