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 51664

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

 5 17377

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

 7 17826

How will you delete a particular row from a Table?

 7 16492

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 38987

What is nvl function?

 4 13079

what is 'force view'?

 3 18391

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 23709

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 19840

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

How to count groups returned with the group by clause in oracle?

1076

What are your responsibilities as an etl tester?

1160

Will the do-while loop work if you don’t end it with a semicolon?

843

What are the primitive operations common to all record management systems?

981

What are the associated border-radius properties?

667

What is ci in php?

1055

What is flush programming?

1016

What are advantages of data mining?

265

Define psp?

1049

2 v/500amp/hr to 1.80vpc at 20 degree celsious 2v/5ooamp/hr to 1.75 vpc at 77degree farren .this is the capacity of a battery .what is the meaning of this . can i get a detailed explenation

2302

Where javascript variables are stored?

1081

in oracle target stage when we use load option and when we use upsert option?

2285

How would you import data from another ms access database?

852

Write a command to print the second and third line of a file without using nr?

757

What is global database name?

1001