Oracle sql plsql questions

SQL Question Of The Day: What is the difference between decode and case statement explain with an use case?

PL/SQL Question Of The Day : can I write commit inside a trigger? If yes in which scenario and if no why ?

SQL Coding Question Of The Day

SQL Question Of The Day : What is the difference between replace and translate and explain with a use case?

PL/SQL Question of the Day: Which keyword we need to use to propogate the exception to the outer block or calling block?

SQL Coding question of the day:

SQL Question Of The Day : what is a savepoint and explain the same with a use case?

PL/SQL Coding question of the Day: Write a function to find out whether the given number is a prime number or not? If prime number return as Y else N

SQL Question Of The Day: What is the difference between trunc and round? Explain with a use case.

Question : Why rowid is the fastest way to access the data from the table?