1)

Local prefixed indexes can be unique or non unique. Local indexes may be easier to manage than global indexes. Ex: SQL> create index stud_index on student(sno) local; GLOBAL INDEXES. A global index may contain values from multiple partitions. An index is global prefixed if it is partitioned on the left prefix of the index columns. ................
................