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 35886

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

 5 13053

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

 7 12168

How will you delete a particular row from a Table?

 7 11040

What is the difference between the Primary and Foreign key?

 7 11586




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

 29 24211

What is nvl function?

 4 9146

what is 'force view'?

 3 13143

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 14456

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

 1 8132

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 13636

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

 6 14535

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

 4 12914

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 7281

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

 2 5418

Post New Cap Gemini SQL PLSQL Interview Questions




Cap Gemini SQL PLSQL Interview Questions


Un-Answered Questions

What are the work queues in blue prism and mention the steps to set the priority for work queues in blue prism?

1

Name other space research instituations in india?

95

What is rdbms with diagram?

91

What is activex plugin?

63

What is the URL for the PeopleSoft homepage?

531




Explain about dental sealants?

116

What are the principal constituents of brass?

152

Explain the difference between frame and bounds?

91

Explain what are the status available in peoplesoft domain status menu?

96

Define capital

1084

What are the different perspectives available in HANA?

15

Explain heat of combustion?

120

What are the performances issue to be in mind when configuring profitability analysis (copa)?

119

How many types of the indexof method are there for strings?

92

What is Document Object Model?

117