Answer Posted / Mrs Madhu
When you drop an Oracle table that has indexes, the associated indexes are not automatically dropped. You must explicitly drop the indexes using the DROP INDEX command. If you want to drop both the table and its indexes at once, you can use the DROP TABLE cascade command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to start an oracle instance?
What is oracle latest version?
How to select all columns of all rows from a table in oracle?
Design database draw er diagram for a certain scenario ?
How to put more than 1000 values into an oracle in clause?
How to write a left outer join with the where clause in oracle?
How to use values from other tables in update statements using oracle?
