ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle Security
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question 
How can you enable automatic archiving ?
 Question Submitted By :: Soni Sarma
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How can you enable automatic archiving ?
Answer
# 1		 
Shut the database
     Backup the database
     Modify/Include LOG_ARCHIVE_START_TRUE in init.ora file.
     Start up the databse.
 
Is This Answer Correct ?    0 Yes 0 No
Guest
 
  Re: How can you enable automatic archiving ?
Answer
# 2		 
1. shutdown the database with normal/emmidiate/transactional
2. modify/include the parameter log_archive_start=true,
log_archive_dest= (location to which the redo log file 
group is archived), log_archive_format=(in which format you 
want to apper the archive log file)
3. start up the database
 
Is This Answer Correct ?    0 Yes 0 No
Smtia
 
 
 

 
 
 
Other Oracle Security Interview Questions
 
  Question Asked @ Answers
 
Differentiate simple and complex, snapshots ?  1
What is Tablespace Quota ?  1
What are the options available to refresh snapshots ?  1
What are the system resources that can be controlled through Profile ?  1
What are the benefits of distributed options in databases ?  1
What is the use of ANALYZE command ?  1
What are roles ? How can we implement roles ?  2
What is a trace file and how is it created ?  1
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?  1
What is default tablespace ?  2
When will the data in the snapshot log be used ?  1
What is snapshots ?  1
What are the different Levels of Auditing ?  1
What are the database administrators utilities avaliable ?  1
What is a profile ?  1
What are the responsibilities of a Database Administrator ?  1
what is snapshot log ?  1
What are Roles ?  1
What dynamic data replication ?  1
How can we specify the Archived log file name format and destination ?  1
 
For more Oracle Security Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com