What is different types of joins?
No Answer is Posted For this Question
Be the First to Post Answer
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
How to use values from other tables in update statements using oracle?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
Explain the blob datatype?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
What is self-referential integrity constraint ?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
Does a Before form trigger fire when the parameter form is suppressed ?
Is oracle a language?
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 use subqueries with the exists operator in oracle?