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