Not unexpectedly, the manager was particularly interested in my experience in gathering requirements and creating designs.
Pl Sql Developer Interview Questions
280 pl sql developer interview questions shared by candidates
how to transform a string into comma separated values
Asked about my experience installing new releases of software
I have weight machine, I put 100 KG gold on one side and 100 KG cotton on another side, which weight is heavier??
find top 10 employee by using DENSE RANK.? SELECT 10 FROM DUAL MINUS SELECT 5 FROM DUAL.? Query for deleting duplicate rows. Write a procedure to store all the data from a table to a collection table.
What is the tnsnames?
Calculate the no of exp of the employees from the joining date from table?
Out of n records the query to pickup 3 to 8 records from a table?
They asked me to write an Oracle procedure that would select data from 3 tables and update a 4th table. (handwritten, not in Oracle) This was to be completed in 15 minutes.
Materialized Views. Whether once can drop an MV, if yes then what will happen to its table. Types of MV. Grants and Privileges. Synonyms. Autonomous Transactions. Parallel Hints. Benefits of Packages. Performance Tuning.
Viewing 1 - 10 interview questions