Not unexpectedly, the manager was particularly interested in my experience in gathering requirements and creating designs.
Preguntas de entrevista para Pl Sql Developer
253 Preguntas de entrevista compartidas por los candidatos | pl sql developer
how to transform a string into comma separated values
I have weight machine, I put 100 KG gold on one side and 100 KG cotton on another side, which weight is heavier??
What is the tnsnames?
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.
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?
Assessment XML: Multiple XPATH Data retrievals from a supplied data set.
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.
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.
Viendo 1 - 10 de preguntas de entrevista