Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15801 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishore
truncate removes all the rows from a table
it can't be rollback
delete removes all /specific rows from a table
it can be rollback
drop removes whole table
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what is a crs resource?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
what are the performance views in an oracle rac environment?
when does an alert gets signaled?
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 process messages in order asynchronously?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what is ora 24313?what is the procedure to exclude that error?
how can you find out if a table can be redefined?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Why does Oracle not permit the use of PCTUSED with indexes?
