What happens to indexes if you drop a table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle General Interview Questions

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,


What is E-R diagram ?

2 Answers   CGI, Keane India Ltd,


What is difference between cartesian join and cross join?

0 Answers  


How to convert a date to char in oracle? Give one example.

0 Answers  


How to create index-by table in oracle?

3 Answers  






can a table has a column that has only view data and in other columns we can change data?

2 Answers   Secon,


what are the different types of cursors? explain?

4 Answers  


What is java oracle used for?

0 Answers  


Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 Answers  


how to find out second largest value in the table

8 Answers  


Why packages are used in oracle?

0 Answers  


What is recovery manager in Oracle?

0 Answers   MCN Solutions,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)