Intelligent Oracle Apps Dba Assessment Test

10 Questions

Settings
Please wait...
Intelligent Oracle Apps Dba Assessment Test

As an Oracle Apps DBA (Oracle Applications Database Administrator), you must be specialized in Oracle Applications Server architectures like a normal Oracle DBA but skills in business administration is also essential.


Questions and Answers
  • 1. 
    In which directory is a .dbc file stored?
    • A. 

      #FND_TOP/secure

    • B. 

      FND_SECURE

    • C. 

      SOA_HTML/

    • D. 

      $FND_TOP/log

  • 2. 
    How can a patch be applied without putting Application 11 in Maintenance Mode?
    • A. 

      Options=hotpatch

    • B. 

      Options=patch

    • C. 

      Options=coolpatch

    • D. 

      Options=null

  • 3. 
    Where is Jserv configuration files stored?
    • A. 

      $COMMON_TOP/admin/scripts/$CONTEXT_NAME

    • B. 

      $IAS_ORACLE_HOME/Apache/Jserv/etc

    • C. 

      $APPLCSF/$APPLOG

    • D. 

      $AD_TOP/bin

  • 4. 
    Which of the following is displayed by top command?
    • A. 

      Top 10 processes taking high CPU

    • B. 

      Top 5 processes taking high CPU

    • C. 

      Top 20 processes taking high CPU

    • D. 

      Top 5 processes taking high memory

  • 5. 
    Which of the following is not a type of patch?
    • A. 

      Oneoff

    • B. 

      Mini packs

    • C. 

      Roll off

    • D. 

      Threeoff

  • 6. 
    Which of these patches will upgrade an application from one version to another when applied?
    • A. 

      Family packs

    • B. 

      Maintenance packs

    • C. 

      Rollup

    • D. 

      Mini packs

  • 7. 
    How can you know a patch has been applied or not?
    • A. 

      Do a Google search

    • B. 

      Query ad_bug

    • C. 

      Query_add_applied_patches

    • D. 

      Query adpatch

  • 8. 
    How can you apply a patch?
    • A. 

      Adpatch

    • B. 

      Ad_bug

    • C. 

      Ad_applied_patches

    • D. 

      Ad patches

  • 9. 
    Which of the following can be used to check and manage the status of workers?
    • A. 

      FNDLOAD

    • B. 

      SQLLOADER

    • C. 

      Adctrl

    • D. 

      Oral

  • 10. 
    What are the parameters autoconfig will ask for?
    • A. 

      Admin name and password

    • B. 

      Username and password

    • C. 

      Email address and password

    • D. 

      Context file name and password