Questions at techm

1. Difference between for loop cursor and Cursor declaration, Open Fecth and Closing the cursor
2. CASE vs DECODE
3. What are the 3 characteristics of a primary key (Unique+Notnull+?)
4. Deleting duplicate data without using NOT IN
5. Difference between IN, OUT and IN/OUT parameters 
6. How to return bulk data using function 
7. What is Pragma directive
8. Take two tables A and B which are having same structure. Can we write the query to list the records in the table A which are not available in B , using joins

2nd round

1. What is Local and Global Indexes
2. Index Organization 
3. Parellel execution 
4. What is a mutating error in triggers and how to resolve it 
5. What happens internally in architecture when a query fires 
6. what is forward declaration in oracle packages
7. How will you tune if a procedure is performance is poor
8. Analytical functions 
9. how to access an oracle table from a SQL server database 
10. If i have 2 million records in a source table and I want to load those records into a destination table using some business logic. How to get it done ?