What is a join and explain different types of joins?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kavita
Join are used to link then retrive data from same or
different database(both have atleast one common attribute).
Join are basically of two types:
1)Equi Join
2) Non equi join
Equi join are those in which we use "=" operator in
condition.They are further divided into
a)inner join:-In this only those rows are return which
satisfy the condition.
b)Outer join:In this all rows are return in which either one
table satisfy the condition
Outer Join are again classified into left join and right join.
2)Non Equi Join are those in which we use ">","<",">=","<="
operator for retriving tuples from two tables
Is This Answer Correct ? | 1 Yes | 0 No |
Explain the family trees and connection by clause.
What are triggers? How many triggers you can have on a table?
what is Normalization?
agregator gives one to many records or many to one record
Explain about a primary key?
How you can make a parameterized view?
What is denormalization and when would you go for it?
What is normalization? Explain different levels of normalization?
8 Answers CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,
Explain about the database management systems.
How to generate OIDS
Given an employee table, how would you find out the second highest salary?
Explain the role of indexing in databases?