"What are the differences between a procedure and a function in PL/SQL?" "Write a trigger that prevents deletion of records from the employee table on weekends." "Explain the concept of a mutating table and how it can affect triggers." "How do you handle errors in PL/SQL, and what are some best practices for error logging?" "What are bind variables, and how do they improve performance?" "What is the difference between an implicit and explicit cursor?" "How do you combine two tables with differing data and columns without using joins?" (Answer: You can't) "What is GROUP BY, and how is it used in SQL?"

SQL and Plsql basics question question related to joins cursor function procedure Dml Ddl and some query related to self joins union merge ,

what do u know about pl/SQL delete and truncate d/f explain exception handling and types