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
What is dcl? : sql server DBA
how can you record information about current session?
what is a crs resource?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
which background process invoke at the time of upgradation tell me???
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how to restore files with rman?
What are the recovery models for a database? : sql server DBA
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?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you create a user-defined lock?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is the diffrence between core dba and apps dba?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA