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 50903

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

5 17179

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

7 17609

How will you delete a particular row from a Table?

7 16229

What is the difference between the Primary and Foreign key?

7 16462

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

29 38186

What is nvl function?

4 12878

what is 'force view'?

3 18242

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 23327

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

1 10600

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 19740

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

6 19655

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

4 17944

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 12254

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

2 8760

Post New Cap Gemini SQL PLSQL Interview Questions

Cap Gemini SQL PLSQL Interview Questions

Cap Gemini SQL PLSQL Interview Questions (15)

Un-Answered Questions

write a script to verify links on any web page by using descriptive method by creating a description object (give a filter condition only link) ... need to verify expected like name by reading

1841

Define singleton activation mode in .net remoting?

946

How do I open a template?

550

How much of fly ash is allowable in Portland cement and what is the disadvantage when the level of fly ash is increased?

1776

How does a search() in searchmodel work in yii2?

Are you familiar with the partner profile setup? I am sure when these EDI transactions must have been posted through SAP as idoc?

951

When should you use a lookup instead of a master-detail relationship?

434

Is wordpress good for large websites?

167

What is 'write-ahead log' in sql server 2000 ?

1003

Hi, Give me some scenario's where we use gap and how we use gap in sap fico.

2124

Whats the difference between input() and raw_input()?

924

- two pumps must work with them at the same time but if the first pump start the second pump must delayed for some time to start also , with motor rated power = 90 KW and rated voltage = 380 V and rated power factor = 0.85 lag please draw the power and control circuit for it and determine all circuit components parameters that you use it

2699

How does pressure transmitter electronics sensor be used to transmit level measurement parameter?

1595

What are the benefits of interface?

1004

What do you understand by the denormalisation?

920