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.

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

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

0 Answers  

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

What would you do with an "in-doubt" distributed transaction?

0 Answers  

---

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  

---

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

3 Answers  

---

why we use cursors

1 Answers  

---

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  

---

What authentication modes does sql server support? : sql server DBA

0 Answers  

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---