Peoplesoft Question:

If we use SQL and Call section at same time then Database deadlock will occur. Why does this Dead lock Occur?

Peoplesoft Interview Question
Peoplesoft Interview Question

Answer:

When a SQL is run, there is a lock on the table by the database until that section is completed. If during that time there runs some other process, which will use the same table locked by our section using call section, this process will fail.


Previous QuestionNext Question
What is Activity Type? What is Cost Center? What is GAP Analysis? Explain with real time scenario.What are all the steps involved in Upgrade process?