It was a walkin and took entire day. 2 technical rounds with questions on PLSQL objects, materialized views, report triggers, forms. mostly basics were asked. They are were sensitive enough to provide filling snacks as it was a day long process.