Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / surendra
truncate
it deletes only the records from the table
it doesn't delete the structure of the table
we cannot rollback it
we cannot delete a particular record from the table
it is ddl
drop
it deletes the records as well as structure of the table too
we cannot rollback the records
we can flashback the table from the version 9x
it is ddl
delete
it deletes the only records which are we mention in the where clause or whole records
it is dml
we can rollback it
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to rename a tablespace in oracle?
How can I get column names from a table in oracle?
How to delete an existing row from a table in oracle?
How data locks are respected in oracle?
What is the oracle implicit cursor?
What privilege is needed for a user to delete rows from tables in another schema?
Can we create trigger on materialized view in oracle?
How to turn on or off recycle bin for the instance?
How to write a query with a left outer join in oracle?
what is dynamic SGA and static SGA
What are the differences between date and timestamp in oracle?
interview questions with answer for cts
What is integrity and what is constraint??Explain with example
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Why cursor variables are easier to use than cursors?
