Cap Gemini SQL PLSQL Interview Questions Answers, Cap Gemini Placement Papers, Cap Gemini Technical, HR Interview Questions, Cap Gemini Aptitude Test Questions, Cap Gemini Campus Placements Exam Questions

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 52241

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

5 17568

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

7 18018

How will you delete a particular row from a Table?

7 16735

What is the difference between the Primary and Foreign key?

7 16909

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

29 39729

What is nvl function?

4 13249

what is 'force view'?

3 18502

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 24010

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

1 10796

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 20057

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

6 20059

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

4 18256

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 12605

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

2 8946

Post New Cap Gemini SQL PLSQL Interview Questions

Cap Gemini SQL PLSQL Interview Questions

Cap Gemini SQL PLSQL Interview Questions (15)

Un-Answered Questions

Why is it better to wrap items in combobox item?

173

explain the flash vs. Animated images and java applets? : Adobe flash

903

Explain what are the values that can be taken by property white-space of css3?

645

What are the steps in which unicode codesets can be set with the weblogic jdriver?

1027

What is name hiding in c++?

1219

How do I associate an xml in excel?

998

What is a namenode?

429

what is mean by tax holiday?

2672

Who is the founder of ubuntu?

824

Explain about struts relation to html tags?

1001

Do you know what is priority inversion?

912

Explain what is a product backlog in scrum?

What are spring transactions?

485

Which framework is provided for the programs to interchange information about Linux OS?

1022

Is an arraylist a vector?

1013