What is a sub query? What are its various types?
How to view existing locks on the database?
What is the usage of synonyms?
What is an oracle user role?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Please explain oracle data types with examples?
How to sort output in descending order in oracle?
Where are the settings stored for each instance in oracle?
What do database buffers contain?
How many types of table in Oracle?
How do you find current date and time in oracle?
How to rename an existing table?
In oracle there is column command, how will you explain that?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
how to handle exceptions in post production