Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
Answer Posted / basobdutta
Archivelog mode - In archivelog mode cold and hot backups
are possible. We can recover our database upto the last
point of failure.
Noarchivelog mode- Here we can only go for cold
backup.Generally in this mode complete recovery is not
possible
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is replication? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
internal architecture
How would you extract DDL of a table without using a GUI tool?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Explain materialized views and how they are used.
what is logical system in sap basis
Where do you find the default index fill factor and how to change it? : sql server DBA
how can a session indicate its interest in receiving alerts?
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.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the different ways you can create databases in sql server? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
what is a crs resource?