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?
Spawned
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?
Concurrent:Priotity
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
SQL*Loader
Oracle Reports
Host
Immediate
Request Set Stage Function
24. Where is the Output file Generated?
<prod_top>/out/
25.
Where is the Log file Generated?
<prod_top>/log/
<prod_top>/log/
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
Hallo,
ReplyDeleteMuchas 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
Greetings Mate,
ReplyDeleteThis 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.
Thanks,
Morgan
Hi Buddy,
ReplyDeleteFully 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.
MuchasGracias,
Radhey
great article very good job !!!
ReplyDeleteH150-oracle-dba-interview-questions
Future of DBA