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