Write proc with collection? Difference between pk and unique key and questions based on them. Questions related to packages, procedures and functions eg can function return more than 1 value etc. Most of the questions from collections - nested table. How to use trim and extend? Ask to write a procedure and gave scenerios to solve using collections. Questions on performance tuning.
PLSQL related questions will be asked
Questions on performance tuning
Over loading in PLSQL
Mutation of triggers. How to avoid this.
types of subqueries? and difference between them? types of triggers? types of trigger? write a trigger which will using do insert, update and delete on 'employee' table and keep audit in 'audit' table. if inserting insert into table also in audit table if deleting delete from also insert in audit table if upadte is require then update table and this update entry should insert in audit table types of cursors and create procedure take cursor and display emp name and salary.? what is database name? database structure you use to create database objects?
Autonomous transactions
You have experience in performance tuning?
Nada especifico, apenas algumas perguntas técnicas.
Regular interview questions like Your Roles and responsibilities, some project challenges, Performance related queries and some technical questions.
Viewing 81 - 90 interview questions