TCS interview questions and answers on Oracle SQL and PL/SQL

Here you can get to know TCS interview questions on Oracle SQL and PLSQL

Make sure you SUBSCRIBE and be the 1st one to see my videos!

--------------------------------------------------------------------------
In my next video i will be providing you the answers for each on of this questions.

Please subscribe to my channel here for more videos on recent interview questions of MNC companies.

Please please LIKE and SHARE my videos it makes me happy.

Thanks for liking, commenting, sharing and watching more of our videos

------------------------------------------------------------------------
--------------------------------------------------------------------------

Thanks to my subscribers !!

[janeyajaneya]

In addition to this :
Diff between primary key & unique+null key
Raise application error & exception init
Rank and dense rank
How to add commit in triggers
Why we need two joins(right and left) when one can serve the purpose by just shifting the table to other side.

[AshishSingh-quns]

As per my knowledge, triggers execute only for dml statements, not for ddl..

[nishantchopra]

Can you explain answer for quest no 2.??? How did you get the answer as 4??

[youtubeuser]

Can you please explain how we got answer 4 in question number 2 -Corelated queries?

[atul.thorat]

Q.2 Ans may be 10 Times will execute .

[RajeshDas-smhv]

Question 2 is not correct it's 10 times