Not related to job either
Plsql Interview Questions
295 plsql interview questions shared by candidates
What is the difference between sql and Plsql? Why do we use Plsql?
How would you design a DB for a car parking ?
1. Explain about your project. 2.What are the reporting tool you worked on
basics of Java and Oracle
what is trigger ,stored procedure and example of it.
Delete duplicate records from table
Every thing mentioned that i mentioned in resume and more on collections
Difference between primary key and unique key. Questions based on unique key and composite key. Write function to return multiple values. Sql queries to print values, update statement to update multiple rows in single command. Questions around package - Overloading, security wise etc. Question on procedures - Role of proc in package, input parameters etc. Collections questions - methods, scenerio based if delete is used, how to use trim with it. Assign value of one collection to anoth
Most of the questions were from SQL and PL/SQL. Rest everything was behavioral questions.
Viewing 61 - 70 interview questions