The difference between the two is that the truncate command is a DDL operation and just moves the high water mark and produces few rollback data.
The delete command, on the other hand, is a DML operation, which will produce rollback data and thus take longer to complete. When a user process fails, what background process cleans up after it? Describe the difference between a procedure, function and anonymous pl/sql block.
ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. Candidate should mention use of DECLARE statement, a function must return a value while a procedure doesn't have to. What is a mutating table error and how can you get around it? It occurs because the trigger is trying to update a row it is currently using.
The benefit of taking a hot backup is that the database is still available for use while the backup is occurring and you can recover the database to any point in time.
The benefit of taking a cold backup is that it is typically easier to administer the backup and recovery process.
All the extents that an object takes when grouped together are considered the segment of the database object.Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table.