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.
#) 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 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
Comments
Post a Comment