Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15475 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
IN MSSQLSERVER TRUNCATE RESETS IDENTITY VALUE OF COLUMN
WHILE DELETE DOESN'T RESETS IDENTITY VALUE OF COLUMN
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
which background process invoke at the time of upgradation tell me???
what is the use of recording information about current session?
what is the role of dip user in our database?
how can you get actual data change values from previous transactions in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
how can you record information about current session?
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?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What authentication modes does sql server support? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the operating modes in which database mirroring runs? : sql server DBA
What happens on checkpoint? : sql server DBA
how can you initialize log miner?
