PL-SQL interview question
#) What type of Data Model used in your current project. #) Source of Data flow in the current application. #) About WITH clause and benefits #) How Partitions work in Table's #) What are all the performance tuning techniques used in your projects #) How analysis SQL Plane. and a few SQL questions in joins, index. Partitioning : use of partitions, types of partitions and when do we need partitions Performance tuning : a) Steps to tune SQL query, use of HINTS b) Scenario: yesterday query was running fine but today its taking time. How to fix this issue. How to read Explain Plan : what is nested joins, merge joins & has joins Indexing PL SQL : basic questions like & use of GTMP table to aggregate data. Second highest salary within a department – give an example of WITH CLAUSE, ROW ID, ROWNUM, etc. 1 Types of Partitions: When its required? What is RANGE partition? 2 P