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 44299

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

5 15227

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

7 15245

How will you delete a particular row from a Table?

7 13918

What is the difference between the Primary and Foreign key?

7 14231

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

29 31949

What is nvl function?

4 11269

what is 'force view'?

3 16539

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 19587

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

1 9502

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 17750

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

6 17618

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

4 15967

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 10509

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

2 7599

Post New Cap Gemini SQL PLSQL Interview Questions


Cap Gemini SQL PLSQL Interview Questions


Un-Answered Questions

How are pointers type-cast?

616


What are the different types of elements present in economics?

1


What is .net mobile forms? : Microsoft dot net mobile

490


how can be the default page settings changed for a silverlight page ?

5


What is the maximum number of rows in access 2010?

462






What do I need to get rpc over http working?

550


How many structures are there?

547


please send the model written test papers to pandu476@rediffmail.com for ET

1708


What is the difference between tuples and lists in python ?

197


What are the advantages of interface in c#?

486


areas for improvement

2064


How do I consolidate duplicate rows in excel?

280


What do you mean by multithreading?

613


What is a parameter in java?

524


What kind of equipment do I need?

586