Compare and contrast TRUNCATE and DELETE for a table.
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
what do you understand by flashback feature of oracle?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
. 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?
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.
What are the recovery models for a database? : sql server DBA
how can you implement fine-grained auditing?
How do you open a cluster administrator? : sql server DBA
What authentication modes does sql server support? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
how to restore files with rman?
What are statistics, under what circumstances they go out of date, how do you update them?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
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
who owns the operating system files created by the utl_file package?
which background process invoke at the time of upgradation tell me???