0 ratings0% found this document useful (0 votes) 39 views23 pagesSQL PDF
SQL Interview Preparation Questions and Answers
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content,
claim it here.
Available Formats
Download as PDF or read online on Scribd
aw)
aa? 64!
én ot ) heute Iyer Io,
alah Bay render pert GOW UTS
a j } Bos
Date bare Colly Biv %| "Dre coe aaa
>) Prtabdros, S-nmabone
too Wd:
ann
now \ono J”
Surv B35
wv? VArbod| a8
VION | 46%
Ne
Wwe will wre
as a
Ooty
DD
Dried oS DB
x)non2 DB
————
Stent +P Doda in tal Re
pesearsees Gre young
(Doro. 30x — CHAR , VARCHAR | Coe v
COD, VARCHAR Cog)
pe (O)) © “tye oY
vercv@Cioe) — Vnye" ~ Swe i
fa on ata ann Bike
Or Cwocks, Set)SLL’ > grtur dh WS for3\
on po
rae rare Yona ;
=A capBar mammary 7 A feo.
pecan et Colla. Hon
> Bro Seetalares
“orede Dalia re
v
Si Yes ———
We oe)
curs Vos goo |
Dee +
Did rore-
LoD. Onsth'oo
C ie acetd GOBUS DBMS Difgoaree ~ >
40s Boa ia a Jeon
Beal.
Des eae ee A
4 Dota Cured wa uM.
Dedeer AIBA In table Ak ks RBBMS -
p)heedeos D8
3) NORD De:
Wa ad ETS
column A
Gat,
ppems :
Fytag oo TIRE IEE py genta
postings) e 4
orm CHAR , VARCHAR | Cree Cio), VARCHAR Ciog)
ape) ne --" mere 90ers tyne Adis
| varcHe(Cioe) "nye" os ‘7
be (Grow Covet sc)Teak
om Mw est :
A St 5
Lanenes Int , oe
Inti eter \
Wowtatans oo
Seals cat
crudtiun te i
ab
-
Deured ” y ; Ry a=
feet Gay 8 png hes
: Cee) sa ah lias sek jHoo to wee Posedan
Grate
ae Create DATAssE oye {ahs by
ro cls
DRop DATABASE dascgaes
Die Pra on se Ay wishs Legge Ge
Goose
ae
| Ss ae DQoo o_ Prt
Stes pete TNO.
. 8
Stor = rales: Arse ri .
al he~-
a - a rome CrPa
poomaca begs WU GALS t AWYy = 20
4 Aww, —-3O
5 VR 4d
| soos
WE eo aaa
create TABLE Sr Odl
6 nt, prrmany Ker. \D Cro Be
aor VArcnA2 Ciso)
Gpo petirmAr (3,25
25
Descese & Sent, ap-
Deep TABLE Shit ; - Detect”
Ces 9 Cr luna ALR Parranum Mu +ap -)
LER TABLE = Shclect
A 4 ABD Arn ipastrardty yapcna (
PERIBE Str dot-
MeHow to Wet Pitan:
Quotes
(er Create Dp raBase Bar?
peta
DRop Parasase Lexi fue;
Dpop trta gece 44 tiaks beage ee
Dooge
Use ante DQoowr Pte FO in.
pee aeBles: —> AH
tas Ros On
a oun CAP
’ re ws)
Mees eS 1 \ AU 20
2 Awd, Yo
| SS) VER 4d
bot
Wwe eas dake
create TABLE SRO Ll
éQ wr, Prrmary Key. | Cro
aorrd \JArcnA Civo)
Gp petzmAr (3,25
23
Descrr3€ Shank; ap.
Drop TABLE Shit . 9 Dearth:
Coadu- Column Ackok Pannanum Brn +e - )
ALTER “ABLE shih pet App Dipoutrasaty vapcnae (wo
DEBIBE Shido
MiPrue com Ate Pons
ALTER TABLE croc DPoP Lepastows ,
VOL OLD
Wm orm
Insert BOTO™ [Link] vAlves Gag
our mol Columa .
Mswen 9. )+
CL lect rare FPonA std
Gre
[ich | came |
[+] swon] ss
TRSERT ty SRA VAWES G. "Vishol” | x-5)
(3, "veloe", O°
SLlect # Prom ohh
CL dams Gre
2 vishl 85
s yen BH
T dort bro my snact GP l Can
sakert ta 2 Column CI os oO
Instat rete Stu daar Gd, namo) VALLES Cray")
th nara Cpe
a Pas Newepteet— ero 18 are QE fe
geuect Uk pnarea FRonA sees -
* fo Moar
Use bo Cppse | g Spek, e
Create TaBee employes ( Seb Dose e.
oO
Emp 2 THe Pacro PRIN KEY, ,
erftama. varcwnr-( ao), ‘ ”
SooPesé = yaecryn(20),
i Salouy 07 LS
peasy
INSEREY Into em plaeo YALves @ commana Be
»” ” ” Wa) eine oe).
- 4 4 VAGbOS | Fry :
aa ‘ lA eg Pile Cp OPE? 2% «
” 1 “a ce , a es 0.41
{ 4 (eae ator (lows
Weg i ued fo giving
Fouad Ont. (ee
Z
i geecr om \\y, (eel lade
P ee rar esis
caeeee ae Hon (\ ‘ee
Le Ly
7 = .,Cnad
7 4 a5,
ZA ns
<7 not 4ua9
serect ¢FRom orp loses
l Here pes 3 iSeco AND JobDese = "JDMDy".
oglect + FROM emploase ;
u* a ,
toh Salohy Bere cen jooos 2? se000-
a me »” Reem orale >
bier tee >fP rene |
: yw
pay ond
Seem phe wb,6Pevad Conds tion i
poste 4
Ly 2 Ct ee nore’ pentee Sg
Lohan pork? cor ode O22 chon
more |
SELECT & porn “employe
WHERE, Cramg 23ke Aue
7 will £e
O|Ps nar a
Com
oc
gacex 4 pron Oaplegse ope
2 Pe Saelfon ang sre
mere: rare Ltke, f- 27° ie cc. Re:
us set Cons bi
Su a ks
als bs oad oft,
ofPy { 7 lo~.
ell : ’
empid enarns Sobctes
1B Mayas: Sols Lo00--
pjos Or
ceuect + (hen Ep ospape pee MUD lef,
WHOS Cyomd® srke Yr. at fusapeke=
vpiise :
ap irte
PDA TE employee 43 ia wr
SET Pos stk = “anacysr's
Tov - x: hy ui
uppaTe employe ‘a.
Series <= Hotty PM M aides
LOHERE- Jobe oleae = “enero cee ae aes ae
: “hacky
Doleke °
pete ophae — op “1,
Loh OmP (A aID
=) ee 1D writ
Disko th ant och a ae
Dist’ oo Ounqro:
alt
select * FRoM emp lo
SELECT Jobo FReM SPloues — > Swe
we
Select DFSTIVCT Joboese frond SeP 4a Ma
Lv
Oh PLAC . pera,
mona,
Ap— rclh b Pit
J Hes wot do fee Provi le
PR Ko 4 in OW OH
Sclecr * FROM emplogon
oppeR By Mare »
ofp. Foe vi!
(ome pin OY rabhiccg
ioe
i ©
BeLect © FROM Wrployer
ORDER By Salany en ams 4 OP moe Wer
ane Aare OY
f ns wil
fe SotHtrol to §G-Lo,
3
V7 pron yw 44 Orde
ond RN ran
select FROM Cm plyg2o ;
(Herne po- kee = Snnersen "9 A ets rap v
os te as: V 4, Aakers echo
OAure™
gecect + pres Onplaae
prow 87 Conse je io
icone | gta Quer eas
Wen anecrer’ THEW 2 arcs J
Cle 120 ED *
Mears:
to o[P +s
ol? a oo wrllesne
Spot ot he
4 Fer OX md Osan
Sob LoseSelect FROM — Emp lope 5
Brad cout of ernPloah
ae ia = et
Setecr COvNt(s eM ampli
wrt (¢ ia Plesen pea = a
Tae Of Courk® = Yow ous
AR Bed. ON nats iyo CD eet aaa ae
sete “@ovt Ce) FRomM Onploysee g
ponmrs, deh-Derp = rove”
Awe Bee
@lect Av (Ga.0ou rep froin evpla4ae
Owe SohDic reset
See
a Gres) ya drove Pot
mon: a! i
pax (5284 ) Mrny( saPoryreese
Bev VASE Crane , Salary. Fro 9Plage
sn Jes enone
AGin 2 fh core
select home, Br cane ventory CA) HG Po
Creepers;
Cord
ie
Sess 6
ey.
geuect vome, @ ConceT (‘rs *; Sp8004 Crone
employer :
ee lecx grat, Comcr oss FepecarCsebany, 65) 5a,
Crorn ope V
bie, Vd pot | 3) 00,008eee a > ee ee aa
a Pho ch™ ary thy 9-9) lo, toy W aged in
‘Leer a0. Colin
SELECT brava, 4eprtsop-Doe., 3) FRor emplouos -
eS 1. apadatypen psd i'n
Dake as Dae ss,
fier cab he employs ppp. Coon He oh De
cunt ae FP a na :
upd — omP lento BD Cine will
GX HDs Sroie-07-08" Ne Aled OO,
: ve Be *
|
|
ypcSeBe. np loose
as prs cBie -'Lo\s— 8s 07",
"ann Lys"
(overe Sao ive
‘fanckrors ia Doro, drc2 Tine
Srect moods 9 Coayrsies Coll bePeovitey
CeLect Date (mod Oy Dochy Dak 7
5etect pose Dato (eprpaecd 2" ory Tene) we
Lockifprene! Ake & Daker>CrroP ing onc hovrey
| SeteeT Job. Due » Aves C5allory ) Fig EmPlosgee
Groop By Beekme a
; \:
C509
Havinas,
Seect Sp -dme coor Compid) Phar Ovplam
Gropp BY Jeb -cSs4c -
| Np at Covnr (empik) v1,
Setect Job- Ba, Caudt Comp wi) Rom OnPl ogee
(one color 71500000
Group ey Seb
\rautnre Coon Corp ida
ORDER BY Say-Soe
CREATE TABLE en Plexo ay
emP-ch “arr PREMARY KEYS > Connround :
Grura yarcwAr (40) NOT pore’ } i }
Joh-clere yan cumin (20) DEI r¢ ; c
Por arcu de to ah a una it ages”,
Bacary IVY ,
4 We Rrkn't Insert OngTaRG Into Hy Crane it
bee feng Or we We tw caramare Gh”notre
a. ard |S cue Lowy npr | Whe 4 fy
i 5 avi. | tow |?) ) |e Ww wv
el 2 Mag
Mais lowe
r ae
| Dap st
aie ‘
empreh | eharrs
Tl Dash.
I Sout
ey a
sce a, Jisvce SD}
: (1A ce voll ke
BC. Per
APs on
elrt
1
Le | |
emp Inrty Av pe Za oR :
eraro vordor Cad) mor morrr,
Job x waoslsd) peravtes Surawyeecd’®, c |
hel wr);
Crom
spsees INTO erplosgeR (caome ,eatory Volets (pan “ |
glect” feo ample e402 * 1002) +va a A
Seb ese! Golan (mpi | nares) 4, p hh,
Avot tow IPIt suv Phau /
; el ;
= \ nar) So” elo uy |
wd. Maxt (owo
- sea)
a
Pe a
bay i? Sp
BAS Ps Os oar
en) el ie
24
(rete TOM mpl sa aurtame£ \
emp ic Tarty AO TACRVEN 7 | | Pa
fare yudertes) worm, ~ ef” a
Job Box vrDoul2e) peravt+ € anornypectl a
| pal wr):
Ss
—quserx tro ereplesfer (some maine) Velutd ("Pays
¢ (ecx* fe aes . ood LysYr Y pro Wo
G Ds dow
bee 99 sehr
Cor oi ne “a
how te
|) Mes ers Bb og fap,
heels aie ge
Creare “0908 orplnges C
lnPiB Tn gpsmnny Vey,”
Youre, varcwap Op
$y Aae yarcunel 22,
Saou m4);
| th wilt 00D CrthorrIs Nor pe
eee
( pucer TABLE — amply ae "a
| mosey norms Vat cube. (20° roor Ora, .
~ bsep ree nu — Con neared»
DLT ARLE GPO
MODIFY — trams yan Cure (85-
oe
ALTER TABLE — Prnploys
AUIE Soy-ckarwe cer Defer MaMa asa! 5
DP op Caf ous
Auer TABL bm Ployes
ALTE — “Sobeere DRP DeFOuT;
Cech .
eit) Teng. ie
zg
me <
(necks er
Drop Chee
Alter tare
4H do 4 aloyn wt have OO He
prov Unig 0g SE Di
WAS ot OWS. vag, 1te x,
+n Do kaa Be 4a fs
Creare vance employes C
[Link] Int prrmrny key,
frame varcnar (40),
[Link] var cnr’ 22),
salou 29)!
x | are Met d
Auten taBLe — @mplo
mepsey nam® jon (yar (303 « N02 a
- chrop ret nut — Connor»
ALTER TABLE —&”Plos
MopsFY — Grams yop (wre (3d)-
ieee
re
PLEr wal bnple
ALI Soon kare cer DEALT ‘NAM Ansef J
Deep dogo
quer TABLE = emPlo
puter sole «Dre DALIT;
4 p 4 :
Consteatet bh Salon “es Marg:
; Teck CoaLAts 710000);
Alter 1ABL€ a
_ peep celeck Dre -sSary -Brand 1'c2 pots? Adios
) rare: 1oAagc Reacl
2 Gaim bod02 2.01/52 BloD
Emp uo > Mure” 25 K+? Pooch A
. Chora JobDexe 5 aUou y Bran OW IFP Ca
Swen ADeren 1000 !. J
2 vashod ares Qv02 3
3 vedo — Mngua :
cn 200 2
ora
Amatie, -toltes Perey ds srOreD 1M.
prota. +ohBi8 ull) ahee, Ee
& » (GIB Frey
( Cea rape bproncd C
Brod i ras PREary KEY-
pn ners you Cae) MOTRPLE
add VAFCIA (2005 3;
Eraplo DN ho
Cicare TABLE Grploseot
Gmp cd oe PRumary bey,
Cram yan cw ar (205
Job-Rax VARCHAR (a0)
Soko, Ith >
ke Drm, Id cua,
my FoReSCW) Key Chton® ick) References
, Ences pionds (hy,
Forercw LNW. 4," ‘
‘ ib 4" wet Pomp in Ba
Pte okt
er, 1 -_ ray mest -Ty Dkep (or4n
Alter TAME Grplo
DROP Foperam REY: Fr. boa.
Belecc KRM omPlosep Bb # p
Do o Ferman My BIKA 5S" Ps
TnRox'-
oe +09 BS
Sry (ay Oo aod pan
omple4ee ? Leck [Link]
(4 hows Index FROM
zt wile foo th EOS ;
Paten
Queda Toh emaprogse
Lap 8 Tnk P. bes
Gore yor OU (20)
TOpRec yor Dax Cav)
Qo, Vor BOs (ho) vague)
4 109;
entrees Fen empleo GA
grow Tebex Fie ov oP
q oa
ty wi Arem too windy DP
# paainaay pen
at ie ‘oo nee etetug
Herd Goring. =ants Ds icoPlen add. vsing B eg = .
oer 2 wd) fe MEN -'
1 TS
Qrenre Intex hart.15 ON Fi Come,
PSE .
Dre py
ao
Alter tance Ompo
Drop INDex a Crary xf.
Dorercbted tee in und prods Webe '
Booty sah :
Ovielete
ad. tobe * :
on role fos fon pea
ar Conrtaund pox tas?
{
On petete TNL 2 oye y, onto i
a Ge: pe a,
On Daere See 2 + ne 2
LEE Roms int sie
ve ea a2 Je Oe heeDy YO
ta “oir - LORS , & Wk raes
pe ‘Ol Cat longa sat
J yr)
a my) jen deg! iA
(ie Spee
Select tad ¥
“a 0
Bron, tD& - empl, pan
brstl ed | eat
goesore
PReons
gerect eonplpaes - Cape eplo yor ark, rn Ploss Tob ch
briond® + L7 nore ed “ omptoyyo ios? By pho)
bron empl psa th = brorD+bs-ch
orver By anPloyer- rps oD Hin Bia -
a
oR
Sect 8s brn me , Eowrle- any) Pee
e “BwER Low "BRA ox 2
ow Qe by = . Byal: Cour bY
B. brvae - ORDAR BY COUNT (ar op)
Day)