Posts

Showing posts from December, 2011

Next set of Interview Q & A

1) How do you handle teams emotions.  2) How do you avoid leakages when there is lot me context switching.    3) Automation approach.    4) How do you manage when there is more work compared to your came width.  5) Conflict management.

Procedure to disable all user constraints on Oracle

BEGIN   FOR c IN   (SELECT c.owner, c.table_name, c.constraint_name    FROM user_constraints c, user_tables t    WHERE c.table_name = t.table_name    AND c.status = 'ENABLED'    ORDER BY c.constraint_type DESC)   LOOP     dbms_utility.exec_ddl_statement('alter table ' || c.owner || '.' || c.table_name || ' disable constraint ' || c.constraint_name);   END LOOP; END;
1) How do you decide the defect prone area ? 2) What do you do when you have resources with low competency ? 3) Example of risk and how to mitigate it ? 4) What do you do to increase teams productivity ? 5) What is effort estimation process in your company ?