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

2158

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

Fidelity,

4 10148

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 12145

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

Fidelity, Oracle,

1 8335

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

Orion Laboratories,

7 9877

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 10477

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 19893

What is materialised View?

IBM,

2 5761

Give an example of Full Outer Join?

IBM,

1 5492

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 3056

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

ABC,

1 4500

Difference between aggregate function and analytical function?

Metric Stream,

3 31396

Difference between NVL, NVL2 and NULLIF

CTS, Metric Stream,

1 36770

What is diff between bulk collect and forall

Metric Stream,

3 27805


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is the current version of postgresql?

1060


what is the difference between undefined value and null value? : Sql dba

1096


What is sql*plus?

1072


Are dml statements autocommit?

1040


what happens if you no create privilege in a database? : Sql dba

999


Difference between truncate, delete and drop commands?

1080


What is sqlerrd?

966


how to select first 5 records from a table? : Sql dba

975


What does sign mean sql?

1099


What is procedure explain with example?

955


What are the types pl/sql code blocks?

1122


What is dynamic sql in pl sql?

1030


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

947


How do I run sql profiler?

1059


What are sql ddl commands?

1084