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 34284

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

 5 12667

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

 7 11694

How will you delete a particular row from a Table?

 7 10667

What is the difference between the Primary and Foreign key?

 7 11222




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

 29 22986

What is nvl function?

 4 8741

what is 'force view'?

 3 12370

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 13765

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

 1 7955

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 13177

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

 6 14080

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

 4 12525

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 6897

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

 2 5139

Post New Cap Gemini SQL PLSQL Interview Questions




Cap Gemini SQL PLSQL Interview Questions





Un-Answered Questions

What is difference between html 4 and html 5?

8

What are the different types of statements that are present in php?

38

How do we schedule a batch apex?

5

hi, What will be the connection string coding while developing one web page and the back end of HTML web page is Open Office Base (database). Also what will be insert query if we want to add value of field in a table, field is present on HTMl page. Thx in advance

1008

In one line, show us how you’ll get the max alphabetical character from a string?

24




What is parallel force?

31

Should I use xml or text, javascript, or html as a return type?

39

Can we write dml statement in function in oracle?

2

Why aws lambda is used ?

1

Tell me the use of bit field in c language?

42

Can you explain the various elements of function points ftr, ilf, eif, ei, eo, eq, and gsc?

29

What is grouping ?

19

What is a meta chain?

1

What is a constructor in c#?

43

Can we perform LINQ on XML?

1