SQL Queries Class 10 | Database Management System Important Questions | IT CODE 402 | TERM 2

SQL Queries class 10 IT code 402. Most Important Questions of Database Management System DBMS class 10
📣 Here are the Links to get full Marks in Class 10 IT CODE 402 Boards Exam📣
🔥 Complete Chapter in One Video
• Playlist
🔥 1 Mark MCQ Playlist
• Revision Notes 2023
🔥 2 Mark Short Questions
• 1 Mark MCQ for 2023
🔥 4 Marks Long Answer
• 4 Marks Q. IT CODE 402...
🔥Follow on Instagram
/ _deepak_chaurasia_
I hope this play list will help you to get full marks in Class 10 IT CODE 402.
Visit our website: www.crackmycbse.com for Notes
#term2 #final_revision #itcode402

[@jagbirsingh2793]

Vote 🗳 who are watching it in the morning 13th march 2024 😅

[@Lo-fiBABA522]

Me .😂

[@KajalRani-ft3qx]

Mee too yaar 😂

[@PrakashChawale]

Oh bhai... Aisi bate batayi nahi jati.. Nazar lag jati hai.. 😂

[@swatigajendra9734]

Same 😅

[@by_uniquewings]

Me

[@PrakashGeel]

All the best for tomorrow IT exam.I wish everyone got their expectations marks in their board exam.

[@Shivriti254]

Issi ki zarurat hai ab bss 🥲

[@akankshayadav5673]

Aaj hai bhai

[@rohanrawat722]

Those who comes here for 13 March 'IT' paper😅😅 Edit : kesa gya paper

[@harikishan4505]

Nhi bhai hum toh yaha hindi ke loye aaye h 😂

[@BaljinderSingh-um3fy]

6 baje😂😂😂

[@subhammehta8554]

6 21

[@growwithayan0]

Me

[@artikumari6807]

Hi

[@Harsh__gaming304]

13 March best of luck 👍👍👍

[@AnshumanPattnaik-o6k]

👍🏻

[@RajKumar-ed6ej]

Like karo meri dua h acche marks aayenge sabke

[@ananyasingh12c66]

13 march wale jldi like kre warna tumhe pta h kya hoga *Edit* Mai toh mazak kr raha tha tum logo ne serious le liya🙁

[@KusumDevi-vc8ge]

​@@TarunPonia-58 shi bola bhai 😂😂😂

[@Priti-i3s]

O really 😂😂

[@ananyasingh12c66]

@@TarunPonia-58 🤣

[@sarkaraalekh]

Kyu Dara rahe ho😢

[@suparnabiswas9621]

Ha Bhai pata hai agar nahi kiya toh tu fail ho jayega aur ham sab pass ho jaenge 😂😂

[@ayushydv00100]

2024 students .. puree saal isko ignore karke 1 din pehle aae ho 😂

[@ranjitsamal586]

Yo bro 🤣🤣

[@saroshraza_786]

maths ka paper bekaar Jane ke baad bas ek yahi rasta hai😢

[@ayushydv00100]

@@saroshraza_786 us bro us 🥲

[@armanpreetbassi3666]

​@@saroshraza_786Right bro bahot ganda geya maths ka paper

[@priyawadhai1784]

😂😂

[@vishalbhatti4927]

I hope everyone score 49 /50 in IT boards 😊😊

[@tasneemkausar9589]

Why not 50

[@vishalbhatti4927]

@@tasneemkausar9589 to get this comment 😂😁 ✨

[@akshatvashist]

YE ALAH HEE BKL H

[@ratanpriya5184]

Ultra legends are watching this video 3hrs before exam🤣🤣🤣

[@pop-rl4uf]

2 hrs ago infact😂😂

[@omsaini001]

2.5 hours 😅😂

[@systumm_00111]

Bhaiiii 😂

[@jc6225]

15mins

[@yogyamandhyan560]

1 hour before exam

[@SaiGyaneswar]

Jo bhi exam ke 1 ghante pahele dekh raha hai attendance laga do....🤣 All the Best !!!

[@mirtuyanjaypandey4054]

Mera ko to laga tha ki mai akela abb IT padh raha hu 😂😂

[@SaiGyaneswar]

@@mirtuyanjaypandey4054

[@dhruvsain5758]

This is only the best channel of IT in whole you tube... Thank u so much ap humare liye itni mehnat krte ho... Hum bhi apko nirash nhi krege definitely 95+ achieve krege.. again very very thank u sir 🙏🙏🙏🙏🙏

[@sanjeevsirrajivsirfanclub2751]

Nahi ek or bhe he

[@sanjeevsirrajivsirfanclub2751]

Prateek Kumar classes

[@quandledingleiv6082]

@@sanjeevsirrajivsirfanclub2751 wo video nahi dalte he jada aur, teaching inki zada sahi lagti h

[@shotonandroid452]

Bhai SELECT capital me hi likhna h kya

[@ushajoshi3084]

Swati chawala ma'am👍

[@P_W_____07]

All the best my friends for scoring 50/50

[@Swapnilbajpai.]

Thanks sir help me a lot now i am tension free from SQL 🥰

[@thedenied5047]

Itne time kon dekh rha h guyzz

[@harshavardhanjagtap]

hi

[@ki.ng.sgaming4138]

Hi

[@SonamKumari-j7x1v]

Mine 😂

[@mai_gourav]

Me to so rha hu💀😂

[@kavyasingh1832]

This guy is more passionate and serious about 10th board exam than me

[@atozgyan1513]

are bhai sahab..mai v abhi yhi likhne ayya tha..😂😂

[@sanjayladdha8235]

😂😂😂😂😢

[@AbhayChaudhary-y2p]

Kon kon 4 bje uth gya aaj

[@class10-forStuDy]

Me Kal kuch bhe nahi pada 😢😢

[@AlfSama]

Us

[@Arsh-fv3sk]

Us

[@revlourr]

Us bhaiii 😂

[@arman.basra13]

All The Best!! For 2023 Exams 👍🏻❤️ May You All Get 98% In Board Exams 💫👍🏻

[@AmanKumar-qq1hx]

😧😧😧😧

[@_madhavam]

👍👍✨😅😅

[@bandanasingh6979]

Tumhare muh me ghee sakkar

[@bandanasingh6979]

😊😊😅😅

[@__crimson__feathers__463]

why not the missing 2%

[@Vashu_121]

13 march like -50/50❤❤🎉🎉🎉🎉

[@gokulbansal5520]

Sir I saw your channel today and was absolutely thrilled by the explanation you give of entire chapter in such short time !

[@sunilmaurya8299]

Hii

[@AshishsinghSingh-ph7fr]

𝕂𝕒𝕦𝕟 𝕒𝕓𝕙𝕚 𝕤𝕥𝕒𝕣𝕥 𝕜𝕚𝕪𝕒 𝕙𝕒𝕚😂😂

[@jonnybhaiii8108]

This should be taught in schools with computer but our education system doesn't allows us😑

[@vidhayakjiop4940]

And school's electricity bill also 😂

[@pranishapandey2054]

ya ur right

[@jonnybhaiii8108]

@@vidhayakjiop4940 that's on the school we don't care about bills🌝

[@ANIKET-hi6ry]

@@pranishapandey2054 legend

[@pranishapandey2054]

@@ANIKET-hi6ry yaya I m legend

[@bhumikagathe6323]

In SHOP table ---- in question (e)...why there P_Name is written?

[@Trendhacker123]

Jo like nhi kiya uska paper ganda jye ga . Ingnore at your own risk🎉

[@Pratik-mg7ps]

agar muze 5000000 $ nahi send kiye to tuh kal mar jayega ignore at ur own risk

[@SNAKEZ_KS]

​@@Pratik-mg7ps bhai adha adha kar lete hai mere papa police mai hai kisi ko kano kan khabar nhi hogi 😂😂😂

[@Love_dahiyajaat]

Koni karda like ke pada g

[@Pratik-mg7ps]

@@SNAKEZ_KS mujhe adha diya to tuh adha mar jayega

[@SNAKEZ_KS]

@@Pratik-mg7ps kya Bhai majak bhi nhi kar sakte kya . Saale bsdk luli kaat ke haat mai de dunga samjha na . Napunsak kahika . Lgbtq++ member wale chapri :pratik 🏳️‍🌈🚽💩💩💩🧠🧠➡️➡️🗑️🗑️

[@ahmadbinshakeel]

0:40 _ 1st table ( class ) 6:08 _ 2nd table ( Shop ) 9:35 _ 3rd table 13:10 _ 4th table ( master ) . . . Four important SQL queries questions . . 🔝

[@sujeetanand9919]

All the best for today's exam😂

[@ahmadbinshakeel]

@@sujeetanand9919 🙏🏻😂

[@relaxation2493]

Thanks bhai thoda tume bach gya… kuch bhi nhi ata computer me

[@BADRI_MUSLIM_BOY_313]

Hi 👋😊

[@shrutisingh7264]

All the best 👍👍

[@Curse_User]

All the best for IT exam hope all of you gets gets 50 🎉🎉🎉❤❤

[@duostararmyyt2608]

Kha school me teacher Pure saal ni smjha paye aur sir ne 2O min me concept crystal clear kr dya Hats off ❤️

[@32_shauryarai_x_hk84]

Bhai vo hats off hota h 😀😀

[@duostararmyyt2608]

@@32_shauryarai_x_hk84 bhai autocorrect 🙂

[@skchanneltime8153]

INGNORE BACKGROUND SOUND Focus on Screen 😁😁

[@arunasah5572]

Bhaii.... 3 hrs phele kon aya haii.... 😢😢

[@khansirclasses2845]

Ab 4 marks toh pakka hogye 50 mein se

[@priyawadhai1784]

Yes😂

[@Satyam_4477]

Tomorrow is my pre board and I had many doubts in SQL but this sir explained it is very nice way than my school teacher and I understand this. Thank you so much sir for this great explanation.

[@bhawnarani1222]

Paper Wale din kon ye video dekh rha ha

[@mohitlodhi2191]

Morning me kon he

[@KattarHindu-z6m]

Ultra legends are watching one night before 😅😅

[@_Mannat_13]

Us bro us🥲

[@hariomsharma8072]

I wish everyone get 25/25 Mark's in IT paper. Best of luck to all. ❣️❣️

[@jyotisweta5410]

Thank u

[@hariomsharma8072]

@@jyotisweta5410 your welcome 🤗

[@yashjattalks6948]

OK jayada hoshiyaar mat bann padai kar le

[@sharathraju241]

@@yashjattalks6948 emotional damage

[@savitavaid6426]

@@hariomsharma8072 thanks you so much

[@Juvar.Hancin]

studying for tmrws board exam hop everything goes well lmfao

[@iqbalkhan1203]

2024 batch Wale attendance lagao😂😂

[@narendraduttgautam6301]

Abhi ke thodi der baad? Padhle jaake ye comment likhne se badiya

[@sakshamthakur9273]

​@@narendraduttgautam6301😂👏🏻

[@surjanyadav1170]

I am seeing this video on 7.00am dated 13 march

[@deepanshukapoor5148]

Aur 2 ghnte baad exam hai humara 🤧

[@hindisongs9063]

​@@deepanshukapoor5148hmm

[@HypotheticalGamerzzone]

Kal kis kis ka paper hai IT AI Ca like it 😂

[@_Mannat_13]

Mera h bhai🥲

[@rittikyadav-jz2jb]

DBMS❌BDSM✅

[@LoliLicker9696]

lmao 🗿

[@hassanansari7811]

😂😂😂😂😂😂

[@shreyanshvloggy2005]

Legend are watching 24 may morning..😁😅😅

[@manishkumarverma6651]

by study from this channel , I secure 98 marks in IT(2021-2022)

[@BalhabiBhoi-fz1jp]

But I am sure you have less than 70 in English

[@manishkumarverma6651]

no i got 86 in english because of high weitage of term 2 @@BalhabiBhoi-fz1jp

[@DanishKhan-gu9uu]

Comission is null;..... Ki jgh comission='null'; Kr skte hai na.... Aur between ki jgh >= 10000 and

[@meenalagrawal9969]

Yes

[@SanjayGupta-um7be]

Yup

[@SanjayGupta-um7be]

Bhai second wale main risk mt le

[@sameerkumar4311]

*This video was so much helpful l learned all the concept in just 22 minutes AWESOME* 🤩

[@Hackerboy_47]

EXAM IS TODAY LEGENDS ARE COME TODAY !! BEST OF LUCK GUYS MAINE BHI KUCH NAHI PDHA GHABRANA MAT SARE HI EK JAISE HAI BHAI BHAI EK SATH..... US BHAI US ..... MUJHE BHI BEST OF LUCK BOL DO KOI ..... 🙂🙂

[@parul3311]

Maine sab kar liya

[@suyashbadhe2612]

Bhai same 🤪 Best of luck

[@parul3311]

Ty ji

[@ujjwal5460]

Bhai saare londe SAB EK HI JAISE BHAI saare bhailog aise hi kya ab confidence aaya

[@XYLENZ681]

Back Benchers only study before 1 day of exam

[@asishpreetamgarikina]

Thanks Sir I Finally understood this concept.

[@Pratik.hartwal]

Thanks sir this video only help me for SQL

[@rajnigandha1913]

Legends are watching 5 hours before exam😂😂

[@Raju7963_]

Sir, Please bring more SQL questions and Competency Based Questions SIR..

[@piyushpopa4848]

Mera exam 1 hour ke baad hai aur kuch palle nhi pad rha 😭😭

[@Mohit-kt3yg]

mene b 😵

[@kanak._0203]

Sab hojayega ye question easy hai green skills or entrepreneur wagera easy hai basic hai

[@thikthakgaming6893]

Not slept. Whole night. Sab videos dekh liye and sab ho gaya... Bas ye video baki hai.. Jo nhi lgta meko smjega... Kya karu so jau.. Ya ye dekhu

[@godharshityt8380]

Dekh le bhai ❤️

[@Devgupta-of4co]

Aur bhaiyo agay ek din pehele padh ne 😂😂

[@tahreemozair7451]

Jee bro aagye 🌚

[@HarshPandey-xb9ww]

Mai to exam k din hi aya hu😅

[@Karn-vs1qb]

1 minute ka naman jo subha 6 baje ae😂

[@rushergamming1720]

Gm bro😂

[@rkgaming2.007]

Good morning 😂😂😂

[@SeemaKumari-c5b8u]

Pura saal kuch padha ...par ab lag raha h ki kash padh liye hota

[@Shivriti254]

Exam ke ek din phele sare subjects ache hi lgte hai 🥲

[@-PARNEET]

Today’s exam 6:50 13 feb 2023😂

[@husanpreet3559]

Tomorrow after 11:30 are freedom is start 😂😂

[@tarungurjar]

Bhai ek batt bataoge ki hame answer me e name likhna h ya table me jo name likha wo

[@piyushshankar3173]

@@tarungurjar table mein jo likha hoga voh hi likhna For example agar table mein 'e_name' diya hai toh apko 'e_name' hi likhna hai agar Khali 'name' diya hai toh only name likhna

[@swetarana382]

Bhaiya dought h ki hume table bnana h har answer ke bad

[@pandeyprabal3830]

No

[@rushergamming1720]

Best of luck bhai log ❤

[@kunalchaurasia6737]

Legends 2 hour before board exam

[@ManojGupta-kt4ex]

Best of luck for today exam👍

[@omkarmishra6759]

tq

[@makimaa_04]

Sir is it important to add ; at the end

[@atrathXD]

Noo it's totally ok to not use ; isko use karne pa number Katt jaen ga 😢

[@shubhangiii0110]

Ofc it is if u don't add semicolon at the end marks will be deducted.

[@krishnaradhe6580]

Sir capital and small letter nahi samajh araha 😞😞😞

[@SkDarkWorld]

Small latter sirf jo table se information pucha hai usme use kiya jata

[@SkDarkWorld]

Jitne bhi sql queries hai select,where ,insert,order ... sab capital

[@makimaa_04]

Watching this at midnight on the exam date 🤡

[@Faizmansuri.]

I also

[@rajsaurabh2773]

Me

[@Freak478]

Good night 😴

[@aloof2646]

Best of luck guys

[@Aakash_7303]

Me seeing this video before 3 hour of exam 😂😂

[@onegoodthinking407]

Very well explained भैया आईटी को कोई भी अप से अच्छा नई पदाथा है Thank you so much 🙏

[@shreyaagrahari4373]

Thanku you so much for crystal clear explanation ❤

[@aayaanx]

Thank u so much sir 💖 Actually mene preboard mai command wala 4 marks ka question chor diya tha 🤧 Aur ab aapka video dekkhe pura samajh aa gya , Thank U sir

[@angelyadav6657]

4:09 important

[@HINDUTAV_.]

Sir all my doubt are clear Thank you for your help

[@prathameshdalavi]

10:51 sir can't we write Commission = 'NULL'; Sir please reply...... 😢🥺🥺🥺

[@harshittyagi10a32]

Thinking same

[@nikitaagrawal4983]

No ... We can't use any operator with NULL command... We can use IS NULL or IS NOT NULL only..

[@prathameshdalavi]

@@nikitaagrawal4983 Ok... Thanks 👍🏻...

[@nikitaagrawal4983]

@@prathameshdalavi welcome :)

[@virajmusic1319]

Sir in d can we write WHERE Grade='B' or 'C' Why can't we use equal???

[@vortex3915]

You can use the equal sign if you want but then the syntax should be :- SELECT * FROM Class WHERE Grade = 'B' OR Grade = "C" ; (As an convention, yes, we should use single inverted commas for strings but using double inverted comma won't be technically incorrect either)

[@virajmusic1319]

@@vortex3915 thank you🤗 For clearing my doubt

[@virajmusic1319]

@@vortex3915 SELECT* FROM Employee WHERE Commission IS NULL instead of 'IS' can we use '='. ??

[@vortex3915]

@@virajmusic1319 No, we cannot "=" here. (null value takes only "is" operator.)

[@virajmusic1319]

@@vortex3915 ok thanks

[@manashmedhi6252]

Me a couple of hours before exam🗿

[@vickybhaiya-hu8is]

Me also

[@PunamKumari-ik7bx]

Hii

[@just_another_legend]

🗿

[@naitikmeena3015]

7 baje exam ke 3 hr phele 🥱

[@Rajkiller00]

I know you are working so hard for us. GOD BLESS YOU

[@tusarkantasahoo8593]

And u are becoming play boy your name gave your passion

[@mithileshdesai5310]

You are not the only one starting just now 🙂

[@himanshifr]

😂😂

[@AddaClassand]

😀

[@cp911]

Thank you so much for easy and detailed explaination....May god bless you..

[@riyashree110]

This video helped me to practice SQL queries for my pre board exam. Thank you sir! 🎉😊

[@ganeshukey1774]

BEST channel for learning Information Technology ☺

[@rohanthorat1514]

All the best for tomorrow boards exam 😹

[@adityarajtiwari8759]

Thnx bro

[@adityarajtiwari8759]

Same to you

[@bhaskardhariya3498]

Same to you

[@rituchawla-rk2bc]

Today*😂

[@almond3963]

Today bro

[@wordacademy416]

Thank u sir 🙏 ❤

[@yashjattalks6948]

Hello everyone, legend before 12 hours of exam ✌️ ✌️

[@kamaldagar-26]

Thanks sir but I can't subscribe because it is not my mobile 😃😃😃

[@ranadeep3713]

Thank you so much bhaiya❤️ This video helped me very much in understanding the concept of using SQL and DDL commands in queries

[@_susharo_]

Thank you so much bhaiya!

[@rudranshkaushik694]

Bhai tu soya hi nhi h ya abhi utha h?

[@bgmizone1468]

Mai nhi soya 😴😢

[@divyanshverma6512]

Ajj mene computer me kuch mhi padha kya kru

[@Shivriti254]

Toh padh naa puri raat h tere pas 🗿

[@divyanshverma6512]

To padh hi to raha hu

[@cheems8911]

Sir steps bhi yaad krne honge ? Jaise How to create a table using design view etc ?

[@manamimalakar6220]

Not required..it was already there for practical and not for board written exam

[@bhumichaurasia1299]

Sir hum small or capital letter koi sa bhi use kr skte h command likhne ke liye....?

[@RadheKrishna-yu6sj]

Yes

[@ayaasgaming9094]

Uff ham log to legend hai 🤣 Aaj ke din hami log dekhte h 🙃 This is raajuu bhaiya style 😆😂

[@parasbhatt8742]

ALL THE BEST 💘 DOSTO ❤️❤️❤️💖🤟🤟🤟

[@Crazyprankster34355]

Thank you so much sir today is my exam really thanks a lot sir mujhe bs isi me doubt tha😊😊😊😊💕💕💕💕

[@faheem5079]

Tommorow exam and studying 6 hours before exam😅😅😂😂

[@Gamingbrother24]

Thank you sir for giving me very important questions

[@learnology3611]

Sir please get video of more questions on sql queriy

[@hackerwallah1]

Sir please Sab Chapter Aur Deeply Explaination video laiye plzz🥺🥺🙏🙏🙏🙏🙏🙏

[@dineshmajee2069]

THANK YOU SO MUCH BHAIYAA.🥰🥰 YOUR CHANNEL WILL GROW UP TO MILLIONS OF SUBSCRIBERS.❤❤❤

[@khushabooyadav4440]

Thank uhh so much sir for help me lot🙏❤️

[@refresherszone3852]

Sir, WHERE Commission IS NULL; Or WHERE Commission = 'NULL'; in dono me koi difference h??????

[@parammishra9271]

Thanks sir for helping me to understand SQL language 🙏👍

[@manitakumari1170]

Should we write SQL query in capital letters ????pls reply 😭😭😭😭😭😭😭😭😭

[@anonymous._.aliover]

Yes

[@anonymous._.aliover]

What is exam timing?

[@Calisthenics69]

@@anonymous._.aliover 10:30 se 12:30