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)

 23 33717

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

 5 12518

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

 7 11505

How will you delete a particular row from a Table?

 7 10517

What is the difference between the Primary and Foreign key?

 7 11104




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

 29 22678

What is nvl function?

 4 8636

what is 'force view'?

 3 12172

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 13555

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

 1 7887

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 13047

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

 6 13907

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

 4 12382

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 6766

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

 2 5025

Post New Cap Gemini SQL PLSQL Interview Questions




Cap Gemini SQL PLSQL Interview Questions





Un-Answered Questions

Let’s say you have several buttons that reuse the same onclick handler. How will you retrieve the name of the button that fired the event?

3

What is hover effect in css? How we can apply on tags?

5

What do you understand by java virtual machine?

9

You have a 100 coins laying flat on a table, each with a head side and a tail side. 10 of them are heads up, 90 are tails up. You can't feel, see or in any other way find out which side is up. Split the coins into two piles such that there are the same number of heads in each pile.

45

What is dynamic cursor in SQL SERVER?

23




Explain how HDFS communicates with Linux native file system?

1

List some key features in cakaphp 3 over cakephp2?

1

EXPAND_________TOEFEL

983

I have given ielts exam and i got 5.5 bands and i also got three I-20s from the US universities, so my ielts score will interrupt my visa or not? I want to confirm it.

1216

What's c# ?

19

what is the difference between rectifier and converter and commudator?

726

Why would you use find and get rather than to obtain?

17

reason for difference in Balance sheet (Asset side & Liabilites side)

913

Hi evryone, Could you please suggest the best institute for SAP sd in ameerpet?

632

Can you explain what a photoshop lightroom?

1