what are packages, functions , procedures, exception handling , dynamic SQL, Create table syntax , indexes , triggers etc
Plsql Developer Interview Questions
274 plsql developer interview questions shared by candidates
Are you able to relocate burglar
syntax of various constraint and what will be output of given query
2nd Max sal, duplicate values, analitical functions, date functions, trunc function
Is it possible to put not null constraint on null values field.
Tell me about yourself and work experience
Records type , index , query tuning
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
1. How do you secure your table data 2. What are normal view and materialized view 3. Refresh policy in a materialized view 4. Triggers. Types of triggers 5. Row level and statement level trigger 5. How will you create a table for logging purpose 6. What is a sequence [Scenario = EMP_ID is created using sequence. Table sequence is stuck at value=12. Record with EMP_ID=15 is inserted into the table. How will you analyze the issue]
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.
Viewing 71 - 80 interview questions