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...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

i have some prob lem to tell me about my self in interview first round ...

2163

wa procedure to return the month and the no'f developers joined in each month.

Fidelity,

4 10156

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

Fidelity,

4 12159

sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)

Fidelity, Oracle,

1 8338

how to retrieve the top 2 salaried persons from a database?

Orion Laboratories,

7 9891

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

IBM,

6 10490

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.

Cap Gemini, IBM,

4 19909

What is materialised View?

IBM,

2 5768

Give an example of Full Outer Join?

IBM,

1 5499

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

IBM,

3567

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

ABC,

1 3068

write a procedure to find top second no from a list of numbers

ABC,

1 4502

Difference between aggregate function and analytical function?

Metric Stream,

3 31410

Difference between NVL, NVL2 and NULLIF

CTS, Metric Stream,

1 36778

What is diff between bulk collect and forall

Metric Stream,

3 27814


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are the differences between implicit and explicit cursors?

1067


What is dialect in sql?

946


how to use regular expression in pattern match conditions? : Sql dba

1030


What is a pdo connection?

1040


How can you get sql*loader to commit only at the end of the load file? : aql loader

1012


what is subquery? : Sql dba

1132


Where can I learn sql for free?

986


What is dml statement?

954


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1151


What is cursor in pl sql?

1116


what are numeric data types? : Sql dba

1060


Is progress software supports to ( pl/sql )?

1037


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1222


what are myisam tables? : Sql dba

1032


What is denormalization in a database?

1053