Answer Posted / anjum
There are four types of joins
Inner join (Equi join,Non Equi join)
Outer join (Left outer, Right outer,Full outer)
Self join
Cartesian join
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an oracle user account?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to create a new user account in oracle?
What is backup in Oracle?
How do I call oracle stored procedures that take no parameters?
How to drop an index in oracle?
How does oracle handle read consistency?
How many types of table in Oracle?
How to experiment a data lock in oracle?
What are the varoius components of physical database structure of oracle database?
Explain an exception?
What are the common oracle dba tasks?
master table and child table performances and comparisons in Oracle ?
Give the constructs of a package, function or a procedure.
Compare and contrast between sql and sql server and explain its various functions?