Un-Answered Questions { SQL PLSQL }

What is before and after trigger?

518


Can I call a procedure inside a function?

549


Which is better join or subquery?

604


What is the difference between instead of trigger and after trigger?

509


Why we use cross join?

536


Why indexing is needed?

516


Why is normalization important?

536


Which is faster subquery or join?

657


Why do we need unique key in a table?

522


Which is the correct statement about truncate and delete?

525


Why is a trigger used?

522


Why query optimization is needed?

513


Why use truncate instead of delete?

543


Can we call stored procedure in function?

548


Why is theta join required?

662