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.

1. Partitioning: use of partitions, types of partitions and when do we need partitions
2. 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.

3. How to read Explain Plan:  what is nested joins, merge joins & has joins
4. Indexing
5. PL SQL: basic questions like & use of GTMP table to aggregate data.
6. 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  Performance Tuning: How do we analysis the code?

3  How do we read explain pain?

4  Scenario : yesterday query was running fine but today its taking time. How to fix this issue.

5  What is parallel hints?

1.How you tune a query

2. With clause function advantage and disadvantage.

3. table partitioning in detail.

4.How you use index in your project