Monday, April 10, 2017
Fidelity - Performance Tuning Interview Questions
What is AWR, ADDM, ASH
What is the difference between AWR, ADDM
Tell a scenaio when u have used AWR
What are the different wait events
What db sequential file read, db scattered read events, and its difference.
What is a cursor.
what are its attributes
what is type , rowtype
what is bulk collect
how do u identify the limit set to bulk collect
What is the difference between btree and bitmap index.
There is an sql statement that ran fine in the morining, but in the evening its taking long time. How do u identify the issue and tune the statement.
How do u find the difference in SQL plans of the same statement if there is a change in the SQL plan.
Popular Posts
-
Experience Level - 3- 5 Years SQL Questions: Brief about your experience, skills and projects you worked on. 1.Differenfe betw...
-
Data Dictionary tables/Views contain information about the database and its objects. These are automatically created and maintained by oracl... -
E 1st round Queries on joins, group by , not in, rank , dense rank, decode, case. (for half an hour to write queries ,given different ta...
-
Select * from a where hiredate+60 < sysdate; (here hiredate is non-unique index, so query scanning index range or full table scanning. ...
-
Generate Sequence of Numbers from 1 to N using SQL Query SELECT LEVEL AS ID FROM DUAL CONNECT BY LEVEL <= 20; ... -
Stages of Processing SQL Statement: SQL statements pass through several stages during their processing: Parsing Binding Executing O...
-
Introduction Both LAG and LEAD functions have the same usage, as shown below. LAG (value_expression [,offset] [,default]) OVER ([quer... -
About Temporary Tables : Temporary tables are database tables that hold session specific data Each session can only see and modify its o... -
Parameter Modes in PLSQL procedures and functions are IN , OUT, IN OUT. The differences are as follows.
