Merits of employing stored procedures
Illustrate the main merits of employing stored procedures?
Expert
The merits of stored procedures are as follows:
(1) Superior security,
(2) Reduced the network traffic.
(3) Fact which the SQL can be optimized.
(4) Code sharing that leads to less work, specialization among developers.and standardized processing.
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Give a brief introduction of the term BUS Schema?
Explain how is the HASH file used and where we can use it?
Explain the Filter transformation?
What is Redundant Array of Inexpensive Disks and what are various types of RAID configurations?
Write a short note on the difference between a dynamic and materialized view?
Provide a brief introduction of the term cubes?
Under what conditions should indexes are employed?
Write down a short note on the difference between an ERD and EER.
What is the simplest sorting method to utilize in data structures?
18,76,764
1938975 Asked
3,689
Active Tutors
1413866
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!