What is a join and explain different types of joins?
Answer Posted / dhivya
Joins are used to fetch the records from more than one
table ,there are 4 types of joins
1.Equi-Join
2.Non-Equi-join
3.outer-join
4.Self-join
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are data modelling techniques?
How to use timestamp datatypes
Explain about relational operator join?
Where is dbms used?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
How is data stored in dbms?
Explain about a primary key?
What is normalization? Explain different levels of normalization?
What are the 18 schemas?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Explain about the relational database?
What is the database development process?
What is database design and development?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?