Pergunta de entrevista da empresa Oracle

Questions related to ER diagram. 1 SQL Join Query Question. 1 DSA question - Check if a string is present in the other string