Perguntas de entrevista de vagas de Pl SQL Developer da empresa zCon Solutions

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