Is primary key indexed by default in oracle?



Is primary key indexed by default in oracle?..

Answer / Aviral Pratap Singh

"Yes, a primary key constraint is indexed by default in Oracle when it is created. However, you can disable this default behavior if necessary."n

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

How you open and close a cursor variable.Why it is required?

2 Answers  


What happens to the data files if a tablespace is dropped?

1 Answers  


Why use resource manager in Oracle?

1 Answers   MCN Solutions,


How to do paging with oracle?

1 Answers  


1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,


How a tablespace is related to data files?

1 Answers  


Can we create trigger on view in oracle?

1 Answers  


Give the advantages and disadvantages of clusters.

1 Answers  


Explain drop constraint oracle?

1 Answers  


How to connect to the server with user account: sys?

1 Answers  


what is kernel?

2 Answers   Microsoft,


Why is oracle database so popular?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • 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)