what is the difference between catalog & nocatalog?
Answer Posted / 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.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how can you initialize log miner?
What is the default fill factor value? : sql server DBA
What happens on checkpoint? : sql server DBA
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.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What are the different types of indexes available in sql server? : sql server DBA
what are the performance views in an oracle rac environment?
What is the default port no on which sql server listens? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
How would you go about verifying the network name that the local_listener is currently using?
What authentication modes does sql server support? : sql server DBA
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.
What is the difference between clustered and non-clustered index? : sql server DBA