Skip to contentSkip to footer

Pl Sql Interview Questions

Salaries
Interviews

294 pl sql interview questions shared by candidates

1)use of group by clause do not tell defination actual or practical use 2)when u delete or truncate table after inser record on same table what effect on PK 3)subquery inner and outer query contain * suppose select * from tb where dept id=(select * from tbnm in this type 4)physical and logical execution of all statment of sql select distinct top from join on where with group by having order by 5)calculate count 6 dept table and emp tabke dept no make FK diff bet char varchar nchar and size vamax() numeric data type normalizaton they given ex prepare all normal forms def not expected select table1, table 2 tell output
avatar

PL SQL Developer

Interviewed at zCon Solutions

3.7★
Oct 27, 2015

1)use of group by clause do not tell defination actual or practical use 2)when u delete or truncate table after inser record on same table what effect on PK 3)subquery inner and outer query contain * suppose select * from tb where dept id=(select * from tbnm in this type 4)physical and logical execution of all statment of sql select distinct top from join on where with group by having order by 5)calculate count 6 dept table and emp tabke dept no make FK diff bet char varchar nchar and size vamax() numeric data type normalizaton they given ex prepare all normal forms def not expected select table1, table 2 tell output

Viewing 21 - 30 interview questions

Glassdoor has 294 interview questions and reports from Pl sql interviews. Prepare for your interview. Get hired. Love your job.