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.

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

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

3 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

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

0 Answers   Oracle,

---

What is the difference between Datapump & export/import?

2 Answers  

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---