trig,procedure and function,delete and drop
Plsql Developer Interview Questions
274 plsql developer interview questions shared by candidates
A lot of programs to be written
PLSQL related questions will be asked
Questions on performance tuning
what is nvl; what is substring; what is joins, what is pseudocolumn, what is cursor, how to get the dense rank for table.
Over loading in PLSQL
Mutation of triggers. How to avoid this.
Basic SQL ans PLSQL concepts
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
Viewing 81 - 90 interview questions