Solicité el puesto en persona. El proceso duró 2 días. Acudí a una entrevista en zCon Solutions (Pune) en sept 2015
Entrevista
Face to Face Technical
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
Preguntas de entrevista [1]
Pregunta 1
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