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 51007

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

 5 17193

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

 7 17637

How will you delete a particular row from a Table?

 7 16249

What is the difference between the Primary and Foreign key?

 7 16481

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

 29 38255

What is nvl function?

 4 12899

what is 'force view'?

 3 18252

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 23353

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

 1 10610

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 19762

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

 6 19671

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

 4 17954

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 12264

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

 2 8771

Post New Cap Gemini SQL PLSQL Interview Questions


Cap Gemini SQL PLSQL Interview Questions


Un-Answered Questions

What is the difference between an Anonymous Function and a named function?

965

What is 3NF?

828

What is the best backend for react?

699

What is the automation test?

972

How will you execute campaign? Where you have used campaign explain?

1865

How to create a web form?

993

How can we show that a scope variable should have one-time binding only?

723

How will you set the Dependency in the Quality center? Say if you will fail a test case and two or more test cases are dependent on that particular test case. In this case how will you handle in failing the test case.

2643

Tell me does area of work only involve closed spaces?

3679

What does exit () do in python?

780

What is pl sql block in dbms?

973

Describe session handling in a webform, how does it work and what are the limitations?

1004

Do you know what are the purpose of washing?

1

can u brief me your resume

2680

Received an order from Babu for the supply of goods Rs.200/-. state whether the the following transcation is business transcation or non business transcation? with reson or explaination?

1827