Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Thursday, 29 June 2017

Concurrent Program Questions and Answers

Concurrent Program Questions and Answers

Questions and Answers:

1.     What is a Concurrent program?
A concurrent program is an instance of an execution file, along with parameter definitions and incompatibilities.

2.     What is concurrent Manager?
Concurrent Managers are components of Concurrent Processing that monitor and run time-consuming, non-interactive tasks without tying up your terminal.

3.     What is Internal Concurrent Manager?
It is the boss of all the other managers. It starts up, verifies the status of , resets and shutdowns the individual managers.

4.     What is Concurrent program Executable?
A concurrent program executable links an execution file or and the method used to Execute it with a defined concurrent program.

5.     What is Concurrent Program Executable file?
A concurrent program execution file is an operating system file or database stored procedure which contains your application logic and can be executed by either invoking it directly on the command line or by invoking a program which acts upon it. It also enforces incompatibilities.

6.     What is execution method?
                 The execution method identifies the concurrent program executable  type          and the method Oracle Application Object Library uses to execute it.

7.     What is Spawned Process?
A Concurrent process that runs as a separated process than that of the concurrent manager that starts it.
8.     What method can be used for C or Pro*C executables?

9.     What is a Child Request?
                  A child request is a concurrent request submitted by another concurrent      request.

10.  What setting to make to make the concurrent program to appear in the SRS window?
Enable the option ‘Use in SRS’.

11.  Brief the steps to Run a concurrent Program?
 i.      Create the executable file
ii.      Define Executable in Apps
 iii.      Create Concurrent Program with the assignment of the executable
iv.      Attach the concurrent program to the Request Group
  v.      Ensure the Request group is attached to the specified User

12.   What is request set?
Request allows you to submit several requests together using multiple execution path.

13.  Inside Stage in Request, how the individual request process?(Choose One)
a.     Parallel      
b.      Sequential          
c.      Manager chooses the method
d.     Depends on the setting in Concurrent Program

                Ans: a. Parallel

14. Which user profile option is used to set the Priority?

15.   What is Session Control?
This is option for the database session, which includes Consumer Group, Rollback segment, Optimizer Mode.

16.  What are the Optimizer Modes available in Concurrent Program session control?
All Rows, First Rows, Rules and Choose

17.   When you go for best throughput which mode you prefer? Choose one
                                                             i.      All Rows
                                                           ii.      Choose
                                                        iii.      First Rows
                                                         iv.      Rules

Ans: i. First Rows

18.  What is Incompatibilities?
Identifies program that should not run simultaneously with your concurrent program because they might interfere with its execution.

19. What is Conflict Domain?
               It is the one, which identifies the data where two incompatible      programs          cannot run simultaneously.

20.    Which Manager will take care of Conflicts in Concurrent Processing?
                Conflict Internal Manager

21.   What is Token in Concurrent Program?
         For a parameter in an Oracle Reports program, the keyword or parameter appears here.

22.   What are the valid types of Default Type?
a.     Constant
b.     Profile
c.      SQL Statement
d.     Segment

23.  What are types of Execution Methods?
SQL*Plus Programs
PL/SQL Stored Programs
Oracle Reports
Request Set Stage Function

24.  Where is the Output file Generated?

25.   Where is the Log file Generated?

26.   What is the limit for the number of arguments for a concurrent program? (Choose One)
a.     100
b.     240
c.      32
d.     500

Ans: 100

27.    What are Concurrent Process Life Cycle Phases?
a.     Pending
b.     Running
c.      Completed
d.     Inactive

28.   What does Pending- Normal denote?
Request is waiting for the next available manager.

29.  What are the various statuses of Running Phase of a concurrent process?
a.     Normal
b.     Paused
c.      Resuming
d.     Terminating

30.   Using SRS, can you schedule a single request or a set or request to run automatically? True / False
Ans: True

31.  What is the Use of Completion Options in SRS?
             It allows you to deliver request output to others and specify which printer, and    how many copies of output you want to produce.

32.  When can you put on Hold a request?
We can hold only if the request is pending or Inactive phase.

33.  What are the various completion status of Stage function?
Success, Warning, and Error
Share this article :


  1. Hallo,

    Muchas Gracias Mi Amigo! You make learning so effortless. Anyone can follow you and I would not mind following you to the moon coz I know you are like my north star.
    This should be a simple question but I don't have a really nice way to do this...
    I want to see what object checkdb is currently checking.
    I'm currently looping every few seconds to capture locks held by the session, like this:
    SELECT *
    FROM sys.dm_tran_locks WITH (NOLOCK)
    WHERE request_session_id =
    AND resource_type = 'OBJECT'

    However this also reports
    every object that checkdb has *already* checked - it seems to do the checks within a transaction.

    Of course I can diff the locks to see the most recent taken, but depending on the size/speed of the checks this gives me a subset to choose from, which isn't great.

    Once again thanks for your tutorial.

    Thank you,
    Ajeeth Kapoor

  2. Greetings Mate,

    This is indeed great! But I think perhaps you are generally referring Concurrent Program Questions and Answers which is getting unsustainable.

    I need some help from you experts on this stored procedure..

    There are 4-5 batch procedures that will call this stored procedure. The batch will call the stored procedure with 'I' parameter in the beginning of the batch process. The batch will call the

    stored procedure with 'O' parameter at the end of the batch process. The stored procedure should write the details into the auditing table.

    But great job man, do keep posted with the new updates.


  3. Hi Buddy,

    Fully agree on Concurrent Program Questions and Answers. We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt .

    I have below kind of data

    Transaction | Debit | Credit | Begening Balance | Ending balance
    INV1 | 100 | | 300 | 400
    INV2 | | 200 | |
    INV3 | 130 | | |
    INV4 | | 150 | |

    This is above data , and we need to calculate begening balance and ending balance.
    Begening balance of INV2 will be ending balance of INV1, and begening balance of INV3
    will be ending balance of INV2, … goes on..
    And ending balance will be calculated as begening balance + debit_amount or begening_balance - credit_amount. but how can i put ending balance of current row to begening_balance of next row.
    Note - First row of begening balance and ending balance will come through gl_balances itself, but need to calculated values from 2nd row.

    Very useful post !everyone should learn and use it during their learning path.