Stored-procedures and its advantages
Explain about the stored-procedures and its advantages.
Expert
Stored procedures are database objects which perform a user defined operation.
Well a stored procedure can contain a set of compound SQL statements. It executes the SQL commands and returns the product to the client. All stored procedures are utilized to decrease network traffic.
Write brief note on E.F. Codd, and why is he noteworthy in the development of modern database systems?
What is meant by the parameter file?
Elucidate what are the basic requirements to join two sources in the source qualifier?
Explain the Stored Procedure transformation?
Explain does PL/SQL carry overloading?
partial specialization and total specialization rules in enhanced erd.......
Illustrates the recursive stored procedures?
Illustrates the difference between a file server and database server?
Describe in brief about the Mobile enterprise application enablement?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
18,76,764
1926727 Asked
3,689
Active Tutors
1448933
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!