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.
Briefly describe the differentiation between the EXCEPT and INTERSECT operators?
What is meant by the Drill Through?
Explain the term Vdisk and how this will communicate along with physical data storage at the time of data retrieval by AMP?
Illustrates the term data structure?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Write about the orabulk and bcp stages?
Illustrates the uses of C++ in Clipper?
Give a brief introduction of the term Dimensional Modeling?
Illustrates the data structures used to do recursion?
Write a brief note on the differences between a data warehouse and data mart?
18,76,764
1929589 Asked
3,689
Active Tutors
1457076
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!