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 what is meant by the WebI or Web Intelligence?
Explain the advantage of Table Partitioning with bcp in Sybase?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Explain how the Chasm trap is solved?
What is meant by the Data Mining?
Why there is a need to create the user object?
Briefly describe the reason of synchronization function offered in Analysis Services 2005 ?
List out the various schemas which are supported by the BO Designer?
Explain about a Cartesian product?
Describe the difference between complexType elements and simple elements?
18,76,764
1923486 Asked
3,689
Active Tutors
1441642
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!