If a cursor is open, how can we find in a pl/sql block?

1277

Case Study Please read the case given below and answer the questions given at the end. One afternoon in June 1972, Rao, industrial engineer of P.M.A. company, was called to the office of his immediate superior V.R. Naik, the production manager. Naik said, “Rao, I want to discuss a situation in the production department. A lot of people feel that Govindan is not the right man for the Assistant Superintendent’s position. The President and others have decided that I have got to fire Govindan or at least move him out of production. Everyone wants to fire Govindan, but I won’t do it to him. I was talking with Bhadra this morning, and we decided that you might be able to make use of Govindan in your department.” Rao was surprised by both the information, and the proposal. Naik concluded his comments with, “Rao, I am asking you to take Govindan. You can say ‘No’. But then he gets fired. I have told Govindan this. Also, Govindan knows that if he goes with you he will take a pay cut. However, I think you can make use of him both to your own and his satisfaction. You are, anyway, carrying out an in-process quality control, and you might be able to make good use of Govindan in view of his long technical experience of production work. Think it over, and let me know by tomorrow.” Rao thought over the matter. PMA company had been a successful enterprise until March 1972 at which time it suffered a sharp decline of profits : sales had fallen off, and production costs had risen. The President adopted three measures which he hoped would improve the condition. First, by creating an Industrial Engineering Department for establishing work standards on all production operations, to determine which manufacturing costs were out of line and where remedial action should be taken. Rao, 28 years old, who had been with the company for two years in the Purchasing department, was selected. Rao had B.E. and MBA degrees to his credit. What he lacked in his business experience he made up by his eagerness to learn. He was ambitious and liked by his associates. He wanted a transfer from Purchasing to Production for better opportunities for advancement. Secondly, he consulted a Management Consultation firm to make a study of the Production Department. They pointed out that the chain of command was too long from Production Manager through Plant Superintendent through Assistant Superintendent to Foremen. They recommended the elimination of the position of Assistant Superintendent. Thirdly, he engaged an Industrial Psychologist to appraise all the Supervisory Personnel. Govindan had been with the company for 20 years since its founding and during this period had worked on every production operation, and his last 11 years had been in supervisory capacity. His manners were rough and aggressive, he had little formal education. The industrial Psychologist’s report about Govindan contained the following points: (i) Evaluation for the position of Assistant Superintendent : Not good enough. (ii) Capacity for good human relations in supervision : Will have friction frequently. (iii) Need for development counseling: Counseling greatly needed. (iv) General evaluation: Govindan had a good ability profile. He suffers from a sense of inferiority. He does not like the responsibility of making decisions. His supervision is that of Autocratic type. Though he has the ability, as far as his personality make-up is concerned, he is out of place in the present position. Questions: 1. What is the problem in the case? Explain. 2. Explain Govindan’s behavior and work experience vis-à- vis the psychologist’s report. 3. How do you see Naik’s suggestion to Rao? Give reasons. 4. What are Rao’s considerations in taking a decision? What should he do? Explain.

6522

HI ALL ,IAM NEW TO THIS FORUM,COULD ANYONE PLZ FOWAED INTERVIEW QUESTIONS/FAQs ON BASE CUST ,CIC AND MARKETING TO MY E-MAIL ID RAO317@GMAIL.COM.......Shiva THANKS

2436

How to Remove drives listed in a TDriveComboBox ?

1978

Hello sir I am going to give section engineer examination and will be held in 2010. So I need all prevous years examination papers. please send it on my email id : bhalchandrap@yahoo.co.in

2163

What are you expecting from Kaiser Permanente in the future?

1195

sir please provide me the previous technical papers for hpcl writtien exam

2098

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2074

Do you know what version of laravel do you generally use?

848

Explain demographic parity and its importance in AI fairness.

86

Do you have recombinant protein expression experience? Explain?

2898

How can I get free .NET add-in for QTP9.2. What is the process to install any add-in?

2479

What is the last major networking problem you troubleshot and solved on your own in the last year?

2163

In PFI plant one stage capacitor connection is directly connected(with out megnetic contact controll). but why?

2393

what is tds rate of WCT applay for sale tax ragistard company.

2729