Plz help Interview questions related to joins and triggers in database testing

Replies to This Discussion

Permalink Reply by Hitesh Shah on December 1, 2011 at 5:35pm

Hi,

1. About join & What type of joins ?Explain with example?

2. What is difference b/w Join and Union?

Please find attached document of Joins , it will be helpful for you.

Hitesh

Attachments:

• JOIN.doc, 157 KB

• ▶ Reply

Permalink Reply by JO on December 1, 2011 at 7:41pm

thanku hitesh.

It would be more helpful for me if you are able to provide details about triggers too.

• ▶ Reply

Permalink Reply by Hitesh Shah on December 1, 2011 at 7:59pm

Hi,

A trigger is a pl/sql block structure which is fired when a DML statements like Insert, Delete, Update is executed on a database table. A trigger is triggered automatically when an associated DML statement is executed. for example you can search any SQL website.

Hitesh

• ▶ Reply