Ranganath's Oracle Apps

1. Explain:  a.) Integrity Constraints It can be called as a declarative way in order to define a business rule for a table's column b.) Index - It can be called as an optional structure which is associated with a table for direct access to the rows - Index can be created for one or more columns in a table c.) Extent - It can be defined as a specific number of contiguous data blocks in single allocation. - It is used to store a specific type of information. 2. What is ANALYZE command used for? ANALYZE command is used to perform various functions on index, table, or cluster, as listed below: - It helps in dentifying migrated and chained rows of the table or cluster. - It helps in validating the structure of the object. - It helps in collecting the statistics about object used by the optimizer. They are then stored in the data dictionary. - It helps in deleting statistics used by object from the data dictionary.  3.  a.) List the types of joins...

Application Implementation Methodology :- -------------------------------------------------- Application Implementation Methodology in short referred as AIM. AIM- Oracle’s Application Implementation Methodology is a proven approach to implement Oracle Applications. AIM defines an organization’s business needs at the beginning of the project and maintains their visibility through out the implementation AIM Phases-AIM project is conducted in phases. The phases provide quality and control checkpoints to coordinate project activities that have a common goal. The phases are 1)  Definition - During this phase, we plan the project ,review the organization’s business objectives ,understand the business processes and evaluate the feasibility of meeting those objectives under time, resources and budget constraints. The emphasis is on building an achievable work plan and introducing guidelines on how the organization will work to achieve the objectives.To achieve an early underst...