Compare and contrast TRUNCATE and DELETE for a table.
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
what do you understand by flashback feature of oracle?
Can you redefine a table online?
what is the use of ocr?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what is ora 24313?what is the procedure to exclude that error?
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?
what is a user-defined lock?
What are statistics, under what circumstances they go out of date, how do you update them?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what is the diffrence between core dba and apps dba?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.