What are the default Oracle triggers??2 14213
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.1 5603
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.4 7166
What are the difference between Functions/Stored Procs and Triggers and where are they used.1 3772
Can you have multiple SPs with the same name on a database?2 4477
Can you create a table with Primary Key not as the clustered index.2 5105
Can you have multiple SPs with the same name on a database?6 7391
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.5 4796
can i create trigger on synonym is it possible or not please help me4 7336
The principle of switching circuits for different types of batteries in application of storage systems
What is category in wordpress? Explain
A power transformer 4MVA/11KV/0.415Kv has been out of use in 12years. what maintenance actions/test need to be carried out before energizing.
What are the advantages/disadvantages of using inline and const?
What are date and time intervals?
Describe technical problems that you had with selenium tool?
Can you list any other cms better than wordpress?
6. Case Study:- A Failure to Communicate Could you come to my office for a minute, Bob?’ Asked Terry ( the plant manager ). Sure, be right there,” said Bob Gemson. Bob was the plant’s quality control director. He had been with the company for four years. After completing his degree in mechanical engineering, he worked as a production supervisor and then as maintenance manger prior to promotion to his present job. Bob thought he knew what the call was about. “But letter of resignation catches me by surprise,’ began Terry. “1 know that Wilson products will be getting a good man, but we sure need you here, too”. “J thought about it a lot, ‘said Bob, “but there just doesn’t seem to be a future for me here. “ “Why do you say that’?” asked Terry. “Well,” replied Bob, “the next position above mine is yours. With you only thirty- nine,. I don’t think it’s likely that you’ll be leaving soon. “The fact is that I am leaving soon,’ said Terry. “That’s why it’s even more of a shock to know that you are resigning. I think I’ll be moving to the corporate offices in .Tune of next year. Besides, the company has several plants that are larger than this one. We need good people in those plants from time to time, both in quality control and in general management.” “Well, I heard about an opening in the Cincinnati plant last year,” said Bob, “but by the time I checked, the job had already been filled. We never know about job opportunities in the other plants until we read about them in the company paper ‘All this is beside the point now. What would it take to get you to change your mind?” asked Terry. “I don’t think I can change my mind now,” replied Bob. “I’ve already signed a contract with Wilson.’ Questions (a) Evaluate the communication system at this company. (b) What actions might have prevented Bob’s resignation?
Why is it important to use formatting?
I have program P1 which calls file F1 which has 100 records and following structure 001 .................. 002 .................. 003 .................. 098 .................... 099 ................... 100 .................... Now I want to read these files and write these records in file F2 in following manner. 001 ...... 051 ..... 002 ...... 052 ..... 003 ...... 053 ..... .......... ....... .......... ....... .......... ....... 048 ........ 098 ...... 049 .......... 099 ....... 050 .... 100 ......
What are bootstrap badges?
Explain me what is spin lock?
How does android system manage activity’s life cycle?
Is google sheets better than excel?
what is the command to know how many lf are related to a pf?