Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each.
- 5 Answers
- 24504 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha
in nonarchivelog mode the online redo log file are
overwritten each time a log switch occurs.LGWR does not
overwrite an online redo file group until the checkpoint
for that group is completed.ex-operating system crash
causes an instance crash.
| Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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 use of recording information about current session?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can you schedule a job in database?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
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.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Why would you call update statistics? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
