Lec-123: Top 15 SQL Interview Questions Answers | Most Important Questions for Job Interview

👉Subscribe to our new channel: / @varunainashots
►(1) Differentiate DBMS vs RDBMS: • Lec-2: Introduction to...
►(2) What is Primary Key in DBMS: • Lec-9: What is Primary...
►(3) Foreign Key in DBMS: • Lec-10: Foreign Key in...
►(4) Constraints in SQL: • Lec-58: Constraints in...
►(5) All Types of SQL Commands with Example: • Lec-53: All Types of S...
►(6) Difference between Delete, Drop & Truncate in SQL: • Lec-57 Difference betw...
►(7) Differentiate Group by and order by : • Lec-61: SQL Queries an...
►(8) Types of Joins: • Lec-38: Introduction t...
►(9) Nested Subquery VS Correlated Subquery
Nested Subquery: • Lec-60: SQL Queries an...
Correlated Subquery: • Lec-68: Correlated Sub...
►(10) Pattern Matching: • Lec-107: Like Command ...
►(11) Find 2nd highest salary: • Lec-60: SQL Queries an...
►(12) SQL vs My SQL: • Lec-52: Introduction t...
►(13) Varchar vs Varchar2: • Lec-124: CREATE Comman...
►(14) Triggers: • Level Trigger vs Edge ...
►(15) ACID Properties: • Lec-74: ACID Propertie...
► Structured Query Language (SQL)(Complete Playlist):
• Structured Query Langu...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Database Management System(Complete Playlist):
• DBMS (Database Managem...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on RUclips: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmash...
► Follow us on Threads: www.threads.ne...
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: [e-mail]

[@Cringy69]

Itna saar gyan pela....aur last me sirf 1 second me thank you bolke video end.
you turely know the value of time for people....salute to you.

[@satyakurakula4048]

1. DBMS & RDBMS
2. Primary Key
3. Foreign Key
4. Constraints & their types.
5. Diff types of SQL commands
6. Diff b/w Delete, Drop & Truncate
7. Diff b/w Group by & Order by
8. Types of Joins
9. Nested subquery vs Correlated subquery
10. Pattern Matching
11. Find 2nd or Nth highest salary
12. SQL vs MySQL(noSQL)
13. Varchar vs Varchar2
14. Triggers
15. ACID properties

[@satyamthakur-8]

Thanks dear 😊

[@vrushabhsatalkar8477]

Thank you❤

[@Randomguy-zy3bc]

Tq

[@pasdes6091]

madam 12 th question is SQL vs NoSQL sir have also corrected the question
and MySQL is software for SQL

[@hemantnatani1950]

@@satyamthakur-8 dalle

[@ispeakfactslol]

Recently gave a written exam in sql and the questions were based on the topics you mentioned above. Thankyou for your guidance.

[@souravboss01]

Very intresting , in 15 min you cover all most all important topics of SQL

[@AmitGrover321]

Really nice refresher before my Interview. Thank you so much !

[@gurikashyap5921]

I have watched this man during my Btech (2017-2021) cleared all my exams now preparing for an interview of SQL

[@mr.unique4974]

Sir , you are awesome . I've never seen such an easy explanation of SQL concepts. Thanks a bunch! :)

[@alphagaming5432]

mamu

[@ashwinisanap3539]

aap beech me khade ho jate ho, fir kuch dikhta nahi hai, itna acchha aap explain karte ho fir ek bar read karna to jaruri hai na

[@tanmaygupta8288]

😂😂😂😂😂😂😂

[@harshalkamble8582]

😂😂😂 True

[@rohitnagar3157]

Sahi baat hai

[@AnithaYanamala-t8v]

Andha hai kya

[@sudeepigoel4824]

Best Video on SQL I watched. Appreciated your effort. I watched the video on 2x speed and you gave the clarifications very well. Cannot stop my self to comment.
I want to add one one thing
Delete and truncate. Delete just delete the rows and new value inserted will be from the next incremented value.
Truncate reset the index as well. new value inserted will be from 1

[@maheshg5332]

Sir please start a series on important questions for all subjects..

[@fmpodcast1916]

Very needed

[@manishasagar4767]

good

[@rambabudarla6643]

​@@manishasagar4767 hiiii

[@dikshakaundal9381]

​@@fmpodcast1916🎉🎉🎉❤❤😂🎉😂🎉😂😂😂🎉🎉😂🎉😢❤😢😢😢😢😢😢😢❤😢😢❤🎉😂😂❤😂😂😢❤😢😢🎉😢😢😢😢

[@DOYOUKNOW-pc8ui]

​@@manishasagar4767kay apko job mili

[@bsivakeshava15]

Excellent class...I am appreciate you sir because u r not take too much to explanation ..it is very good

[@RazaKhan-me3ds]

Outstanding explanation in a very understandable language

[@TayyabaMangalkhan]

Ap kamal ho ❤ hamny to BSCS kia hi apky tutorials dekh dekh k h

[@mutantbeatz87000]

Forgotten to comment, coming back, it was fantastic session, well summerised, very thankful to you sir❤

[@stith_pragya]

Thank You So Much for this wonderful video....🙏🙏🙏

[@ManishSharma-lo1ql]

Sir....! If I'm not wrong varchar and varchar2 both sizes are not same. varchar datatype is used to store upto 2000 character where as varchar2 datatype is used to store upto 4000 characters in their particular memory allocation.

[@nivisworld1513]

Yes ...ur right

[@aanchalgumber7424]

Yes

[@schoudhury1911]

A best teacher in you tube world to teach in very easy way .

[@SandeepKaur-xl1gl]

In 11th question you can order in descending order ACC to salary can use offset
and limit to get the 2nd highest salary

[@prasanjitdas2295]

Awesome lecture

[@SunainaAgarwal1308]

Please suggest some books for MCQ for Rajasthan Programmer. Syllabus --- Networking, Data structure

[@sanketp9543]

This is really great Thank you ❤

[@priyapurwar6471]

I am learning from your videos do u have any files or ppt that contain SQL interview questions can u share that ,it would be helpful for me

[@sahilrawat7966]

thanks for this video like all of them were my doubts and chock points and thanks for clearing the concept this video cant get more relevant than this tysm!!

[@VishalYadav-gk1kg]

Nice Explanation , thank you sir !

[@harneet_284]

Very easily explained. Thank you!
Sir please SQL CODING questions bhi krva do for interview 🙏

[@omkarrkd10]

yess Sirr much need of query questions

[@sukhvinderoberoi7336]

Informative and Concise. explain how to answer if I used a trigger in my project in my interview? I know definition is not enough to crack the interview, they want to know how I used i my project.

[@romagahatraj9282]

Thank you Sir for excellent content 👏

[@vishnuvitalkatabathini9095]

Hello sir your teaching is excellent but, can you explain in English so that other language Students also get better understanding on concept,so please sir I am requesting you explain also in English .

[@SaurabhSingh-f3b]

Are u from pakistan😅,

[@Tony_Gaming189]

Is it necessary to having a concept of dbms before joining the sql 21 days challenge course please reply.....

[@ankitkalwar5570]

Wonderful explanation, thank you so much

[@SonamSingh-fe6ib]

Your teaching method is excellent 🥰😍🥰

[@lakshminarayana3168]

Excellent boss 👏👏👏👏

[@muntahariaz4332]

My most favorite channel 🤩🤩

[@DeepakNandaygol]

Thank You Sir

[@sulagnaduttachoudhuri3838]

thank you so much sir, please make similar videos on cn and os as well

[@arjunghosh8654]

Very helpful information

[@KhalidAfridi1]

Thank you so much dear. Awesome

[@deepushankaryadav6698]

11th question answer is wrong like in that command we cannot print name and max(salary ) at time.
in aggregated query without group by it does not work

[@aryanshinde1822]

Really very nice explaination

[@soumyabohre1484]

Very well explained Sir 🙏

[@devotionalvibes1]

Sir, please make video on imp questions of operating system

[@obaiahlakkineni6065]

Sir, Will you be able to provide solution for below question?
We have two records and five columns. Actually there is Duplicate record in that two records but one column is having different name for two records. So, my question is how to write a SQL query to remove that duplicate record in the Dashboard?

[@haritapopat4174]

Then use that column which is having different name

[@AshwinSurendran-ss8wh]

hi sir pls include diff b/w rank and dense rank also.it is a very imp question asked in interviews

[@nitinmilmile5569]

Sir pls make one video on Linux interview que. and PLSQL

[@krushnnabaviskar4131]

nicely exapined

[@ROSUJACOB]

Thanks bro!! today i cleared my interview!!please also add wildcard entry and joins.

[@NIDHIMAHESHWARI-x8u]

kis company mai ? or kya question pucha gya aapse?

[@beingrishi6450]

4:52 Auto Increment is also CONSTRAINTS

[@pratibhasalunke1512]

You are just awesome sir.. 🙌 tysm.. 💫

[@Sanjaysview]

Thanks its helps a lot!!!

[@rje401]

Your second highest sal query will not execute becuse u r applying aggregate function like max(sal) with name ,while name is not agg function you have to write 1 more query for that at outer side

[@salilshukla9]

agreed, he providing wrong information he must check things first if they are executing or not.

[@ReetKaur-en2fj]

Very well explained. Thank you

[@vaishali-gosavi]

kya aap automation sikha sakate hai...??? aur manual ,API,unix, HPALM,JIRA,IB project,test scenario,test case writing, in sub topic ke bhi imp Q.with ans ke liye seperate topicwise vedio bnayenge..? and i request u plz HPALM an JIRA ,test case writing and test scenario kaise bnaye ye achhe se sikha dijiye.

[@GodzillaSN07]

sir ,this is so good video that helps and guide for learning more😃😃😃😃

[@MahRahman1]

thank you

[@CodePressAcademy]

Thanks a lot very good explanation

[@preetinamagond9649]

Thank you so much sir this video really helped for me in my interview

[@dipikazad3522]

very helpful

[@prathapganesh7021]

Awesome thank you so much sir

[@vpowerup]

sir u left indexing, diff between function and procedures, what is a procedure

[@Nature-kc7vz]

Thank you sir 🙏

[@YogirajsinhZala-s5y]

Thank you :)

[@viralvirtuallearning]

Very Easy explanation

[@dattatrayarathi1014]

Thank you for sharing the imp video

[@Reva_Prime]

Thanks sir

[@MonikaRani-hi5fq]

Good afternoon sir. Sir kya ap problem solving thought 'c' ka practical ke tyari bhi kar do
Please

[@aniruddhkarekar2818]

Just add one more point of normalization here. Thanks you're the best guide to a cs student !

[@ShahrinIslam-l1f]

sir you are best❤🇧🇩

[@milindborkar6387]

Sir please make practice video on SQL so can gain practical knowledge about queries that are going to ask in interviews

[@gauravwadekar6055]

Hello, one correction we can roll back if we are truncating the table... Just now i have checked we need to use begin tran before truncating the table.

[@niteshkhanna690]

thankyu bro

[@bioenergy7943]

brilliant! pls keep it up !

[@swathisharvirala3175]

Great Explanation

[@barkhaharwani9175]

Can we enroll now for SQL course?

[@ailoveu100]

Thanks bro!❤

[@vikramnimma]

In interviews they ask scenario type questions... like find no of duplicates, delete duplicates, 7th highest salary...

[@NIDHIMAHESHWARI-x8u]

which company?

[@barneymathews6827]

Love from Pakistan

[@yogamayaa]

Make a similar to this for solving queries...for interviews

[@gkthestoner]

super awesome

[@pepetikesavasiddhardha7852]

very helpfl thanks a lot

[@sivanageswararaomeda1819]

Acid property it means SQL Normalization right

[@Masti-Masala-Bihari1]

Pura class ka video provide kraiye

[@prateekchougale9532]

Sir.. your videos are so useful 🙏

[@sushmitha8247]

Tqsmmmmmm🤩💕

[@somveerkhaunkar6191]

Just awesome sir🙏👍

[@nehagupta8408]

Sir, plz make videos of Mongo DB.

[@anitamartolia2320]

Dear sir can u write a query daily base interest of account add a particular table when amount come in account daily not same

[@smegala3815]

Sir please teach this concepts in English language also

[@ihgamingfun6295]

Gud explanation 👍🏼👍🏼👈

[@abhilashaagrahari4392]

Sir also make video on core and advance java interview questions and answers 🙏🙏🙏🙏🙏

[@VanshShrivastava-x2i]

Tysm

[@pranaykukadkar7092]

advanced sql bhi batao sir....like Characterspecific,

[@ajith.k5517]

Thank you sir

[@madhavin4086]

For Experience people also get interview questions can be like this or not

[@sreemoyeepradhan]

Sir , how do I get access to all your videos ? Some of the videos are missing...... For example...after lecture 112 , the playlist directly jumps to lecture 123.....

[@sreemoyeepradhan]

Please suggest a solution, Sir

[@ajithaldankar607]

Thank you

[@abhinavjha3840]

Is it related only to gate exams ?

[@poojashembewad2017]

Your sql course is live classes or recorded videos

[@vijay_madane03]

Pattern matching me % ka meaning kya he sir??

[@always_muni_2]

Over all I've learnd this

[@shrutikukey]

2nd highest salary query is wrong you can only select numerical values with arithmetic functions, you cannot select name or any other character value with arithmetic functions.