Top 5 SQL & PL/SQL Interview Questions & Answers 2026 || Part2 || Learn SQL with Shanmukha

Video Description
In this video, we dive deep into 5 essential Oracle SQL and PL/SQL concepts that are frequently asked in technical interviews and used in real-world database development. From logic-based coding to advanced performance tuning with Bulk Collect, we cover it all!
🚀 What you’ll learn in this tutorial:
1. How to generate a Fibonacci series using a PL/SQL block.
2. Creating an Audit Trigger to prevent and log unauthorized salary decreases.
3. How SAVE EXCEPTIONS works during Bulk Processing (DML error handling).
4. A clever SQL trick to count specific character occurrences in a string.
5. Generating a sequence of numbers (1-10) using Recursive CTEs—avoiding Level and Rownum!
🕒 Timestamps:
0:00 - Intro
0:45 - Q1: Fibonacci Series in PL/SQL
2:15 - Q2: Salary Update Trigger & Audit Logging
4:30 - Q3: BULK COLLECT with SAVE EXCEPTIONS (How it works)
6:10 - Q4: Count Character Occurrences in SQL
7:45 - Q5: Generate 1-10 using Recursive CTE (No Level/Rownum)
9:30 - Summary & Interview Tips

Видео Top 5 SQL & PL/SQL Interview Questions & Answers 2026 || Part2 || Learn SQL with Shanmukha канала Learn SQL with Shanmukha