What are various joins used while writing SUBQUE

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What are various joins used while writing SUBQUERIES?

=, , IN, NOT IN, IN ANY, IN ALL, EXISTS, NOT EXISTS.

(Continued on next question...)

Other Job Interview Questions

• Can the default values be assigned to actual parameters?
• Where is Concurrent Manager log file location.
• What is main concurrent Manager types.
• How to start Applications listener ?
• What are main configuration files in Web Server (Apache) ?
• What are various joins used while writing SUBQUERIES?
• What is FNDSM ?
• What is difference between a formal and an actual parameter?
• How to check if Oracle application 11i System is Rapid Clone enabled ?
• How you will avoid your query from using indexes?
• More...