Interested to Buy Any Domain ? << Click Here >> for more details...
What are advantages fo Stored Procedures?
- 1 Answers
- 3238 Views
- I also Faced
- E-Mail Answers
Answer / nishi
1 security
Stored procedures can help enforce data security. You can restrict the database operations that users can perform by allowing them to access data only through procedures and functions. For example, you can grant users access to a procedure that updates a table, but not grant them access to the table itself. When a user invokes the procedure, the procedure executes with the privileges of the procedure's owner. Because users only have the privilege to execute the procedure and not the privileges to query, update, or delete from the underlying tables, users can invoke the procedure, but they cannot arbitrarily manipulate table
data in any other way.
2 performance
Reduces network traffic as compared to no. of individual SQL sent Since procedure's complied form is available in the database, no compilation step required to execute the code.If procedure is present in SGA then retrieval from disk is not required and execution can begin immediately.
3 Memory allocation
Since stored procedures take advantage of shared memory capabilities of ORACLE, only a single copy of the procedure needs to be loaded into memory for execution by multiple users.
4 productivity
Stored procedures increase development productivity. By designing applications around a common set of procedures, you can avoid redundant coding and increase your productivity.
5 Integrity
By developing all of your applications around a common group of procedures, you can reduce the likelihood of committing coding errors.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the uses of synonyms?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Which are the five query types available in oracle?
Why do you create or replace procedures rather that drop and recreate.
Can group functions be mixed with non-group selection fields?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How can we find the size of a database?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
what is load balancing and what u have used to do this?(sql loader)
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
Explain the relationship among Database, Tablespace and Data file?
Oracle General 
