Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15776 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
how to restore files with rman?
What are the different sql server versions you have worked on? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
when does an alert gets signaled?
What happens on checkpoint? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
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
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is dcl? : sql server DBA
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 does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the steps you will take to improve performance of a poor performing query?
