FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
56. Where are Jserv log files located?
  Thejserv log files are located in the $IAS_ORACLE_HOME/ Apache /Jserv/log directory and in the format mod_jscrv.log.
Your Name Your Email-ID
Your Answer
 
57. Where do I find the log files of the patch?
  The patch log files are located in the $APPL_TOP/admin/ $TYVO_TASK/log directory. The default name of the patch log file is adpatch.log but it is recommended to change it as patch drivcr.log in order to identify* the patch log easily.
Your Name Your Email-ID
Your Answer
 
58. What is Join?
  Joins are used to combine the result set of one or more tables. A join operation can be performed whenever two or more tables are listed in the FROM clause of an SQL statement.
Your Name Your Email-ID
Your Answer
 
59. What are the types of outer joins?
  There are three types of outer joins :
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN and
  • FULL OUTER JOIN
Your Name Your Email-ID
Your Answer
 
60. What is full outer join?
  The FULL OUTER JOIN returns all those rows from both the tables, where the rows from one table match with the rows from the other table.
Your Name Your Email-ID
Your Answer