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 |
How you open and close a cursor variable.Why it is required?
What happens to the data files if a tablespace is dropped?
Why use resource manager in Oracle?
How to do paging with oracle?
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 ?
How a tablespace is related to data files?
Can we create trigger on view in oracle?
Give the advantages and disadvantages of clusters.
Explain drop constraint oracle?
How to connect to the server with user account: sys?
what is kernel?
Why is oracle database so popular?