Cap Gemini SQL PLSQL Interview Questions Answers, Cap Gemini Placement Papers, Cap Gemini Technical, HR Interview Questions, Cap Gemini Aptitude Test Questions, Cap Gemini Campus Placements Exam Questions

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 50736

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

5 17108

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

7 17546

How will you delete a particular row from a Table?

7 16153

What is the difference between the Primary and Foreign key?

7 16398

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

29 37972

What is nvl function?

4 12839

what is 'force view'?

3 18210

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 23225

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

1 10566

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 19686

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

6 19598

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

4 17889

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 12207

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

2 8739

Post New Cap Gemini SQL PLSQL Interview Questions

Cap Gemini SQL PLSQL Interview Questions

Cap Gemini SQL PLSQL Interview Questions (15)

Un-Answered Questions

What is J2EE Agent and port number?

564

Explain joins in oracle?

980

Is there any relation between modprobe.conf file and network devices?

829

Is null === undefined?

865

Explain how do you convert from pascal to torr?

890

Is laravel backend?

658

What is the difference between count and distinct count?

841

What are scalars?

938

What is Tableau Repository?

464

How can we measure the residual voltage in dc machines?

1769

Name some second level cache types?

328

On what factors can you map the success of automation testing?

967

How to restrict a flow to particular user?

473

What is the relationship between apache hadoop, hbase, hive and cassandra?

What is the difference between slice and dice and cross tab report?

992