Pl/sql Interview Help

[YoungBlood]

db peddalu ...evarina pl/sql medha work chese valu unte itu randi..

 

naku oka fulltime position ki oka startup lo interview undi..phone interview..i have experience on teradata and hadoop(hive) .. its like a data analyst role.. but valu ekuva pl/sql use chestaru. na experience nachindi valaki..and na resume lo pl/sql kuda undi...but i only worked on pl/sql for 4 mnts when i was working on a project on informatica.

 

so if anyone is working on pl/sql , can you help me for an hour or two hours by explaining the concepts ..like a crash course. lite basics and realtime lo em chesthunaru ani.. weekend koncham time isthe..call lo matladukundham. let me know plz.

[sandy437]

[YoungBlood]

Endi vayya ne lolli..mazak ayipoyindi janalaki gif lu pettadam. kompadesi ne photo na endi adi..baya gani la undi adi..pedthe manchi pilla photo ayina pettu bhayya

 

 

 

 

 

 

[fake_Bezawada]

all the best LTT

[sandy437]

Endi vayya ne lolli..mazak ayipoyindi janalaki gif lu pettadam. kompadesi ne photo na endi adi..baya gani la undi adi..pedthe manchi pilla photo ayina pettu bhayya

 

naadi kaadu vayya ..yound blood ani.. pillodi photo ..help kosam chusthnnadu ani..gif esha..

 

ela gif vessi thread lepakapothe .. thread lo evvaru reply vaa

 

[YoungBlood]

sare thanks..eesari ne photo kakunda..itla bramhi photo veste atleast bavuntadi..thanks again..

 

naadi kaadu vayya ..yound blood ani.. pillodi photo ..help kosam chusthnnadu ani..gif esha..

 

ela gif vessi thread lepakapothe .. thread lo evvaru reply vaa

 

 

[pisinari]

Performance tuning chusko...plsql lo phone interview lo peddaga emi adagaru....

Some inputs
Diff between primary key unique key
Diff between clustered and non clustered index
Diff joins
Triggers
Cursors
Packages

avi baga chusko

[duvva_abbulu]

on a scale of 10 how would u rate urself in SQL? 

 

interview lo ee question ki anser em chepthavo cheppu.. nenu topics cheptha

 

 

[pisinari]

on a scale of 10 how would u rate urself in SQL? 

 

interview lo ee question ki anser em chepthavo cheppu.. nenu topics cheptha

 

ilaanti questions sadharanam ga vendor gallu adugutharu....interviewers adagaru....

 

some more topics

 

normalization techiniques

partiotioning techniques

[YoungBlood]

There will be adhoc coding in this project.. so adhoc unapudu , will they deal with store procs . ? this position is for predictive analytics

 

in current project i do adhoc coding in teradata , but we dont deal with procs . we write adhoc scripts..pull data and generate the required extracts for business.