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)

 23 35186

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

 5 12913

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

 7 12003

How will you delete a particular row from a Table?

 7 10888

What is the difference between the Primary and Foreign key?

 7 11428




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

 29 23702

What is nvl function?

 4 8989

what is 'force view'?

 3 12830

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 14159

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

 1 8064

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.

 3 13476

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

 6 14357

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

 4 12762

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.

 3 7107

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

 2 5285

Post New Cap Gemini SQL PLSQL Interview Questions




Cap Gemini SQL PLSQL Interview Questions


Un-Answered Questions

What is sap posting period?

83

What according to you should the government do to increase its exports?

116

What is a lookup table in oracle?

46

How do you check if “m” is a matrix data object in R?

3

What is the difference between the clone() and copy() methods of the dataset class?

89




How to create emails links?

93

How to connect tn in webmethods?

60

What are all the different normalizations?

90

What is 1x 2x?

48

How do I stop all iis services?

41

Can you downgrade your wordpress plan?

4

why do you want to join nabard?

120

Please explain what is 301 redirect?

68

What is the use of scenario manager in excel?

1

how is rrb model question paper for science junior engineer gr.II

2393