Skip to contentSkip to footer

Oracle Plsql Developer Interview Questions

Salaries
Interviews

171 oracle plsql developer interview questions shared by candidates

What is faster subquery or CTE What is veiw and materialized view if we delete a table what will be the result of select * from the view created on the table what are analytical functions order salary based on Rownumber,rank,denserank procedure for a palindrome write a syntax of procedure with all blocks what are indexes and its type merge statement (can we use a same table in merge) left join and inner join and right join for below Table 1 Table 2 column 1 column1 1 1 1 0 0 null null null second highest salary
avatar

Oracle PlSql Developer

Interviewed at Tata Consultancy Services

3.5★
Feb 22, 2025

What is faster subquery or CTE What is veiw and materialized view if we delete a table what will be the result of select * from the view created on the table what are analytical functions order salary based on Rownumber,rank,denserank procedure for a palindrome write a syntax of procedure with all blocks what are indexes and its type merge statement (can we use a same table in merge) left join and inner join and right join for below Table 1 Table 2 column 1 column1 1 1 1 0 0 null null null second highest salary

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.
avatar

Oracle PlSql Developer

Interviewed at TSYS|Total System Services

3.6★
Mar 10, 2024

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.

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?
avatar

Oracle PlSql Developer

Interviewed at Reserve Bank Information Technology

3.6★
Apr 1, 2023

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?

Viewing 41 - 50 interview questions

Glassdoor has 171 interview questions and reports from Oracle plsql developer interviews. Prepare for your interview. Get hired. Love your job.