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   interview questions urls   External Links  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 
What are the steps to switch a database's archiving mode
between NO ARCHIVELOG and ARCHIVELOG mode ?
 Question Submitted By :: Soni Sarma
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
Answer
# 1		 
To check database is in which mode

1. Conn sys/sys as sysdba
2. select log_mode from v$database

To set database in Archivelog mode

1. shutdown immediate;
2. startup mount;
3. alter database archivelog;
4. alter database open;

To set database in NoArchivelog Mode
1. shutdown immediate;
2. startup mount;
3. alter database noarchivelog;
4. alter database open;
 
Is This Answer Correct ?    1 Yes 0 No
Radha
 

 
 
 
Other Oracle Security Interview Questions
 
  Question Asked @ Answers
 
What dynamic data replication ?  1
What are the responsibilities of a Database Administrator ?  1
What is Statement Auditing ?  1
How can we reduce the network traffic ?  1
what is snapshot log ?  1
How to prevent unauthorized use of privileges granted to a Role ?  1
What is a profile ?  1
What are the benefits of distributed options in databases ?  1
What is Tablespace Quota ?  1
What are the system resources that can be controlled through Profile ?  1
What is default tablespace ?  2
What is Privilege Auditing ?  1
What are the dictionary tables used to monitor a database spaces ?  1
What is Object Auditing ?  1
What is user Account in Oracle database ?  1
What are Roles ?  1
What is Auditing ?  1
What is the use of ANALYZE command ?  1
How can we specify the Archived log file name format and destination ?  1
What is snapshots ?  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
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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