Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 14522 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
when does an alert gets signaled?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Where would you look for errors from the database engine?
how can you communicate with operating system files from oracle?
how can you initialize log miner?
Which autogrowth database setting is good? : sql server DBA
what is the role of dip user in our database?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the steps you will take to improve performance of a poor performing query?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
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 process messages in order asynchronously?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
