DML Error Logging while Inserting records

Create a log table  (Eg: Emp_Err_Log)

  INSERT INTO dw_empl
  SELECT empno, first_name, last_name, hire_date, sal, Deptno
  FROM emp
  WHERE hire_date > sysdate - 7
  LOG ERRORS INTO Emp_Err_Log('daily_load') REJECT LIMIT 25

If the records are exceeded 25 in Emp_Err_Log, the transaction will rollback.

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 ?

Questions at Veri

1. List some Plsql datatypes 
2. How to insert and manipulate XML data 
3. Case vs Decode
4. Procedure vs function
5. exp vs expdp
6. How will you convey that a table needs normalization
7. listagg function