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
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you implement fine-grained auditing?
What is the default fill factor value? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
how can you communicate with operating system files from oracle?
How would you go about verifying the network name that the local_listener is currently using?
what do you understand by fine-grained auditing?
how can you find out if a table can be redefined?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you enable flashback feature?
How to start SQL Server in minimal configuration mode?
What is the default port no on which sql server listens? : sql server DBA