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                      
Google
   
 
Categories >> Software >> Databases >> Oracle >> Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions (718)
 OCI interview questions  OCI Interview Questions (10)
 Architecture interview questions  Architecture Interview Questions (75)
 Oracle Security interview questions  Oracle Security Interview Questions (37)
 Database Management interview questions  Database Management Interview Questions (264)
 Forms Reports interview questions  Forms Reports Interview Questions (466)
 Oracle AllOther interview questions  Oracle AllOther Interview Questions (180)
Question
What is Trace File ?
 Question Submitted By :: Akshay
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is Trace File ?
Answer
# 1
when one of oracle background process like database
writer,log writer encouters a exception then they
will write a TRACE FILE. They are recorded in
alert.log
 
Is This Answer Correct ?    21 Yes 1 No
S.gousalya
 
  Re: What is Trace File ?
Answer
# 2
trace is the outline
 
Is This Answer Correct ?    4 Yes 4 No
Mohana.s
 
 
 
  Re: What is Trace File ?
Answer
# 3
trace file is the file which converts control files into
readable format
 
Is This Answer Correct ?    8 Yes 4 No
Mohanish Sahoo
 
  Re: What is Trace File ?
Answer
# 4
we can say that the trace files are the outlines files . a
trace files are those files which help us to covert our
control files into readable format. they are recorded in
alter .log ext.
 
Is This Answer Correct ?    7 Yes 1 No
Syed Mazhar Nadir
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
Define the terms primary key foreign key and also the difference between primary and the unique key   2
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST. Wipro 2
How to call a stored procedure inside a trigger? Give an example. Exilant 1
what is primary key and foreign key when and where have to use   5
What is cursor TCS 4
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date. Wipro 3
What is an Integrity Constrains ?   2
What are the Limitations of a CHECK Constraint ?   5
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning? Accenture 1
why can't we assign not null constraint as table level constraint CTS 3
what is shell? Microsoft 2
The join defined by the default data link is an outer join yes or no ? Oracle 1
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com