Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 7 Answers
- 15485 Views
- I also Faced
- E-Mail Answers
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 can you enable flashback feature?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
How do you open a cluster administrator? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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?
how can you implement fine-grained auditing?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Explain materialized views and how they are used.
How would you go about verifying the network name that the local_listener is currently using?
how can a session indicate its interest in receiving alerts?
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 are the different types of database compression introduced in sql server 2008? : sql server DBA
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
