Oracle interview question

DBMS related questions, Normalization, OOP Concepts