SQL Practice Test1

1. List all employees who have ‘i’ as second occurrence without using like and with using like command.
2. List all employees who have ‘a’ and ‘e’.
3. List all employees who have a vowel in their name.
4. Display list of employees whose salary is greater than commission.
5. List all employees whose month of hire date is jan.
6. List all employees who have atleast 2 A’s in their name.Dont use like.
7. List all employees whose salary divided by rounded commission is greater than 5.
8. List all employees with name scott in uppercase,lowercase, spaces etc in all formats.
9. List all employees who doesn’t have salary ie null.
10. List all employees whose hire date is greater than 1984.
11. List all employees in uppercase, lowercase and initcap.
12. Display first two letter of employee name.
13. Display all employees whose names start with ‘A’.
14. Display all employees who have 2’nd alphabet as ‘A’ intheir names.
15. Display employee name, salary, commission from emp,and if commission is null, make it as 100.
16. Pad all employees with ‘+’.
17. Get sum of salary and commission for dept number 10.
18. Get sum of salary and commission and divide it by’10.5’.
19. Give floor and ceil value for above.
20. Display all the records of emp table whose job is either ‘MANAGER’ or ‘manager’.