Intelligent Oracle Apps Dba Assessment Test

10 Questions | Total Attempts: 127

SettingsSettingsSettings
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