Netcracker Technology interview question

Core java, oracle db functions, design pattern.