Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

IBM SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 3332

i 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 18414

There 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 10696

what is the Default Libraries for Oracle Report 6i

2041

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 8292

Suppose 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 11971

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 9759

what is Difference between Having and Where clause?

5 10131

select top 3 sal from each dept?

17 25122

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 9261

What are Global Temporary tables

3 10273

What are Anti joins

1 9737

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 9634

How to call the function and Procedure in trigger?

3 10888

What is the difference between SQL and PLSQL

7 9797

Post New IBM SQL PLSQL Interview Questions


IBM SQL PLSQL Interview Questions


Un-Answered 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?

1977


What is AWS Migration service?

867


What are the features of microsoft word 2013?

459


How much ram do I need for streaming?

747


certificate of export is for which items?

1688


Can you write a function similar to printf()?

883


What is the kernel of the operating system?

724


Write a simple example for the clone() method.

681


Why are parameters used in functions?

728


How do you quickly delete a row in excel?

412


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

2176


Does ip address change with location?

723


What is the difference between a script and function?

1


What is pluck method in laravel?

552


How to see the create table statement of an existing table?

817