Technical Round(Round 1)
------------------------

NAME    sAL    GENDER
---------------------
X	10000	M
X	9000	F
Y	8000	M
Y	7000	M
Z	6000	F
Z	5000	F
A	4000	M
A	4000	F

1) How to write a query that displays the name that exist in both male and female gender.
Ans:- SELECT NAME FROM EMPL WHERE NAME IN (SELECT NAME FROM EMPL WHERE GENDER='F') AND GENDER='M';

2) Display a names which starts between a and m. use refcursor and anonymous block.
Ans:-  
declare
o sys_refcursor;
f_name employees.first_name%type;
begin
open o for
select first_name from (select first_name, ascii(first_name) as nid from employees) where nid between 65 and 77 order by 
first_name;
loop
fetch o into f_name;
dbms_output.put_line(f_name);
exit when o%notfound;
end loop;
close o;
end;

3) What is mutating error.?

4) If i am updating t1 and selecting data from t1 in trigger asscoiated with the update t1. Will mutating error occurs.?
Ans:- yes it occurs 

5) How to solve mutating table error.?
Ans:- Either change row level trigger to statement level trigger or use pragma autonomous transaction in a trigger.

6) If i am using pragma_autonomous_transaction in trigger.? How would i end the transaction.? Should i use commit 
   in trigger to end transaction.?
Ans:- We can't give commit in trigger. the transaction will be ended by commit in stored procedure.

7) If i am updating row 7 in t1 and updating same row in trigger(which contains pragma autonomous transaction) 
   which is associated with it. what will happen the cursor waits or what happens.
Ans:- deadlock error occurs

8) Can i use DML in a function.
Ans:- No

9) If i need to use DML in a function.? how can i do it.?
Ans:- Use pragma_autonomous_transaction

10) can select udf can contain DML statements.
Ans:- YES

Technical Round(Round 2)
------------------------
1) What is your life ambition.
Ans:- Oracle Architect

2) What are the things you must learn to become an oracle architect

3) What are the different database that you know other than oracle.

4) What are the different between oracle and MSSQL

5) What is migration.

6) Why migration is so difficult, could you explain.

7) Difference between stored procedure and function in compiler.

8) Difference between 'ON COMMIT' in materialized view and trigger.

9) which is fast either function or stored procedure.

10) Update statements;
    Insert statements;

   you are creating an trigger for above insert command. Update statements & Insert statements run 
   sucessfiully and trigger fires an error what will happen Either it gets to rollback if yes then 
   till when it gets rollback or entirely get rollback.
    

HR Round(Round 3)
-----------------

1) What comapny you are working.

2) Tell me about your company.

3) What do you know about our company.

4) What is your father's name.

5) What is your fathers's profession.

6) What is your mother's name.

7) What is your mother's profession

8) Are you from chennai.

9) What is the current salary.

10) What is the expected salary.

11) What is your date of birth.

12) What kind of manager you want to work in.

13) What do you expect from your company.

14) Any misunderstanding with your colleagues has happen.

15) What is the official notice peroid ? Is it negotatible

Note:- All the rounds are face to face