Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 16023 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramesh
Truncate is to delete the entire data of any table .does not
have criteria deletion
where as Delete can do that job
However Deleted blocks still persists and have to be
shrinked .otherwisem You still feel the Deleted Recs while
you Query Against
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the differences of where and if in SAS?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is dbcc? : sql server DBA
what is a crs resource?
what is the use of ocr?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How would you best determine why your MVIEW couldn't FAST REFRESH?
what do you understand by flashback feature of oracle?
what functionality does oracle provide to secure sensitive information?
What the different topologies in which replication can be configured? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
how can you find out if a table can be redefined?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
