Intelligent Oracle Apps Dba Assessment Test

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Cripstwick
C
Cripstwick
Community Contributor
Quizzes Created: 636 | Total Attempts: 763,111
Questions: 10 | Attempts: 167

SettingsSettingsSettings
Intelligent Oracle Apps Dba Assessment Test - Quiz

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

    Correct Answer
    B. FND_SECURE
    Explanation
    The correct answer is FND_SECURE. This is because the .dbc file is typically stored in the FND_SECURE directory.

    Rate this question:

  • 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

    Correct Answer
    A. Options=hotpatch
    Explanation
    A hotpatch allows a patch to be applied without putting the application in maintenance mode. This means that the patch can be applied while the application is still running and accessible to users. Hotpatching involves injecting the patch into the running application without the need for a restart or downtime, ensuring continuous availability of the application. This method is often used for critical updates or patches that need to be applied quickly without disrupting the application's operation.

    Rate this question:

  • 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

    Correct Answer
    B. $IAS_ORACLE_HOME/Apache/Jserv/etc
    Explanation
    The Jserv configuration files are stored in the directory $IAS_ORACLE_HOME/Apache/Jserv/etc.

    Rate this question:

  • 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

    Correct Answer
    A. Top 10 processes taking high CPU
    Explanation
    The correct answer is "Top 10 processes taking high CPU." The top command is a Linux utility that provides real-time information about processes running on a system. It displays a dynamic, ordered list of running processes, with the highest CPU usage at the top. By specifying "Top 10 processes taking high CPU," the command will display the top 10 processes that are currently utilizing the most CPU resources.

    Rate this question:

  • 5. 

    Which of the following is not a type of patch?

    • A.

      Oneoff

    • B.

      Mini packs

    • C.

      Roll off

    • D.

      Threeoff

    Correct Answer
    D. Threeoff
    Explanation
    The options provided are all types of patches except for "Threeoff". "Oneoff" refers to a patch that is applied only once, "Mini packs" are small patches that fix specific issues, and "Roll off" is a type of patch that is applied to a specific version of software. However, "Threeoff" is not a recognized term for a type of patch, making it the correct answer.

    Rate this question:

  • 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

    Correct Answer
    B. Maintenance packs
    Explanation
    Maintenance packs are patches that are specifically designed to upgrade an application from one version to another when applied. They contain bug fixes, performance improvements, and new features that help enhance the functionality and stability of the application. Family packs, rollups, and mini packs may also contain patches, but they are not specifically intended for upgrading the application to a new version.

    Rate this question:

  • 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

    Correct Answer
    B. Query ad_bug
    Explanation
    Querying ad_bug is a way to check if a patch has been applied or not. By running this query, it will provide information about any bugs or patches that have been applied in the system. This query is commonly used to verify if a specific patch has been successfully applied or not.

    Rate this question:

  • 8. 

    How can you apply a patch?

    • A.

      Adpatch

    • B.

      Ad_bug

    • C.

      Ad_applied_patches

    • D.

      Ad patches

    Correct Answer
    A. Adpatch
    Explanation
    Adpatch is a utility used in Oracle E-Business Suite to apply patches. It is a command-line tool that allows users to apply patches to the system. By running the adpatch command, users can initiate the patching process and apply the necessary updates to the Oracle E-Business Suite. This utility ensures that patches are applied correctly and efficiently, helping to maintain the stability and functionality of the system.

    Rate this question:

  • 9. 

    Which of the following can be used to check and manage the status of workers?

    • A.

      FNDLOAD

    • B.

      SQLLOADER

    • C.

      Adctrl

    • D.

      Oral

    Correct Answer
    C. Adctrl
    Explanation
    Adctrl can be used to check and manage the status of workers. Adctrl is a utility in Oracle Applications that allows users to control and monitor concurrent processing. It provides options to start, stop, and monitor concurrent manager processes and workers. With Adctrl, users can view the status of workers, such as whether they are running, completed, or on hold. It also allows users to manage the concurrent processing queue by controlling the submission and execution of concurrent requests.

    Rate this question:

  • 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

    Correct Answer
    D. Context file name and password
    Explanation
    Autoconfig is a tool used for automatically configuring software or systems. In this case, the parameters that autoconfig will ask for are the context file name and password. The context file contains important configuration information for the software or system, and the password is required to access and modify this file. By providing these parameters, autoconfig can effectively configure the software or system based on the specified context file and its associated settings.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 14, 2018
    Quiz Created by
    Cripstwick
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.