Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 13666 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
IN MSSQLSERVER TRUNCATE RESETS IDENTITY VALUE OF COLUMN
WHILE DELETE DOESN'T RESETS IDENTITY VALUE OF COLUMN
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How would you best determine why your MVIEW couldn't FAST REFRESH?
What would you do with an "in-doubt" distributed transaction?
How would you extract DDL of a table without using a GUI tool?
what is logical system in sap basis
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Can you redefine a table online?
how can you implement fine-grained auditing?
What are the different sql server versions you have worked on? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what is the use of ocr?
what is the role of dip user in our database?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you get actual data change values from previous transactions in oracle?
