Compare and contrast TRUNCATE and DELETE for a table.
Answer Posted / amsu
Truncate is a DDL and delete is a DML command. Once you
truncate a table you cannot rollback where as you can
rollback from the delete command. When you truncate a
table it release the space and it resets the highwater
mark. Delete won't release the space and it won't resets
the highwater mark.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What is a correlated sub-query? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
how can a session indicate its interest in receiving alerts?
how can you connect from 10g user to 11g user??
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What the different topologies in which replication can be configured? : sql server DBA
which background process invoke at the time of upgradation tell me???
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what are the performance views in an oracle rac environment?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what are the differences of where and if in SAS?