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 43229

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

5 15003

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

7 14911

How will you delete a particular row from a Table?

7 13644

What is the difference between the Primary and Foreign key?

7 13970

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

29 31265

What is nvl function?

4 11071

what is 'force view'?

3 16250

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 19096

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

1 9385

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 16585

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

6 17359

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

4 15721

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 10095

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

2 7431

Post New Cap Gemini SQL PLSQL Interview Questions

Cap Gemini SQL PLSQL Interview Questions

Un-Answered Questions

Why do we need to use bootstrap?


How can you get the size of an image in PHP?


What is deffered income


Which versions of Merge are Year 2000 (Y2K) compliant?


How to rollback a JDBC transaction?


How is streaming implemented in spark?


How we can install struts?


What is the format of a log message in a web logic server?


How would you define the end of a macro?


Can we have multiple public classes in a java source file?


Which type of server technology is used by joomla?


Which are low level languages?


Tell me what is degree of a relation?


How many bits is a string in java?


How to remove safemode of namenode forcefully in HDFS?