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 34069

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

5 12605

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

7 11613

How will you delete a particular row from a Table?

7 10603

What is the difference between the Primary and Foreign key?

7 11165

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

29 22847

What is nvl function?

4 8699

what is 'force view'?

3 12281

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 13687

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

1 7925

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 13113

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

6 14006

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

4 12470

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 6836

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

2 5085

Post New Cap Gemini SQL PLSQL Interview Questions

Cap Gemini SQL PLSQL Interview Questions

Un-Answered Questions

When should shell programming/scripting not be used?


Explain microstrategy logical primary keys?


What are the features of bazel?


Explain about Commit method?


How do we resolve attribute roles in microstrategy?


Explain the email advantages of blackberry technology?


Is is a public cloud or private cloud?


Why and how will you use an excel sheet in your project?


What is cathode?


What is rotary phase converter?


What is the protocol ?


How can the inflation be measured?


What are the tools used in organic search engine optimization?


How to format a date in angularjs?


From where i can get cds about mechanical related subjests