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

Cripstwick

Community Contributor

Quizzes Created: 636 | Total Attempts: 796,915

Questions: 10 | Attempts: 171 | Updated: Mar 21, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

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: