Top 10 SQL Interview Questions on Scenario based #sql #interview

Top 10 Scenario based SQL Interview Questions @testerhoon28

Q1 -Employees table has employee IDs as well as manager IDs, Can you display employee names
with their reporting manager name.

Answer: We use Self Join concept to derive the outcome
Syntax: Select E1.Empname, E2.Empname as Mgrname from Employees E1 Join Employees E2

Q2 - There are 1000 records in the source and loaded only 999 records into the target, How can we know which record is missing without using Minus Query

Answer: We can use Left Join to find the missing record.

Source Table Join with Target table, all the matched records will be populated and non
matching record from left table will be updated as null

Q3 - Table A and Table B has deptno. Can you find which deptno is not in table A which exists in table
B?
Answer: Right Join with where condition on null check

For Full List of Questions, Please do visit

[yxbznww]

Thanks for uploading...Keep uploading real time scenario based videos in ETL Testing ..Thank you So much...

[ShreeSwami-bqgg]

Mam its request can you please create video on what will be the negative scenarios in ETL testing.

[krushnapatil]

can you upload videos regarding to sql tutorial and full etl testing videos