interview questions with answer for cts
No Answer is Posted For this Question
Be the First to Post Answer
How to drop an existing table in oracle?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
How to run the anonymous block again?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
How to create a stored procedure in oracle?
Explain the types of exception?
How to Truncate Table in Oracle
11. Display the client number and name and the client number and name of the person who referred that client.
What is a partition in oracle?
Explain the function of optimizer in oracle?
How to loop through a cursor variable?
Is oracle the best database?