Accenture Interview Questions For Oracle Apps Dba

What are the latest ORA errors you have encountered?

Usually, we will get the ORA errors like unable to extend the tablespace by so and so size. And we will check those tablespaces for space, if space is not there we will resize the data file and add one more datafile.

How you apply a patch?

A patch will create FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS table when it will apply d,g, and u drivers

2 What is the sequence?

For numerical columns in database tables, a sequence produces a serial list of unique numbers. For data where we want to insert data in a systematic way, we may use the sequence on columns.

What is a Value Set?

Ans: The value set is a collection (or) container of values.

  • Whenever the value set associated with any report parameters. It provides a list of values to the end-user to accept one of the values as the report parameter value.
  • If the list of values needed to be dynamic and ever-changing and define a table based values set.
  • 3 How long does it take for the SYSTEM tablespace to be created?

    Every database in Oracle has a tablespace called SYSTEM, which is generated automatically when the database is created. It also includes a data dictionary table for the entire set of data.

    3 What is the adpatch log file location?

    When u unzip a patch it will keep all the files related to a particular product under that directory inside u r patch directory for example if the patch delivering files related to the FND product then it will create a subdirectory under the patch directory with the name FND in which it will put all related files to that product

    How to find opatch Version?

    Opatch is a utility to apply database patch, In order to find opatch version execute”$ORACLE_HOME/OPatch/opatch version” You can check OPatch -lsinventory

    6 How an API is initialized?


    3 What are the types of Concurrent Managers 25?


  • Internal Concurrent Manager (ICM): This is the one that monitors all other CMs
  • Standard Manager (SM): This takes care of report running and batch jobs
  • Conflict Resolution Manager (CRM): checks concurrent program definitions for compatibility checks.
  • We cannot delete a concurrent manager… but we can disable it… but it’s not recommended.

    5 Explain how the “Database Writer” process works?

    Multiple database context processes are possible. In the operating system, they are referred to as “DBWn.” This method is in charge of storing “dirty” buffers on disc. When a server process has to update a data block, it first reads it from disc into the buffer cache if it isn’t already there, and then updates the cache copy. So, a “dirty” block refers to a modified database block in the buffer cache.

    1 What is a mini pack?

    A mini pack is one that will upgrade any product patchset level to the next level like AD.H to AD.I

    5 What is a Set of Books?

    Ans: A financial reporting entity that uses a particular chart of accounts, functional currency, And accounting calendar. Oracle General Ledger secures transaction information (such as journal entries and balances) by a set of books. When you use Oracle General Ledger, you choose a responsibility that specifies a set of books. You then see information for that set of books only.

    I am applying a patch, can I open another session in another node and run adpatch?

    No, because it will create tables while running the first session when you start the 2nd session it will fail due to the first

    Oracle Apps dba Interview with US Top MNC in USA

    Related Posts

    Leave a Reply

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