ZEST Consulting interview questions

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?