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 50470

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

5 17014

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

7 17438

How will you delete a particular row from a Table?

7 16073

What is the difference between the Primary and Foreign key?

7 16304

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

29 37674

What is nvl function?

4 12766

what is 'force view'?

3 18154

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 23075

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

1 10515

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 19608

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

6 19539

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

4 17801

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 12139

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

2 8690

Post New Cap Gemini SQL PLSQL Interview Questions

Cap Gemini SQL PLSQL Interview Questions

Cap Gemini SQL PLSQL Interview Questions (15)

Un-Answered Questions

What is a pure pipe?

702

Discuss about Baluchar Buttedar.

What is the junction object and what purpose does it serve?

389

Name some file extensions in Tableau?

378

What is the range of value of Mach number for Subsonic, Transonic and Hypersonic flow?

1049

How many dimensions can an array have?

817

Which dll handles the request of .aspx page?

899

Which operator is used to combine string values in php?

861

What does tableau do?

317

What is difference between aspx and razor?

883

Explain cell-mediated immune response?

354

Explain the purpose of render() in react.

334

What is public cloud?

582

What are the different industrial sectors using QlikView?

What is the isolation level?