Can anyone send me the Oracle Interview question and answers for a oracle plsql developer.

This is urgent.
Thanks in advance.

you can easily find all that by investing some quality time in web searching.

Hai,
I have few
1.explain domain constraints?
2.explain correlated query with example?
3.asking more depth in cursors concept?
4.practical implementation for self join?
5.Triggers coding like we can write committ is it ok?
all the best!

Yugundhar.K

Gud questions... Same were asked from me...

What is meant by snapshot error?
Latest Answer: Just in simple words.....Ora01555 error occurs when a transation fails when it cannot able to find read consistence image in rollback segment. To solve this problem: Increse the Undo_RetentionCheers


2--What is a Temporary Segment ?

temporary segments are basically used for sort operations in oracle,,when the user tries to execute the query through order by clause. so system needs an space for an sort operation, and system will use temporary segments for this query

i think this is beneficial

wvmfss@yahoo.com