Medium
Oracle Developer Interview Questions
540 oracle developer interview questions shared by candidates
How do you use schedulers and dumping data using schedulers?
views & triggers
cursor types
Tables Partition ,indexing
joins based output
General plsql questions Performance tunning Project work experience
Basic questions that are available on internet were asked, like TRUNCATE and DELETE difference.
asked to write sql queries and asked "what is" questions on plsql
Triggers, type of trigger, Package... only specification enough , body required? Which is mandatory? If specification has 2 procedure and 2 functions and body doesn't have one function among them will it error ? Difference between procedure and package? What's a sequence ? Select seq.curval, seq.nextval from dual; - what will be the output of this query if it is a fresh sequence? Types of indexes? Views... can DML be performed in complex views? Example of implicit cursor ? What are cursors? Keys- primary , unique, composite ? Cursor attributes.. can we use cursor attributes in implicit cursor ? Reference cursor? Where can you find the list of views? What are Trigger event ? Materialized view? How materialized view is refreshed ? What is clustered index? Btree index?
Viewing 431 - 440 interview questions