Top PL SQL Interview Questions Real Time for Experienced and Freshers

Here is a list of Top PL SQL Interview Questions Real Time for Experienced and Freshers. Please add your questions and answers to this list as comment.

    

PL SQL Interview Questions

Difference between where clause and having clause?
Difference between rank() and dense rank()?
Difference between delete and truncate ?
If we delete the rows in a table, will the memory size increase?
For Example, Some files are generated at an interval of one hour. Write a script to retain only the latest file and delete all other files ?
If the server is down what will be the first thing you will check?