what is difference between delete and truncet ?
Answer Posted / karna
As of I know,we can roll back bothe delete and truncate
statements.but in case of delete statement logging of the
details in the log file takes more time,beacuse it logs the
details row by row in the page.
when it comes to truncate,all the rows will be logged at
the same time.
Please correct me,If I am wrong.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What are the disadvantages of views in a database?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
What do you mean by database?
Difference between sql and mysql?
What are the types of joins?
What is a trace file?
How do I setup a database connection?
Can a database table exist without a primary key?
aht is the difference b/w network & hierarchial & relational dbms????
What are indexes in oracle?
What is a reference table in database?
Explain various types of locks in a transaction? Which is better and why?
What is a Database?
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks