SQL/DB Interview Questions

ืžื›ื™ืœ ืžื•ื“ืขื•ืช
1.2
551 ื‘ื™ืงื•ืจื•ืช
+50Kโ€
ื”ื•ืจื“ื•ืช
ืกื™ื•ื•ื’ ืชื•ื›ืŸ
ื›ื•ืœื
ืฆื™ืœื•ื ืžืกืš
ืฆื™ืœื•ื ืžืกืš
ืฆื™ืœื•ื ืžืกืš
ืฆื™ืœื•ื ืžืกืš

ืžื™ื“ืข ืขืœ ื”ืืคืœื™ืงืฆื™ื” ื”ื–ื•

ืจืื™ื•ืŸ SQL ืžืกืคืง ืœืš ืžื’ื•ื•ืŸ ืจื—ื‘ ืฉืœ ืฉืืœื•ืช ืฉืืคืฉืจ ืœืฉืื•ืœ ื‘ืจืื™ื•ืŸ. ื”ื‘ืงืฉื” ืขื•ื ื” ืขืœ ืฉืืœื•ืช ื‘ืจืื™ื•ืŸ ื ืคื•ืฅ ื‘ื™ื•ืชืจ ื•ื”ื™ื™ืชื” ืœืงื˜ื’ื•ืจื™ื•ืช ืงืœื•ืช.

ื™ื™ืฉื•ื ื–ื” ื”ื•ื ื™ื™ื—ื•ื“ื™ ื‘ื›ืš ืฉื”ื•ื ืขื•ื–ืจ ืœืš ืœืฉืœื•ื˜ ื”ื ืคื•ืฅ ื‘ื™ื•ืชืจ ื”ืฉืืœื•ืช, ื”ืงื ื™ื™ืช ืœืš ืืช ื”ื‘ื™ื˜ื—ื•ืŸ ืฉืืชื” ืฆืจื™ืš ืœืกื‘ื•ืœ ืงืฉื” ื‘ื™ื•ืชืจ ืฉืœ ืจืื™ื•ื ื•ืช. ื™ื™ืฉื•ื ืžื›ืกื” ืืช ื›ืœ ืฉืืœื•ืช ื”ื ืคื•ืฆื•ืช ื•ื’ื ืฉืืœื•ืช ืกืคืฆื™ืคื™ื•ืช ืœื›ืœ ืžืกื“ ื ืชื•ื ื™ื ืžืกื•ื™ืžื™ื.

ืื ืืชื” ืจื•ืฆื” ืœืงื ื•ืช ืืช ืงื•ื“ ื”ืžืงื•ืจ ืœืคื ื•ืช ืืœื™ื ื• ื‘admin@programmerworld.net

ืžืืคื™ื™ื ื™ื:

1. 164 ืฉืืœื•ืช ืฉืชื›ื ื” ืื•ืชืš ืœื›ืœ ืกื•ื’ ืฉืœ ืจืื™ื•ืŸ.
2. ืœืกืคืง ืœืžืฉืชืžืฉ ืืคืฉืจื•ืช ืœื”ืชืืžืŸ / ื”ืชืฉื•ื‘ื•ืช ืฉืœื• ื•ืฉืœื” ื›ื‘ืงืฉืชืš ืชืฆื™ื’ ืขื ืฉืืœื”. ืžืฉืชืžืฉ ื™ื›ื•ืœ ืœื—ืฉื•ื‘ ืขืœ ื”ืชืฉื•ื‘ื” ืฉืœื• ื•ืื– ืœื”ืฉื•ื•ืช ืืช ื”ืชืฉื•ื‘ื” ืฉืœื• ื”ื™ื ืฉื•ื ื” ืžื”ืชืฉื•ื‘ื” ืฉืœื ื•.
3. ืจืื™ื•ืŸ ื”ืขื‘ื•ื“ื” ื”ื™ื” ืงื˜ื’ื•ืจื™ื•ืช ืœื ื•ื—ื•ืช ืฉื™ืžื•ืฉ.
4. ื‘ื“ืงื• ืืช ื”ืฉืืœื” ื ืคื•ืฆื” ืœืื—ืจ ืžื›ืŸ ืœื‘ื“ื•ืง ืฉืืœื” ืกืคืฆื™ืคื™ืช ื”ืงืฉื•ืจ ืœdabase ืขืœ ืคื™ ื‘ื—ื™ืจืชืš.

ืฉืืœื•ืช ืœื“ื•ื’ืžื”

ืฉ) ืžื” ื”ื”ื‘ื“ืœ ื‘ื™ืŸ ืœื—ืชื•ืš ื•ืœืžื—ื•ืง ืคืงื•ื“ื•ืช?
Ans: ืฉื ื™ื”ื ื™ื’ืจืžื• ืžื—ื™ืงื™ื ื›ืœ ื”ืฉื•ืจื•ืช ื‘ื˜ื‘ืœืช ืฉื™ื—ื” ืœื—ืชื•ืš ืœื ื™ื›ื•ืœื” ืœื”ื™ื•ืช ืžื’ื•ืœื’ืœื•ืช ื—ื–ืจื” ื›ืคื™ ืฉื”ื™ื ืคืงื•ื“ืช DDL ื•ื›ืœ ื”ืžืงื•ื ื‘ื–ื™ื›ืจื•ืŸ ืœืฉื•ืœื—ืŸ ืฉื”ื•ื ืฉื•ื—ืจืจ ื‘ื—ื–ืจื” ืœืฉืจืช.. ืœื—ืชื•ืš ื”ืจื‘ื” ืฉื™ื—ืช DELETE faster.Whereas ื”ื•ื ืคืงื•ื“ืช DML ื•ื™ื›ื•ืœื” ืœื”ื™ื•ืช ืžื’ื•ืœื’ืœืช ื—ื–ืจื”.

ืฉ) ืžื”ื• ืžืคืชื— ืžื•ืขืžื“?
Ans: ืฉื•ืœื—ืŸ ืขืฉื•ื™ ืœื”ื™ื•ืช ืฉื™ืœื•ื‘ ื™ื•ืชืจ ืžืื—ื“ ื˜ื•ืจื™ื ืฉืžื–ื”ื™ื ื‘ืื•ืคืŸ ื™ื™ื—ื•ื“ื™ ืืช ื™ื›ื•ืœื™ื ื”ืฉื•ืจื•ืช ื‘ื˜ื‘ืœื”, ื›ืœ ืฉื™ืœื•ื‘ ื”ื•ื ืžืคืชื— ืžื•ืขืžื“.
ืขื“ื›ื•ืŸ ืื—ืจื•ืŸ ื‘ืชืืจื™ืš
27 ื‘ื™ื ื•ืณ 2017

ืื‘ื˜ื—ืช ื ืชื•ื ื™ื

ื›ื“ื™ ืœืฉืžื•ืจ ืขืœ ื”ื‘ื˜ื™ื—ื•ืช ืฆืจื™ืš ืงื•ื“ื ื›ืœ ืœื”ื‘ื™ืŸ ืื™ืš ื”ืžืคืชื—ื™ื ืื•ืกืคื™ื ื•ืžืฉืชืคื™ื ืืช ื”ื ืชื•ื ื™ื ืฉืœืš. ื ื•ื”ืœื™ ืคืจื˜ื™ื•ืช ื”ื ืชื•ื ื™ื ื•ืื‘ื˜ื—ืช ื”ื ืชื•ื ื™ื ืขืฉื•ื™ื™ื ืœื”ืฉืชื ื•ืช ื‘ื”ืชืื ืœืฉื™ืžื•ืฉ, ืœืื–ื•ืจ ื•ืœื’ื™ืœ ื”ืžืฉืชืžืฉ. ื”ืžืคืชื— ืกื™ืคืง ืืช ื”ืžื™ื“ืข ื”ื–ื” ื•ื”ื•ื ืขืฉื•ื™ ืœืขื“ื›ืŸ ืื•ืชื• ืžื“ื™ ืคืขื.

ื“ื™ืจื•ื’ื™ื ื•ื‘ื™ืงื•ืจื•ืช

1.3
493 ื‘ื™ืงื•ืจื•ืช

ืžื” ื—ื“ืฉ?

1.1.03
--Completely Redesign the app for modern user interface.
-- Bringing back show answer button
-- Fixed performance issues now even more faster

ืชืžื™ื›ื” ื‘ืืคืœื™ืงืฆื™ื”

ืžื™ื“ืข ืขืœ ืžืคืชื—ื™ ื”ืืคืœื™ืงืฆื™ื”
Sudhir Mangla
sudhirmangla@gmail.com
204 , Block 3, Mithila , Indraprastha Apartment -1 Indraprastha Colony Faridabad, Haryana 121003 India
undefined

โ€ซืขื•ื“ ืžื‘ื™ืช Programmerworldโ€Žโ€