Compare and contrast TRUNCATE and DELETE for a table.
Answer Posted / ramesh
Truncate is to delete the entire data of any table .does not
have criteria deletion
where as Delete can do that job
However Deleted blocks still persists and have to be
shrinked .otherwisem You still feel the Deleted Recs while
you Query Against
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
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.
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
what do you understand by fine-grained auditing?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are the different types of indexes available in sql server? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the default port no on which sql server listens? : sql server DBA
how can you create a user-defined lock?
What are statistics, under what circumstances they go out of date, how do you update them?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.