Differentiate between post-database commit and post-form commit?
How to delete multiple rows from a table in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
what is the use of rank function?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
Explain the truncate in oracle?
What happens to the data files if a tablespace is dropped?
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.
Explain the use of consistent option in exp command.
What are the different oracle database objects?
What are the different types of trigger and explain its various uses and functions?
What is the difference between truncate & delete command?