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 48238

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

5 16343

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

7 16638

How will you delete a particular row from a Table?

7 15287

What is the difference between the Primary and Foreign key?

7 15583

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

29 35617

What is nvl function?

4 12238

what is 'force view'?

3 17698

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 22013

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

1 10137

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 18947

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

6 18953

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

4 17149

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 11569

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

2 8329

Post New Cap Gemini SQL PLSQL Interview Questions


Cap Gemini SQL PLSQL Interview Questions


Un-Answered Questions

Which animal is hyena family eats insects?

772


Is it possible to disable the tax calculation?

748


What is the hottest part of flame in fire?

719


Why is tomcat called catalina?

707


How does internet of things ( iot ) vary from industrial internet of things ( iiot ) ? Give benefits of iiot.

1


What is a nullreferenceexception and how do I fix it?

780


what is the hint? how to use it to reduce the query processing in program?

7177


Describe the purposes and advantages stored procedure?

690


hi every one, i want to make a coal grinder to mil 3 or 4 tons of coal dust per hour . if you guys help me with photos or some tecnical drawings that would be very kind of you.

1848


what are the possible test cases for online jobs search portal..if its a job seeker module and any 1 if u had worked on this proj pls share the bugs with sev and priority pls frends i need replies for these queries ..thanks in advance

7413


Is impala intended to handle real time queries in low-latency applications or is it for ad hoc queries for the purpose of data exploration?

43


Explain how do you connect to sql server database without using sqlclient?

735


Can we store images in mysql database?

693


How many types of installations?

744


How do you control the spring life of a bean?

257