Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 36628

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

 5 13256

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

 7 12405

How will you delete a particular row from a Table?

 7 11301

What is the difference between the Primary and Foreign key?

 7 11813




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

 29 24957

What is nvl function?

 4 9348

what is 'force view'?

 3 13474

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 14839

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

 1 8274

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 13880

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

 6 14791

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

 4 13125

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 7455

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

 2 5604

Post New Cap Gemini SQL PLSQL Interview Questions




Cap Gemini SQL PLSQL Interview Questions


Un-Answered Questions

What do you think holds testers back to do automation? Is there a way to overcome it?

143

How do I convert pages to docx?

74

What is the significance of “action 0” in qtp?

153

Mobile on Rupees 2000 purchase for office use not for staff....What entry in accounts..?????

527

What is rpf in networking?

1




While we are doing data migration, how you upload partially closed invoices.

1486

Explain about the risk management function in sap gts?

159

Why is my chrome out of date?

113

Why is jit so fast?

111

How do you you calculate percentages in excel?

34

What is the command syntax that tells you whether you are on the master server or not? And how many master does mongodb allow?

1

How to run an xml file?

142

What is a system 32?

109

What all reports can be used to generate dashboards? : salesforce reports and dashboards

11

How do I view tables in mysql workbench?

107