I have decent experienced in Oracle database and PL-SQL. I was contacted by BNP Paribas. Rounds were as follows:
Technical Round 1 : Lasted for an hour and 15 minutes. I was asked about role in current project, then went on towards basics of database, SQL, Oracle job scheduling, system tables, cursors and attributes, dual dummy table, types of joins. Functions and procedures and the difference between them, exception handling. Autonomous transactions, triggers. Indexes, their types and use cases as well as performance analysis. Also a fleeting question on Linux (basic directory commands ls, cd, mv, rm, cp). Although my background is Oracle SQL, it seemed that for many questions the answers were expected from perspective of SQL Server db (like magic tables, clustered indexes, etc.)
Technical Round 2: Lasted for about 50 minutes. Same questions on a higher and demonstrative level. Started with current project stack and day to day activities. Types of joins and demo-ing the result set of each join on basis on base table data given in an Excel (actually writing out the result set that we will get when we run the join query). Autonomous transactions, cursors and attributes, returning result set from a procedural code, mutating table errors, DML and DDL statements, constraints, indexes, performance tuning a query, good practices, etc.
Management Round: Lasted for 15 minutes. It was casual. I was asked on previous project experience, reasons for leaving, structure of the project, how any change requirement is attended to, familiarity with GIT.
Management Round 2: Lasted for half and hour. It was very relaxed. I was asked about current project details and any suggestions or improvements to the process, expectations from the new project/employer, expectations regarding work culture, etc. Interview felt like a test of general thinking abilities and outlook.
HR Round : CTC negotiation and test of basic communication skills.