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 10157

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 12164

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 9907

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 10499

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 5772

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,

3569

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

ABC,

1 3073

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 31417

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 }

Does oracle roll back the transaction on an error?

1013


what are the difference between clustered and a non-clustered index? : Sql dba

1033


What is a nested table in word?

957


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

999


What is dense_rank in sql?

986


What is oracle and pl sql?

1118


how to shutdown mysql server? : Sql dba

1102


How do you run a query?

989


How to change sql*plus system settings?

1054


What is record in pl sql?

1083


How do you delete a table?

1075


Can we create table inside stored procedure?

955


What does over partition by mean in sql?

979


Is pl sql a programming language?

994


Is left join same as join?

996