Try it here
Interview Experience

Attra Interview Experience (PL/SQL 7 Years Experience)


The recruitment was for client MasterCard.

Round 1: F2F

Some questions regarding "Tell me about yourself"?
What kind of projects did you worked on?
What is your current role in your team?
Your responsibilities as team member?


Below are some questions which were asked

  • What is trigger ? -> answer

  • There are 2 triggers trg1 and trg2. Both have been created on table emp on before UPDATE event.Below query was fired

    UPDATE emp SET sal = 100 WHERE empid = 10;

    Which trigger will be fired first and why ?

  • How to be confirmed that trg1 should be fired first and then trg2.

  • Below is the function

    RETURN number
        b := a * 10;
        return 1;

    What will be the output of below query ?

    SELECT fun1(10,20) FROM dual;
  • 2 different types of indexes indx1 and indx2 has been created on table emp(id).Below query has been fired.

    SELECT * FROM emp WHERE id = 1;

    Which index/s will be used ?

  • Below is customer table

    custid	custname	sal
    1	A	100
    2	B	150
    4	D	200
    5	E	300
    7	G	700
    NULL	H	800

    What will be output of below queries ?

    select count(1) from customer;
    select count(2) from customer;
    select count(3) from customer;
    select count(4) from customer;
    select count(*) from customer;
    select count(custid) from customer;
    select count(custname) from customer;
    select count(sal) from customer;
  • Which one is faster count(*) or count(1)?

  • Calculate the difference between salaries of current row and next row order by custid? -> Using LEAD Analytical function

  • If procedure is declared only in spec, will that be compiled ?

  • If procedure is defined only in Body, will that be compiled ? what is this mean ? what is mean if the procedure is in both spec and body?

  • What is table functions and where are they used? -> table function

  • What are collections? Types of collections ?

  • What is bulk collect ? What is LIMIT clause in bulk collect ?

  • Insert data from one table into a history table which has same table structure and find out failed records, insert data using bulk collect. -> Using DBMS_ERRLOG

  • 12c New features -> Oracle 12c New Features

  • What do you look for in explain plan ?

  • What is Cost and Cordinality in Explain plan table?

Writer profile pic

Aditya on Feb 05, 2020 at 12:04 am

This article is contributed by Aditya. If you like and would like to contribute, you can write your article here or mail your article to . See your article appearing on the main page and help others to learn.

Post Comment

Comments( 0)


Forgot Password

Please enter your email address below and we will send you information to change your password.