|
Related Questions |
View Answer |
|
What is a cursor ? Why Cursor is required ?
|
View Answer
|
|
Explain the two type of Cursors ?
|
View Answer
|
|
What are the PL/SQL Statements used in cursor processing ?
|
View Answer
|
|
What are the cursor attributes used in PL/SQL ?
|
View Answer
|
|
What is a cursor for loop ?
|
View Answer
|
|
What will happen after commit statement ?
|
View Answer
|
|
Explain the usage of WHERE CURRENT OF clause in cursors ?
|
View Answer
|
|
What is a database trigger ? Name some usages of database trigger ?
|
View Answer
|
|
How many types of database triggers can be specified on a table ? What are they ?
|
View Answer
|
|
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
|
View Answer
|
|
What are two virtual tables available during database trigger execution ?
|
View Answer
|
|
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
|
View Answer
|
|
Write the order of precedence for validation of a column in a table ? I. done using Database triggers. ii. done using Integarity Constraints.
|
View Answer
|
|
What is an Exception ? What are types of Exception ?
|
View Answer
|
|
What is Pragma EXECPTION_INIT ? Explain the usage ?
|
View Answer
|
|
What is Raise_application_error ?
|
View Answer
|
|
What are the return values of functions SQLCODE and SQLERRM ?
|
View Answer
|
|
Where the Pre_defined_exceptions are stored ?
|
View Answer
|
|
What is a stored procedure ?
|
View Answer
|
|
What is difference between a PROCEDURE & FUNCTION ?
|
View Answer
|