Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15778 Views
- I also Faced
- E-Mail Answers
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
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What types of replication are supported in sql server? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
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.
Explain about your sql server dba experience? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to start SQL Server in minimal configuration mode?
Query processing is slow(eg select query)how will u solve that
How do you trace the traffic hitting a sql server? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Why would you call update statistics? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is logical system in sap basis
