Pergunta de entrevista da empresa Oracle

Small questions in programming and queries. Write a program to parse XML string. Write an sql query, some reg ex questions.