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 (720)
 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 (265)
 Forms Reports interview questions  Forms Reports Interview Questions (466)
 Oracle AllOther interview questions  Oracle AllOther Interview Questions (182)
Question
What is Trace File ?
 Question Submitted By :: Oracle-General
I also faced this Question!!     Answer Posted By  
 
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 ?    22 Yes 1 No
S.gousalya
 
Answer
# 2
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
 
 
 
Answer
# 3
trace file is the file which converts control files into
readable format
 
Is This Answer Correct ?    8 Yes 4 No
Mohanish Sahoo
 
Answer
# 4
trace is the outline
 
Is This Answer Correct ?    4 Yes 5 No
Mohana.s
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
What is a Schema ?   5
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000. Wipro 3
What is currency type in database ? TCS 3
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views? IBM 1
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO? IBM 6
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)   6
sql query to get zero records from a table CTS 6
What is a cluster Key ?   2
What is a Temporary Segment ?   2
does the query needs a hint to access a materialized view?   1
what is the difference between UNION AND UNIONALL   4
Which database is better for os platform dependency?   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