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

  • Cap Gemini aptitute test questions (31)
  • Cap Gemini interview questions (1114)
  • Cap Gemini placement papers (1)
  • Cap Gemini technical test questions (47)



Cap Gemini SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

22 31714

What is meant by Join? What are the different types of Joins available? Explain.

5 11993

How will you select unique values from a list of records?

7 10852

How will you delete a particular row from a Table?

7 10022

What is the difference between the Primary and Foreign key?

7 10703





From an Employee table, how will you display the record which has a maximum salary?

29 21534

What is nvl function?

4 8114

what is 'force view'?

3 11373

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 12775

what is global temporary tables and how use that tables in pl/sql packages

1 7451

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

3 12419

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 13214

What are the steps you take to tune(performance tuning) the code in plsql?

4 11599

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

3 6309

which will default fire first  statement level trigger or row level trigger

2 4594

Post New Cap Gemini SQL PLSQL Interview Questions



Un-Answered Questions

Any one please can u tell me what is composer? An interviewer asked me do u have experience in Composer? its urgent.

792


1. Why do wish to study in canada in the program for which you have been accepted? 2. What is your overall education goal? 3. Why are you pursuing a similar program in your country of residence/citizenship? 4. What research have you done into studies in your country of residence/citizenship? 5. How will this program enchance your employment opportunities in your country of residence? please send me all possible answer i hope your answer will help me a lot...

3929


Can Two Routers Be Used on the Same Home Network?

481


Could you plz tell me in detail and with proper example that what is ROI and explain me with proper example that how will you calculate ROI of a distributor?with Example and Calculation.

1041


how did you calibrate your new year

482






What are the types of Function Modules? What is an UPDATE function module?

539


Based on the Job Description above, please indicate in details why you are a good match for this position?

818


Where can I find version information for BI platform 4.1 and Crystal Server 2013?

630


What control mechanisms might be most appropriate to ensure that action plans match targeted needs

956


What is the use of water table & Kreb stone for drain

631


i cleared the written xam. for the post of atc now what i am going to prepare for the interview plz.guide me i dnt wanna loose this organisation bcoz its my dream company

1034


How is the table sorted when you do not specify field name and Ascending or Descending? On what criteria will the table be sorted? Do internal table have keys?

597


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?

1078


An i m attending dell company interview bt i m rejected in tat last manager round.....they will asked our company h.r u come tis interview after 3 months my 3 months period is over so i should attend for this company interview again...how will get my job pls help me....

2986


Write a function to print all the combinations of a string both uppercase and lowercase without altering the position of each letter.

1092






Cap Gemini SQL PLSQL Interview Questions
  • Software (1)
  • C (2)
  • OOPS (2)
  • C++ General (1)
  • COM DCOM (2)
  • VC++ AllOther (1)
  • Programming Languages AllOther (2)
  • CGI Perl (1)
  • VB Script (10)
  • Shell Script (4)
  • UDP (1)
  • Networking AllOther (1)
  • Visual Basic (1)
  • C Sharp (1)
  • ASP.NET (6)
  • Crystal Reports (1)
  • BizTalk (1)
  • Dot Net Framework (3)
  • Dot Net AllOther (1)
  • Exchange Server (1)
  • Oracle General (9)
  • Database Management (2)
  • Forms Reports (1)
  • Oracle AllOther (4)
  • SQL Server (18)
  • MySQL (1)
  • DB Administration (2)
  • SQL PLSQL (15)
  • Databases AllOther (1)
  • Linux AllOther (1)
  • Unix Commands (3)
  • Unix General (4)
  • Unix AllOther (2)
  • Solaris AllOther (3)
  • Operating Systems General Concepts (1)
  • WinRunner (1)
  • Load Runner (3)
  • QTP (40)
  • Test Director (1)
  • Selenium (1)
  • Automation Testing AllOther (1)
  • Manual Testing (84)
  • QA Concepts (15)
  • Mobile Testing (1)
  • Test Cases (7)
  • Test Documents Reporting (1)
  • Testing AllOther (19)
  • COBOL (21)
  • JCL (16)
  • CICS (14)
  • DB2 (31)
  • IMS (2)
  • Natural (1)
  • MVS (1)
  • VSAM (5)
  • RPG400 (8)
  • COBOL400 (1)
  • DB400 (3)
  • Core Java (17)
  • Advanced Java (5)
  • Swing (1)
  • Struts (2)
  • JDBC (1)
  • Weblogic (2)
  • Java J2EE AllOther (4)
  • Java Related AllOther (4)
  • MQSeries (2)
  • Middleware AllOther (1)
  • SOAP (1)
  • Teradata (9)
  • Business Objects (18)
  • Cognos (24)
  • Informatica (68)
  • Ab Initio (2)
  • Data Stage (20)
  • SAS (3)
  • ETL (4)
  • Data Warehouse General (2)
  • HR Questions (5)
  • WiFi Security (1)
  • SAP Basis (27)
  • SAP ABAP (110)
  • SAPScript (3)
  • SAP SD (96)
  • SAP MM (22)
  • SAP PP (2)
  • SAP FI CO (66)
  • SAP HR (27)
  • SAP CRM (55)
  • SAP APO (1)
  • SAP Business Warehouse (9)
  • SAP Security (24)
  • SAP Netweaver (1)
  • SAP ALE IDocs (2)
  • SAP B1 (1)
  • SAP Business Objects BO BOBJ (1)
  • CRM General (1)
  • Siebel (14)
  • Oracle Apps Technical (11)
  • Oracle Apps Financial (19)
  • Oracle Apps Manufacturing (1)
  • Oracle Apps HRMS (1)
  • Oracle Apps SCM (6)
  • WebMethods (10)
  • TIBCO (1)
  • Mechanical Engineering (2)
  • Electrical Engineering (4)
  • Electronics Communications (2)
  • Engineering AllOther (3)
  • Marketing Sales (2)
  • Banking Finance (3)
  • Audit (2)
  • Taxation (3)
  • Accounting General (15)
  • Accounting AllOther (15)
  • Call Centre AllOther (3)
  • BSRB AllOther (1)
  • Law AllOther (1)
  • Everything Else AllOther (1)
  • English (2)
  • General Aptitude (24)
  • Placement Papers (1)
  • CCNA (1)
  • Sun Certifications (1)
  • Certifications AllOther (1)
  • H1B Visa (2)
  • USA Student Visa F1 Visa (1)
  • L1 Visa (2)
  • USA Business Visa B1 Visa (1)
  • USA Dependent Visa H4 Visa (2)
  • C Code (1)
  • Programming Code AllOther (1)
  • Oracle Errors (1)
  • MySQL Errors (1)