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 45291

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

5 15489

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

7 15609

How will you delete a particular row from a Table?

7 14247

What is the difference between the Primary and Foreign key?

7 14569

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

29 32856

What is nvl function?

4 11521

what is 'force view'?

3 16959

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 20195

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

1 9639

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 18086

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

6 17953

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

4 16283

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 10753

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

2 7784

Post New Cap Gemini SQL PLSQL Interview Questions

Cap Gemini SQL PLSQL Interview Questions

Un-Answered Questions

What is mrc and what is its use? : oracle accounts receivable


Is python similar to php?


What does


What is the full form of WindowsNT ?


What is array simple?


purpose of abstraction and interface


What is the Command to mount Content Database?


Where are you used type casting?


What are the disadvantages of linked list over array?


what is the meaning, the advantages and which are the types of evaluate statement?


Why is spring boot used? : Spring Boot


What is dbkey?


How can you correct these errors?


what is 24vdc live and dry supply


Can we pass null as argument in java?