Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15788 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
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.
How would you extract DDL of a table without using a GUI tool?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
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 a correlated sub-query? : sql server DBA
when does an alert gets signaled?
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
Why does Oracle not permit the use of PCTUSED with indexes?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the commands used in dcl? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what are the performance views in an oracle rac environment?
Can you redefine a table online?
What are the different types of indexes available in sql server? : sql server DBA
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?
