|
Question |
Rating |
View Answer |
|
What is stored procedure?
|
|
View Answer |
|
what is the difference between stored procedures and stored functions in ORACLE
|
|
View Answer |
|
Explain about the process which takes place to execute a Stored routine? |
|
View Answer |
|
What is cursors? |
|
View Answer |
|
Can we use commit inside the trigger? If not then how can we save the transxaction made by the trigger? |
|
View Answer |
|
How can we call stored procedures inside store procedures? |
|
View Answer |
|
Explain about the difficulties faced by the database developer in implementing pre compiled statements? |
|
View Answer |
|
What is the difference between a user defined function and a Stored procedure? |
|
View Answer |
|
State the different extensions for stored procedures? |
|
View Answer |
|
Explain the benefits of running stored procedure on a database engine? |
|
View Answer |
|
how many types of stored procedure? |
|
View Answer |
|
What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS
|
|
View Answer |
|
Does storing of data in stored procedures increase the access time? Explain? |
|
View Answer |
|
What is the difference between stored procedures and stored functions in ORACLE
|
|
View Answer |
|
How one call DDL statement using stored procedures in Oracle? |
|
View Answer |
|
Where the procedures are stored in database? |
|
View Answer |
|
State about the security aspects of stored procedures? |
|
View Answer |
|
Explain about the implementation of business logic in Stored procedures? |
|
View Answer |
|
What are external procedures ? Why and when they are used?
|
|
View Answer |
|
What are the uses of stored procedure? |
|
View Answer |