Oracle Interview Question

Kth smallest largest element from the array, palindrome, second highest salary in SQL,code using having,prime number, SQL code using all statements.