SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

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

2215

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

Fidelity,

4 10292

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 12321

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

Fidelity, Oracle,

1 8432

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

Orion Laboratories,

7 10132

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 10705

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 20069

What is materialised View?

IBM,

2 5865

Give an example of Full Outer Join?

IBM,

1 5585

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

IBM,

3619

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