Recompile package body after recompiling package requirement
In which circumstance should you recompile the package body after recompiling the package requirement?
Expert
Recompile the package body after recompiling the package requirement:
1. Changing the argument list of one of the constructs package
2. Any modification made to one of the package constructs
3. Any of SQL statement modification made to one of the package constructs
4. Eliminating a local variable by the DECLARE section of one of the package constructs.
Describe some of the chrematistics of good data definitions.
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Illustrates the term normalization?
Explain the performance of SQL Server Reporting Services.
Illustrates the implementation of business logic within stored procedures?
What is cmaxpktsz good for in Sybase?
Write down the level of Granularity of a fact table?
Explain the term power center repository?
Illustrates the various extensions for stored procedures?
Specify the enhancements which are made within datastage 7.5 and also compare with the 7.0?
18,76,764
1940639 Asked
3,689
Active Tutors
1428862
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!