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
What is object data modeling?
Explain about your project and its relation to the current job position you are applying to?
Differentiate between translate and replace?
What is the difference between 10g OEM and 11g OEM?
Explain parameter file in oracle.
What happens to the data files if a tablespace is dropped?
Why do you use stored procedures and state some of its disadvantages?
What are group functions in oracle?
How to start instance with a minimal initialization parameter file?
Is oracle an open source?
How to return top 5 rows in oracle?
Explain what are clusters?
Explain the different normalization forms?
How to join two tables in a single query using oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.