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 44525

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

 5 15285

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

 7 15338

How will you delete a particular row from a Table?

 7 14006

What is the difference between the Primary and Foreign key?

 7 14325

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

 29 32185

What is nvl function?

 4 11328

what is 'force view'?

 3 16617

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 19713

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

 1 9543

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 17841

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

 6 17720

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

 4 16024

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 10568

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

 2 7647

Post New Cap Gemini SQL PLSQL Interview Questions


Cap Gemini SQL PLSQL Interview Questions


Un-Answered Questions

Explain the difference between find and children methods in jquery?

448

Explain tcp/ip applications, services and protocols?

56

What is private visibility on wordpress?

102

What documents will you need to create a test case?

614

what are the pKa values for polyamines?

1567




How do I setup outlook 2019?

1

In mapKit frame work, how to get current user location

1014

Will you like to work in pune?

712

What is a ternary operator?

547

What is use of header() function in php? What the limitation of header()?

463

How many java versions are there?

556

What is difference between a function and a method?

485

Describe the run-time architecture of Spark?

188

Find duplicates in infinite range. Which data structure to be used to give efficient solution?

526

Explain Hybrid And Community Cloud?

324