Describe the Index, Types of index, At what situation we have used? Which one s better than others?
1 3332i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
12 18414There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
4 10696If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
2 8292Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
4 11971a. 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 9759why we go for package? what are the advantages of using instead of seperate procuderes or functions
3 9634Post New IBM SQL PLSQL Interview Questions
6.NEED OF ONGOING MANAGEMENT CYCLE( Case Study ) Sidney Greenburg was appointed the position of the director of marketing for a small electronics component manufacturer. The company had its revenues growing at the rate of 20% each year and in 1982, they were at 30 million level The president felt that the growth of the company required serious planning efforts to determining strategies product emphasis and new product development. Mr. Greenburg realising the need to develop the marketing plan developed a suggested format to obtain inputs from his regional sales managers. The format to obtain divided into two parts (a) territory brief for established status of sales activities and (b) territory plan asked for identification of key goals, strategy & resources required to accomplish stated goals. Sales forecast by products was requested for 3 plan Yrs. Tom Rosenfield was the marketing manager for Europe He was previously in the engineering department & was assigned to Europe because of his technical& Foreign language capabilities. He replied to Mr.Greenburg as follows: “While I will complete the forms on the country brief& country plan promptly I have some conceptual problems with them time& time again we have been requested for projected figures I remember putting together a presentation for the Executive Vice-President (VP) & Treasurer last year. Great we educated those guys but what are the results of such formality? The projections have not yielded specific results, resources are used at a minimal level & we are not generating needed sales. So it is my contention that while goals projections& forecasts provide immeasurable guidance for a company with stable sales & developed product lines, for us a fledglings (young) industry, they distract from the job at hand. My plan has always been to hit the market- as hard I am able & I believe this should hold true for all other regional managers. We have large amounts of resources held up in ineffective’ marketing planning efforts such as these need to redirect these efforts to self rather than compile data. We need more people beating the pavement (action) rater than sitting on their desks developing plans& strategies (contemplation) Sell, sell, sell. Get the backing as big as possible. Planning is wasteful. Let us concentrate on aggressive sales & optimize sales volume at any cost. A. What has Mr.Greenburg not done to accomplish his planning tasks? B. Is Mr.Rosenfield right in making his comments in response to Mr. Greenburg’s request? C. Is Mr. Rosenfleld performing his management function. D. What would you do if you were Mr.Rosenfleld’s boss?
What is AWS Migration service?
What are the features of microsoft word 2013?
How much ram do I need for streaming?
certificate of export is for which items?
Can you write a function similar to printf()?
What is the kernel of the operating system?
Write a simple example for the clone() method.
Why are parameters used in functions?
How do you quickly delete a row in excel?
Can you tell me what was your last/ current project? What exact tasks were you responsible for? Give details in terms of testing done and tools used if any.? I need sample answers to this very major and important question. As detailed as possible. Thanks
Does ip address change with location?
What is the difference between a script and function?
What is pluck method in laravel?
How to see the create table statement of an existing table?