Answer Posted / roopesh kumar
(1) Inner or Equei join
(2) Outer or no - equei join
(a) left outer
(b) right outer
(c) full outer
(3) Cartision or cross join
(4) Self join
(5) Natural join
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can %notfound return null after a fetch?
How are functions and procedures called in PL/SQL?
What is the difference between rollback and rollback to statements?
what happens if null values are involved in expressions? : Sql dba
What is the difference between sql, mysql and sql server?
How do I view an execution plan in sql?
How many tables can you join in sql?
What are the types of keys?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Can we call dml statement in function?
Explain what is rdbms?
What are triggers and its uses?
How can you load microsoft excel data into oracle? : aql loader
What are instead of triggers?
How can triggers be used for the table auditing?