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.
Write down a short note on XML and also describe the uses of it?
Specify the System variables?
Write a short on the differences of the two principal types of packaged data models.
define types of transaction failures and also what is meant by catastrophic failure?
Define the term Event studio?
What are the drawbacks of the client or server model?
Define the term Smoothing.
Write down brief note on the issues for database performance?
Explain the types of views within Data stage Director?
Write down the purpose of Fact-less Fact Table?
18,76,764
1955243 Asked
3,689
Active Tutors
1427110
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!