Try it here
Interview Experience

UBS interview Questions ( PLSQL 6 Years Experience)


  1. Write a query to get the third highest salary of an employee from employee table?
  2. Write a query to get employee name, and average salary of his department against his/her own salary? Empname | Salary | Dept Salary
  3. Display "WELCOME" vertically i.e, each letter in different rows
  4. Write a query to get last day of previous month?
  5. Write a Query to output, all those participants from tab1, which weren't the winners
  6. select * from tab 1
    id    name
    1     divya
    2     lakshya
    3     navin
    4     siddharth
    5     rohan
    select * from  tab 2;
    id  event       winner_id
    1  crossword    2
    2  dart game    3
    3  puzzle       2
    4  quiz         NULL 
  7. We want to assign grades to student based on the marks they score in class-test, if marks are between 10-20 then assign grade C, if they are between 20-30 assign grade B, if they are from 30-50 assign grade A. What options out of below can be used to achieve this?

    Please tick all possible correct answers

    --> IF-Else-if
    --> Case
    --> Decode
  8. Suppose, you want to get a list of class-sections where Average marks of students in that section is greater than 30, which of below will you use ?

    -> WHERE
    -> HAVING
  9. Suppose, you want to get a list of students in each class-section having marks greater than 30 ?

    What will you use?

    -> WHERE
    -> HAVING

Writer profile pic

Manoj on Dec 10, 2020 at 03:12 am

This article is contributed by Manoj. 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.