Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 16010 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
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
how can you enable flashback feature?
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.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
How to start SQL Server in minimal configuration mode?
how can you create a user-defined lock?
Why does Oracle not permit the use of PCTUSED with indexes?
how can you implement fine-grained auditing?
how can you get actual data change values from previous transactions in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What happens on checkpoint? : sql server DBA
who owns the operating system files created by the utl_file package?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
