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 44240

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

5 15219

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

7 15233

How will you delete a particular row from a Table?

7 13912

What is the difference between the Primary and Foreign key?

7 14217

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

29 31927

What is nvl function?

4 11249

what is 'force view'?

3 16520

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 19559

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

1 9494

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 17716

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

6 17600

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

4 15940

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 10499

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

2 7587

Post New Cap Gemini SQL PLSQL Interview Questions


Cap Gemini SQL PLSQL Interview Questions


Un-Answered Questions

What is concatenation and when should it be used?

452


How do I add more rows in excel?

313


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1515


Explain the difference between singleton and prototype bean in spring?

133


What is the function of chain reordering?

601






What is the business purpose of field authorization object in equipment master and functional location master?

789


What do you mean by deployer in splunk?

161


What is difference between class and abstract class in c#?

436


What is sandbox solution?

440


What is Babel in React js?

166


How does maven look for a dependency or resource?

144


Define alv programming in abap?

669


Explain the available thread states in a high-level?

512


What are the types of excitation system?

1442


What is meant by authorization? Did you ever work on it? : sap abap hr

494