Oracle Interview Question

Pure technical from java and ql and ojet