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 34695

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

 5 12780

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

 7 11842

How will you delete a particular row from a Table?

 7 10764

What is the difference between the Primary and Foreign key?

 7 11317




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

 29 23346

What is nvl function?

 4 8843

what is 'force view'?

 3 12589

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 13930

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

 1 8002

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 13315

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

 6 14204

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

 4 12626

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 6988

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

 2 5207

Post New Cap Gemini SQL PLSQL Interview Questions




Cap Gemini SQL PLSQL Interview Questions





Un-Answered Questions

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

1310

How can we check the laravel current version?

41

How do I add and delete columns and rows in excel spreadsheet?

1

why swityard is necessrry requirement in any bis power distributin systems?

1064

What are the advantages of using sas?

89




in staad pro. modelling for a parallel scissors chord truss, when i assigned roller support i.e fixwd but with all Fx, FZ, Mx, My and Mz release except Fy... the analysis results " in stability at a joint, with direction Mx or My..what could be the reason...anyone please explaing

2541

Can you delete dmg files after installing?

23

Explain what does the conf.setMapper Class do in MapReduce?

29

Where are variables stored?

30

What is the output for the following code?

56

Explain the difference between include directive and include action in jsp?

60

Do you have any idea how to improve the performance of the bw?

69

What is an abap?

60

What is piping?

50

What is the difference between hashset and arraylist?

21