|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions REVOKE Latest Answer : RRVOKE ... Both will result in deleting all the rows in the table EMP.Answered by Scott on 2005-05-12 10:31:58: The difference is that the TRUNCATE call cannot be rolled back and all memory space for that table is Latest Answer : Hi,One important difference that everybody missed is High Water Mark.While using TRUNCATE the High Water Mark is set to zero and with DELETE it remains same.High Water Mark is the highest mark upto which that table has ever reached. ... TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE. Latest Answer : Hi,1. For truncate command, trigger will not get fired, but for Delete Command, Trigger will get fired.2. Truncate Is the DDL command whereas Delete is the DML command3.Once the truncate command is issued, Transactions can't be rolled back whereas ... Latest Answer : the select statement goes to oracle server and the server responds ... Read Answers (2) | Asked by : sanju If Delete Any Table In Back-End Then. What Are The Triggers will Fire Automatically(Those Triggers Are Back-End Triggers Only)? Read Answers (1) | Asked by : Patan Muzeebkhan How do you declare a variable with BLOB as datatype? How can you use BLOB data type? What size can be given to its variable? _______data type is used to store binary data such as graphics, sound, etcSQL uses ____________ clause to impose an order on the result of a query _________ function determines the number of rows or column values.The limit that determines the sphere of influence and control over a system is called_______________ is a graphic technique that can be used by analyst to represent the inputs and outputs. Read Answers (5) | Asked by : Amit Sharma
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
