what is the difference between catalog & nocatalog?
Answer Posted / 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
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the recovery models for a database? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what are the types of connection load-balancing?
Why does Oracle not permit the use of PCTUSED with indexes?
How do you open a cluster administrator? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Can you redefine a table online?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the steps you will take to improve performance of a poor performing query?
what is a crs resource?