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 45291

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

5 15489

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

7 15609

How will you delete a particular row from a Table?

7 14247

What is the difference between the Primary and Foreign key?

7 14569

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

29 32856

What is nvl function?

4 11521

what is 'force view'?

3 16959

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 20195

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

1 9639

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 18086

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

6 17953

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

4 16283

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 10753

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

2 7784

Post New Cap Gemini SQL PLSQL Interview Questions


Cap Gemini SQL PLSQL Interview Questions


Un-Answered Questions

What is mrc and what is its use? : oracle accounts receivable

657


Is python similar to php?

576


What does

485


What is the full form of WindowsNT ?

648


What is array simple?

525






purpose of abstraction and interface

1557


What is the Command to mount Content Database?

459


Where are you used type casting?

957


What are the disadvantages of linked list over array?

495


what is the meaning, the advantages and which are the types of evaluate statement?

613


Why is spring boot used? : Spring Boot

181


What is dbkey?

538


How can you correct these errors?

535


what is 24vdc live and dry supply

1842


Can we pass null as argument in java?

543