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                      
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 exact difference between drop and truncate table.
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is exact difference between drop and truncate table.
Answer
# 1		 
Drop Statement deletes the Table structure from the database.
Truncate statement will delete the entire data from Table
and keeps the Table structure as it is in the DB.
 
Is This Answer Correct ?    1 Yes 0 No
Sowjanya
 
  Re: what is exact difference between drop and truncate table.
Answer
# 2		 
ya its correct sowjanya

DROP - delete objects from the database 
TRUNCATE - remove all records from a table, including all
spaces allocated for the records are removed in this
rollback is not possible

DELETE - deletes all records from a table, the space for the
records remain rollback is possible
 
Is This Answer Correct ?    3 Yes 0 No
Samad
 
 
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table  3
Difference between primary key and unique key ? Keane-India-Ltd7
What is the difference between Outer join and Full outer join?  1
What is a Redo Log ?  2
What is self-referential integrity constraint ?  1
What are the factors causing the reparsing of SQL statements in SGA?  1
what is a cartition product?  2
What is an Extent ?  2
What is the function of Optimizer ?  1
What is dictionary cache ?  2
what is difference between table and view? where to use views? thanks in advance!  1
Can we create more than one constraint to column ?  1
Please explain the difference between outer join and inner join? With examples would be appreciable..! IBM2
What does a Control file Contain ?  1
Write a simple Store procedure and pass parameter to it ? Keane-India-Ltd1
what is the syntax of DROP command?  5
what is the difference between UNION AND UNIONALL  2
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS Mind-Tree2
a query to select maxmun 3 salaries of employee table Polaris5
When can Hash Cluster used ?  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 © 2007  ALLInterview.com.  All Rights Reserved.

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