Interview Experience

Attra Interview Experience (PL/SQL 7 Years 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?

Technical:

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

    CREATE OR REPLACE fun1(a IN NUMBER, b OUT NUMBER)
    RETURN number
    IS
    BEGIN
        b := a * 10;
        return 1;
    END;

    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
    NULL	C	NULL
    4	D	200
    5	E	300
    NULL	F	NULL
    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?


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


Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.


Python if , elif and else

Python Conditions and If statements

  • 0
Python for beginners

Learning Python Part 1

  • 3
Struct Alignment and Padding

Struct Alignment and Padding in C++ And C

  • 0
Friend function

Friend function C++

  • 0
Pointers

C++ Pointers

  • 0
Structures

C++ Structures

  • 0
Types of Inheritance in C++

Inheritance and access specifiers C++

  • 0
Java date pattern

Java Date Pattern Syntax

  • 0
Java Date and Calendar

Java Date formats

  • 0
JAVA Data Type

Data types in Java

  • 0
Java unreachable code

Unreachable Code Error in Java

  • 0

Post Comment

Comments(0)

WEB TECHNOLOGY

Articles

×

Forgot Password

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