|
Question |
Rating |
View Answer |
 |
State the advantage and disadvantage of Cursor?
|
|
View Answer |
 |
What is trigger,cursor,functions in pl-sql and we need sample programs about it? |
|
View Answer |
 |
Explain the usage of WHERE CURRENT OF clause in cursors ? |
|
View Answer |
 |
What are two parts of package ? |
|
View Answer |
 |
What is ref cursor? |
|
View Answer |
 |
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
|
|
View Answer |
 |
What is Mutating SQL Table? |
|
View Answer |
 |
What is TTITLE and BTITLE? |
|
View Answer |
 |
What is Transaction? |
|
View Answer |
 |
What is Sequences? |
|
View Answer |
 |
What is difference between stored procedures and application procedures,stored function and application function?
|
|
View Answer |
 |
What is Pragma EXECPTION_INIT ? Explain the usage ? |
|
View Answer |
 |
1)What is the starting "oracle error number"? 2)What is meant by forward declaration in functions?
|
|
View Answer |
 |
What is Minus? |
|
View Answer |
 |
How to sort the rows in SQL? |
|
View Answer |
 |
State the difference between implicit and explicit cursor's.
|
|
View Answer |
 |
Where the Pre_defined_exceptions are stored ? |
|
View Answer |
 |
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ? |
|
View Answer |
 |
In pl/sql functions what is use of out parameter even though we have return statement. |
|
View Answer |
 |
What is COLUMN? |
|
View Answer |