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 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)

 24 52944

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

 5 17796

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

 7 18309

How will you delete a particular row from a Table?

 7 17009

What is the difference between the Primary and Foreign key?

 7 17189

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

 29 40578

What is nvl function?

 4 13419

what is 'force view'?

 3 18649

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 24458

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

 1 10896

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.

 4 20253

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

 6 20294

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

 4 18481

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.

 4 12783

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

 2 9065

Post New Cap Gemini SQL PLSQL Interview Questions


Cap Gemini SQL PLSQL Interview Questions


Un-Answered Questions

What is the meaning of your name?

1445

hi, these r the ques asked by tcs.. 1.what do sap hr consultants do in 5phases of asap methodology? how u did documentation? 2.Tables you come across in payroll process?n after copying wagetypes in which table they get stored?n table for indirect valuation? 3.wht r the steps u followed to create dynamic actions? wht r the dynamic actions u created? 4.how u do exemptions in indian payroll? 5.wht is igmod? wht is the use of it? 6.where u save payroll results? 7.how u do evaluation path? dont say the configuration path..say the process.. 8.wht configuration u did in OM in implementation? 9.wht r the steps to do hiring action? n on how many actions u have worked?how u configured all those things?

5070

I am doing my m.sc biotechnology.but i don't know about the interview questions of various company and how i have to face.can you please anyone send that placement papers?thank you

2300

What are HP's objectives for the coming year?

1311

who is your role modal give in few sentances

2262

How does AI intersect with human bias and societal inequities?

167

Corenuts technology interview questions

5895

hello frens. Im Arun from the uk. im planning to apply for tester jobs with 3yrs experience. the problem is i dont have resumes. i have to mention atleast 3 projects (preferably financial projects) in my CV. im totally blank. can u plz send ur CV's to my email.... arunmoses1982@yahoo.com. this would be a great help from you guyz. n u need any help from me? just mail me n ill get in touch with u. Thanx.

1992

what is the architecture of your current project?

2545

Did you contributed the drupal site (any module)?

169

How to Retrieving the program that is associated with a given extension?

1726

hello sir, could u plz send me a sample placement paper for hpcl trainee engg exam..(electronics stream)...hoping to hear from u at the earliest. Thanking you.

2006

How do you know if a set of points is a function?

1028

What is the Splunk latest version?

340

Explain the inheritance in python with an example?

992