Top 30+ Oracle Demantra Interview Questions And Answers

Oracle Demantra Interview Questions and Answers from Codingcompiler – In this article we have prepared the most frequently asked Oracle Demantra Interview Questions and Answers for beginners and experienced by covering all the core areas by professionals.

Table of Contents

Oracle Demantra Interview Questions

Q1) What is Oracle Demantra?
Q2) List out some of the Demantra Applications.
Q3) Few benefits of Demantra Implementation?
Q4) How to Install the Demantra Base Application or Patches?
Q5) What are the three modules that can be implemented separately?
Q6) Error starting the Web Server and/or deploying the Demantra WAR file
Q7) Errors with the Demantra Batch or Simulation Engine
Q8) What happens if RVWR cannot write to disk?
Q9) Issues with EBS Integration to Demantra
Q10) What happens if RVWR cannot write to disk?

Oracle Demantra Interview Questions and Answers

Q1) What is Oracle Demantra?

Oracle Demantra is a demand management and supply chain management tool provided by Oracle. It helps in enabling automated forecast process that simultaneously maps demand forecasting against factors such as supply restrictions, customer commitments and inventory counts. Implementation of Oracle Demantra has numerous benefits like higher service levels, lower inventory costs, greater customer satisfaction and lower distribution costs.

Q2) List out some of the Oracle Demantra Applications.

Predictive Trade Planning
Demand Management
Trade Promotion Optimization
Deduction and Settlement Management
Advanced Forecasting & Demand Modeling

Q3) Few benefits of Demantra Implementation?

Demantra implementations results in:

Higher service levels
High customer satisfaction
Cheaper inventory costs
Lower distribution costs

Q4) How to Install the Demantra Base Application or Patches?

Create a C:/Tmp folder on the machine where the setup.exe will be executed prior to the installation as this will generate a log file to this folder

Note that there will also be some ancillary logs under the following folders:

Demand Planner\Database Objects\Oracle Server (Oracle back end database)

Demand Planner\Database Objects\Microsoft SQL Server (Sql Server back end database)

Q5) What are the three modules that can be implemented separately?

Demand Management.
Advance Forecasting and Demand Modeling(AFDM)
Real-Time Sales and Operations Planning

Q6) Error starting the Web Server and/or deploying the Demantra WAR file

Review the Collaborator.log which is found under the …Collaborator\demantra\logs folder on the webserver where Demantra is running.

Also, each individual webserver (ex. OAS, JRUN, Tomcat, Websphere, etc…) will have their own individual logs in various directories which can also be consulted.

The individual webserver documentation should be reviewed for these log locations.

Q7) Errors with the Demantra Batch or Simulation Engine

The key engine logs are found under the root drive of the machine where the engine is launched. The folder that holds these logs usually have Engine2k somewhere in the name.

Note that there should be at least Engine2k logs (these are the logs that show the actual splitting and forecasts that the engine does) in this folder.

However, to write the master EngineManager logs to this folder you need to go to the Engine Administrator (..Demand Planner\Analytical Engines\bin –> Settings –> Configure) and change the Engine Manager Log tab from STD to FILE.

It is NOT advised to re-register the engine after making this change

Frequently Oracle Demantra Interview Questions and Answers

Q8) What happens if RVWR cannot write to disk?

It depends on the context where the write error occurs:
If there’s a Guaranteed Restore Point, the database crashes to ensure the restore point guarantee is not voided.
If there isn’t a Guaranteed Restore Point and it’s a primary database, the Flashback Mode will be automatically turned off for the database, which will continued to operate normally.
If there isn’t a Guaranteed Restore Point and it’s a standby database, the database will hang until the cause of the write failure is fixed.

Q9) Issues with EBS Integration to Demantra

In general, most EBS side activities (ex. Planning Data Pull) can be logged using Note 245974.1 however, the Shipment and Bookings Collection job can have extra logging turned on by changing MSD_DEM: Debug Mode to Yes (default is No).

Note that as the Shipment and Bookings Collection job moves to the other side of the wall from EBS side of the database to the Demantra side of the database (usually indicated by when you start seeing references to the Demantra schema or tables like t_src_items_tmpl or t_src_sales_tmpl_err) then the errors may need to be tracked using the Workflow or Active_Proc_Dyn troubleshooting sections of this note.

Q10) What happens if RVWR cannot write to disk?

It depends on the context where the write error occurs:
If there’s a Guaranteed Restore Point, the database crashes to ensure the restore point guarantee is not voided.
If there isn’t a Guaranteed Restore Point and it’s a primary database, the Flashback Mode will be automatically turned off for the database, which will continued to operate normally.
If there isn’t a Guaranteed Restore Point and it’s a standby database, the database will hang until the cause of the write failure is fixed.

Q11) Is There A Separate Background Process For Writing Flashback Logs?

A: Yes. RVWR (Recovery Writer, a.k.a Flashback Writer) was introduced in Oracle 10g to write flashback data from the Flashback Buffer in the SGA to the flashback database logs on disk.

Q12) Do I Need To Shutdown And Mount The Database To Turn Flashback On?

A: ALTER DATABASE FLASHBACK ON is an online operation in 11g Release 2. In 10g Release 2 the database must be mounted, but not open.

Once flashback is turned on Oracle starts to save the before-images of the database blocks before they are changed. This guarantees that the database can be flashbacked to the exact point-in-time when the flashback mode was turned on.\

Q13) Requirements for Enabling Flashback Database

The requirements for enabling Flashback Database are:

Your database must be running in ARCHIVELOG mode, because archived logs are used in the Flashback Database operation.
You must have a flash recovery area enabled, because flashback logs can only be stored in the flash recovery area.
For Real Application Clusters databases, the flash recovery area must be stored in a clustered file system or in ASM.

Q14) Is It Possible To Specify The Size Of The Flashback Buffer In The SGA?

A: Yes, but indirectly. The size of the Flashback Buffer is set to 2 * LOG_BUFFER.

For performance reasons, it’s recommended to set LOG_BUFFER to at least 8MB for

databases running in Flashback Mode.

UPDATE: For large 11.1.0.7+ databases with more than a 4GB SGA, you may consider setting LOG_BUFFER to values in the range of 32-64 MB.

Advanced Oracle Demantra Interview Questions and Answers For Experienced

Q15) How To List Restore Points In RMAN?

A: In RMAN you can use the LIST RESTORE POINT [ALL|restore_point_name] command. If you use a recovery catalog you can use the view RC_RESTORE_POINT in the recovery catalog repository, or the command the V$RESTORE_POINT in the target database.

Q16) Can RMAN be used to backup flashback logs?
No. Flashback Logs are not backed up. Even if the command BACKUP RECOVERY AREA is used to backup the contents of the FRA to tape only the following file types are backed up: full and incremental backup sets, control file autobackups, datafile copies, and archived redo logs.

Flashback Logs are considered to be transient files and cannot be backed up by RMAN. They are not needed for media recovery.

Q17) Can we state the size of the Flashback Buffer in the SGA?

Yes, it can be done but indirectly.

The size of the Flashback Buffer = 2 * LOG_BUFFER.

Due to performance reasons, LOG_BUFFER should be set to minimum 8MB for databases running in Flashback mode.

“Oracle Demantra Interview Questions and Answers Prepared By Experts will help you to Crack Your Job Interview”

Q18) Product Features Overview

The Oracle Demantra applications suite contains these products:

Oracle Demantra Demand Management
Oracle Demantra Advanced Forecasting and Demand Modeling
Oracle Demantra Real-time Sales and Operations Planning
Oracle Demantra Predictive Trade Planning
Oracle Demantra Trade Promotion Optimization
Oracle Demantra Deductions and Settlement Management

Q19) What are the requirements for enabling Flashback Database?

Your database must be running in ARCHIVELOG mode, because archived logs are used in the Flashback Database operation.
You must have a flash recovery area enabled, because flashback logs can only be stored in the flash recovery area.
For Real Application Clusters databases, the flash recovery area must be stored in a clustered file system or in ASM.

Q 20) What are the FEATURES AND BENEFITS of Oracle Demantra?

Oracle Demantra Demand Management solution lets you sense, plan for, and proactively respond to demand by sharing a one-number plan that aligns your organization across departments and users.
Demantra Demand Management allows you to model new products based on the lifecycle of existing products, or you can model new products or versions that supersede existing products.
Oracle Demantra Real-time Sales & Operations Planning gives planners and managers the information and planning tools they need to take command of day-to-day planning processes.
Oracle Demantra Real-time Sales & Operations Planning provides the foundation for a responsive sales and operation planning process that enables the current and emerging best practices in adaptive demand-driven planning.
Demantra Predictive Trade Planning gives you unparalleled accuracy and sophistication in volume forecasting, pre-event simulation, and post-event evaluation, all at account managers’ fingertips.

Q20) What will you do if you face any issues starting the web server or Demantra WAR file?
We need to revisit and explore the Collaborator.log file in case of any issues. This log file is located at Collaborator demantra logs folder in the Oracle Demantra webserver. Moreover, every individual webserver will possess logs in different directories. These logs can also help us to dig further. These log locations will be specified in the respective webserver documentation.

Q21) What is RMAN command?
Establish a channel, which is a connection between RMAN and a database instance. ALLOCATE CHANNEL FOR MAINTENANCE. Allocate a channel in preparation for issuing maintenance commands such as DELETE . BACKUP. Back up database files, copies of database files, archived logs, or backup sets.

Q22) How To List Restore Points In Rman?
In RMAN you can use the LIST RESTORE POINT [ALL|restore_point_name] command. If you use a recovery catalog you can use the view RC_RESTORE_POINT in the recovery catalog repository, or the command the V$RESTORE_POINT in the target database.

Oracle Demantra Interview Questions and Answers

Oracle Demantra Interview Questions

Frequently Oracle Demantra Interview Questions and Answers

Advanced Oracle Demantra Interview Questions and Answers For Experienced

OTHER INTERVIEW QUESTIONS

Leave a Comment Cancel reply