Compare and contrast TRUNCATE and DELETE for a table.
Answer Posted / kishore
truncate removes all the rows from a table
it can't be rollback
delete removes all /specific rows from a table
it can be rollback
drop removes whole table
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you open a cluster administrator? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Where do you find the default index fill factor and how to change it? : 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
how can you schedule a job in database?
what is asm?
How would you go about verifying the network name that the local_listener is currently using?
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.
what is logical system in sap basis
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Why would you call update statistics? : sql server DBA
how can you connect from 10g user to 11g user??
what is the use of ocr?