Perguntas de entrevista da empresa ZEST Consulting

learn the basic concepts and the project which you explain it properly from the resume. explain all your technical concepts basics of sql java What is a schema object? What are the components of physical and logical database structures in Oracle? What is the difference between VARCHAR and VARCHAR2? What is an Oracle table? What is a nested table? What is a primary key? What is a foreign key? What is a trigger? What is a cursor? What is normalization? What is a package? What is a view? What is a sequence? What is a synonym? What is an index? What is a deadlock? What is the difference between a left outer join and a right outer join? What is the difference between a full outer join and an inner join? What is the difference between a function and a procedure?