Can one index XML data loaded into the database?

Yes, look at this example:

create index XMLTable_ind on XMLTable
        (extractValue(xml_data, '/FAQ-LIST/QUESTION/QUERY') );