Compare and contrast TRUNCATE and DELETE for a table.
Answer Posted / sridhar
truncate and delete are deltes all rows in the table but truncate is much faster than delete.
and if u delete row in the delte deletion of each gets logged in the transaction log.
truncate there is no way to log in transaction log
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how can you schedule a job in database?
internal architecture
. 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?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What the different components in replication and what is their use? : sql server DBA
What happens on checkpoint? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
Why would you use sql agent? : sql server DBA
which background process invoke at the time of upgradation tell me???
what is the role of dip user in our database?
what are the types of connection load-balancing?
Explain materialized views and how they are used.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?