Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 51662

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

 5 17376

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

 7 17825

How will you delete a particular row from a Table?

 7 16491

What is the difference between the Primary and Foreign key?

 7 16679

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

 29 38982

What is nvl function?

 4 13078

what is 'force view'?

 3 18390

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 23708

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

 1 10708

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 19909

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

 6 19838

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

 4 18113

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 12418

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

 2 8864

Post New Cap Gemini SQL PLSQL Interview Questions


Cap Gemini SQL PLSQL Interview Questions


Un-Answered Questions

which materials can l use if l want to use length wave 680 to 900 in hplc

2010

How do I insert an image file (or other raw data) into a database?

969

What is a microcontroller? What is the use of the microcontroller in the robotics?

878

Can We Start A Managed Server If The Administration Server Is Unavailable ?

949

How can we split the data in a table vertically or horizontally?

1

Explain Rule based optimization in oracle apps?

879

1) what template u use to get the data for preparing business blueprint. 2) what challenges u face while preparing business blueprint..pls answer my questions

2103

Why do you need country chart of accounts?

1059

Describe the master page.

957

Where we have to use perl scripting in Testing approach and its importance

2173

What is 'tier 1 capital'?

1157

How to change Replication Factor For below cases ?

1085

What is offer to hire?

1231

Which all field data types can be used as external ids?

461

What is the most recent skill you have learned that related to this job?

1097