Is it possible to put not null constraint on null values field.
Oracle Software Engineer Interview Questions
537 oracle software engineer interview questions shared by candidates
Do you think GIT version control is better than Tortoise SVN when it comes to multiple programmers working on the same piece of code?
Oracle architecture Sql Joins External tables
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
What Are Locks & what is Deadlock condition?
They asked me generally about my experience, they checked if the needs of the project matched my skills
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.
What is Oracle apex and architecture
Viewing 171 - 180 interview questions