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.
Stats the term ERD?
Explain the following term: a) ROLAP b) MOLAP
Illustrates the ways to tune Reporting Services?
Briefly describe the differentiation between Data warehousing and Business Intelligence?
Explain the way of establishing connection by ODBC.
Write about the term Attribute, Entity and Relationship?
Illustrates the recursive stored procedures?
What do you understand by the term locking in DBMS?
Contrast a network and hierarchical database model?
Explain how is the HASH file used and where we can use it?
18,76,764
1958741 Asked
3,689
Active Tutors
1416831
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!