ALLInterview.com :: Home Page            
 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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
   
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


  

 
 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 is the difference between alert log file and trace 
file ?
 Question Submitted By :: Bheemdosa
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the difference between alert log file and trace file ?
Answer
# 1		 Alert log file is found at the background dump directory specified by the background_dump_dest parameter. Alert log file logs the information like startup or shutdown information of the database,admin activities and its all done by the server process.

Example suppose you are away from monitoring database and database stop running or shutdown or restarted the information and the ora error messages will be checked by the alertlog file.

Trace file is found at the user dump directory specified by the user_dump_dest parameter. Trace file logs the information about user activities or the information about any internal error occurs at the database and its a user process. 
Is This Answer Correct ?    16 Yes 1 No
Rutu
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index  1
Write a simple Store procedure and pass parameter to it ? Keane-India-Ltd2
what diffrence between function and procedure?  4
What is DTS and purpose of DTS ? TCS1
How do you rate yourself in oracle and sql server ? Keane-India-Ltd2
What is COST-based approach to optimization ?  4
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?  2
When a form is invoked with call_form, Does oracle forms issues a save point ? Oracle1
What is E-R diagram ? Keane-India-Ltd2
What is currency type in database ? TCS3
what is the syntax of DROP command?  10
Describe Referential Integrity ?  1
 
For more Oracle General 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 © 2012  ALLInterview.com.  All Rights Reserved.

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