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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

---

Oracle 11g new features?

2 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

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

0 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---