Interview Questions For Pl/Sql,Sql,Oracle

1 :- Joins :- Equijoin,left, right

2 :- If there are two matching rows in one table and 1 row in ,in inner join how many rows will returned?

3:- Types of indexes?

4:- Primary and secondary Key

5:- Can we pass null values in foreign key?

6 :- triggers, cursors?

7 :- how to find out error in procedures?

 8:- Left join/right Join

 9 :- Procedures

10 :- Collections in PL/SQL :- http://www.oracle.com/technetwork/issue-archive/2012/12-jul/o42plsql-1653077.html

11 :- Function over loading

Collections are used in some of the most important performance optimization features of PL/SQL, such as

• BULK COLLECT. SELECT statements that retrieve multiple rows with a single fetch, increasing the speed of data retrieval.
• FORALL. Inserts, updates, and deletes that use collections to change multiple rows of data very quickly
• Table functions. PL/SQL functions that return collections and can be called in the FROM clause of a SELECT statement.

13 :- Performance tuning :- Adding hint/removing hint:- use_hash,use_nl
14 :- Index/No index
15.RMAN

Interview Question for Bank of America/Sopra/RBS(Oracle,sql/Linux,Pl/Sql)

How to  change in male employees name column  into female employees column  ,create a query?

What is difference between Procedure/Function?

How  to delete duplicate rows from  a table?

What is grep/find/sed?

How to drop a table what happened to synonyms,views,indexes?

What is command for finding out the current version of Linux?

Instead of trigger,Materialized views,DML/DDL?

How to select to  top 5 salaries of the employees?

How to schedule jobs in Crontab for weekly?

RMAN related questions

ALL Joins

outer join

updates in systems
admin related questions

Oracle Architecture

Oracle Architecture :-

How to Make imperfections into beauty....

At the age of 18, graduation,at the age of 23, marriage, at the age of 25, children.....these are the expectations which we Indians have .We want to live in a predefined structure,all set.
But is it really important to follow these old fashioned trends? Is it really important to bound your life around of these things and not try for something different.

Why don't we put our all energies in our career/relationships and most important for our  individual improvements.

Something for our society, have you ever thought about to adopt a children? Have you ever thought about politics, to do something for NGOs. for our country, our villages,city or street.

Yes, we think a lot.Many people want to do something different but they don't able to accept or take any risk.

We are not happy because of the expectations. Expectations of the society.

Why don't we try to break these traditions? After-all, we are the human beings. It's our right to live our life according to us. And have anybody got any benefits after following these traditions?

Have you ever gone alone on a trip?
Have you ever tried to teach a poor child?
Have you ever take risk in your life?
Have you ever help someone without any expectations?
Have you ever do anything for your society?
Is it really important to do marriage just for marriage?
How can you decide your life time decision in only 1 meeting with someone good looking or a rich person?

And if you are following these trends and still unhappy then ask yourself just a question,"why?"

Take a breathe and live your life without following blind traditions.

Give time to your family but not expectations,they love you and will understand your situation.

Communicate with them, make new friends, don't be afraid for a lonely trip.

Give time to new things, at-least try, may be it'll give a new direction to your life.



For example :- I always want to write something but never start.People criticize me for my English grammar and ascent but it never discourage me. Nobody is perfect , neither I am . But I start writing and I know one day, I'll be the best in this language. And trust me its like meditation to do what you want.
I really enjoy while writing and i love to share my thoughts and experiences.May be it'll help somebody..

I have bunny teeth but I never stop smiling.
I am Specie but I love my eyes.
I have short height(according to society) but I enjoy heels.
I have bad communication skills  (according to society) but I am working in a MNC as a Software Engineer.

People have always something for me , they always try to say that I am not perfect not a slim trim but Its never affects me.

Neither for you guys, imperfection is an attractive thing ,at least people notice you.

So enjoy your imperfection and do whatever you want to do.....:)

A trip to Delhi

Is it really important to travel , to meet people,to know about other's culture,habits,customs,food etc.?Yes, its very important.

Travelling can change the point of view of a person,it increase the humanity.

Last year when i travelled from Delhi to Shamli, I met to a boy whose face burnt in a fire.At that moment i realized that we should say  thanks to the almighty.

The superior power ,the universe keeps counting our thanks notes.

God created us ,we should say thanks to HIM. We should ask questions to HIM because only he can give answer to your questions.Its upto you how you receive his messages/answers.It can be in any form verbal/non-verbal.

The more you ask ,the more you get after-all this universe works on newton's third law as every action has reaction.

I learn that people have different mindset and they want to be live in a safe zone, they want to follow only predefined set of traditions.

Neither they want to change it nor take a chance to raise their voice against it. They blindly follow it because they know that its safe.

Its very hard to change something but you can at least raise your voice.

This world is very beautiful,the nature, air,water,birds everything.You should feel the beauty of this nature and also contribute to it as much as you can.

Feel the surroundings,take a day from your routine life for yourself.You can go for shopping but it never ends your desire.

Just go alone to the nearby park or anywhere to feel the reality of the peace.

It will give you strength, a new energy to fight with the negativity and you overcome your fears.Your fear of losing.

My friend, you don't have anything to lose.You take it from the world and leave it to the world.The world is a set of beautiful illusion and you are living in a delusion of having everything.

Garden of Five Senses

Beautiful Garden with Unique Architecture .

You can enjoy with family and friends or you can go there alone, its very peaceful to sit there and seeing the beauty of the nature.Safe for Girls and family.

Different Kind of flowers .

You can take ride on camel/eco-friendly rickshaw.
Bar is located at left side of the Garden.

Very much near about Saket metro station.Auto takes around 50rs.





Very much near about Lodhi Garden and Select City Walk.