Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 16021 Views
- I also Faced
- E-Mail Answers
Answer Posted / taral desai
truncate is faster then delete... truncate don't generate
rollback. truncated data can't be recovered
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
which background process invoke at the time of upgradation tell me???
Which autogrowth database setting is good? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
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.
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.
What is dcl? : sql server DBA
how can you implement fine-grained auditing?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what is the role of dip user in our database?
How can you control the amount of free space in your index pages? : sql server DBA
how can you initialize log miner?
