Aia 11G Interview Questions

Looking at the DP that gets generated, it looks like they can be manually created, without going through the AIA LCW, BOM generation, etc. I know it is not the approach suggested as per AIA flow, but is there anything wrong with doing it?

There is nothing really wrong with hand-crafting the DP except that you lose the overall stream of information from start to end in your development lifecycle. But some customers actually decided to do it this way, though.

Top Oracle DBA Interview Questions and Answers


Many organizations are hiring Oracle DBA experts to meet their requirements and the needs and demands of their customers. In case you are looking for Oracle DBA interview questions, this is the correct place for you. These Oracle Apps DBA interview questions and their answers are prepared by industry experts who have more than 8–12 years of experience in Oracle DBA. Let’s start by looking at a few of the most frequently asked Oracle DBA interview questions.

Listed below are the two parts into which this Oracle DBA Interview Questions blog is divided:

Q22) What is the Decision service?

Ans: Oracle SOA Suite provides support for Decision components that support Oracle Business Rules. A Decision component is a mechanism for publishing rules and rule sets as a reusable service that can be invoked from multiple business processes. These rules can be changed without redeploying the code.

1 How do you switch from an init.ora file to a spfile?

To switch from an init.ora file to a spfile, we should create spfile from pfile command then shutdown instance and startup once again

Q9) What is the SOA Suite 11g Components?


  • Oracle Adapters
  • Oracle Mediator
  • Business Events and Events Delivery Network
  • Oracle Business Rules
  • Human Workflow
  • Oracle Business Activity Monitoring
  • Oracle Enterprise Manager
  • Q4) What is SOA governance? What are its functions?

    Ans: Service-Oriented Architecture (SOA) governance is a concept used for activities related to exercising control over services in an SOA Some key activities that are often mentioned as being part of SOA governance are:

  • Managing the portfolio of services: This includes planning the development of new services and updating current services.
  • Managing the service lifecycle: This is meant to ensure that updates of services do not disturb current services to the consumers.
  • Using policies to restrict behavior: Consistency of services can be ensured by having the rules applied to all the created services.
  • Monitoring performance of services: The consequences of service downtime or underperformance can be severe because of service composition. Therefore action can be taken instantly when a problem occurs by monitoring service performance and availability.
  • What are the various databases available in the market?

    There are many databases available in the market. The commonly used databases are Oracle,

    IBM db2, Microsoft SQL Server, Microsoft Access, MySQL and SQLite, PostgreSQL, MariaDB.

    Intellipaat gives its learners industrial training in SQL Courses. Enroll now to get a professional certificate!

    Q7) Is Oracle SOA the same as Oracle Fusion Middleware?

    Ans: No, because SOA is one of the parts in Fusion middleware and SOA behaves like a user interface whereas Fusion is a big platform

    2 What do you mean by Recovery Catalog?

    The recovery catalog is a database scheme that contains the metadata that RMAN manages for data restoration and recovery processes. The metadata used by RMAN for reinstallation and healing process is stored in a recovery catalog. The RMAN metadata is still present in the recovery catalogue even if the target control file and all backups are lost.

    5 Most Common Interview Questions!

    Related Posts

    Leave a Reply

    Your email address will not be published. Required fields are marked *