Answer Posted / sam
)Inner Join
a)Equi join
b)Natural Join
c)Cross Join
2)Outer Join
a)Left join
b)Right join
c)Full join
3)Self Join
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Do we need commit after truncate?
What is primary key sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is the difference among union, minus and intersect?
What is sql integrity?
How to read/write files from pl/sql?
Define commit, rollback and savepoint?
Is drop table faster than truncate?
How to return an array from java to pl/sql?
How does a self join work?
Is sql a case sensitive language?
How does sql*loader handles newline characters in a record? : aql loader
Mention what does the hierarchical profiler does?
How many clustered indexes can you have?
explain commit and rollback in mysql : sql dba
