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.

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

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

0 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

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

1 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

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

2 Answers   IBM,

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

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,

---